{"id":481870,"date":"2026-06-01T09:33:57","date_gmt":"2026-06-01T09:33:57","guid":{"rendered":"https:\/\/savepearlharbor.com\/?p=481870"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=481870","title":{"rendered":"redb \u2014 \u0442\u0438\u043f\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0435 \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u0434\u043b\u044f .NET \u043f\u043e\u0432\u0435\u0440\u0445 Postgres\/MSSQL: \u0431\u0435\u0437 \u043c\u0438\u0433\u0440\u0430\u0446\u0438\u0439, \u0431\u0435\u0437 Include, \u0441 \u043f\u043e\u043b\u043d\u044b\u043c LINQ"},"content":{"rendered":"
\n
\"Strong<\/p>\n
Strong Typing \u2014 Real C# Classes, Not Just JSON blobs<\/figcaption><\/div>\n<\/figure>\n

\u041f\u0440\u043e\u0431\u043b\u0435\u043c\u0430<\/h4>\n

\u0412\u043e\u0437\u044c\u043c\u0451\u043c \u0442\u0438\u043f\u0438\u0447\u043d\u044b\u0439 enterprise-\u043e\u0431\u044a\u0435\u043a\u0442 \u2014 \u0441\u043a\u0430\u0436\u0435\u043c, \u0437\u0430\u043a\u0430\u0437. \u041e\u043d \u0441\u0432\u044f\u0437\u0430\u043d \u0441 \u043a\u043b\u0438\u0435\u043d\u0442\u043e\u043c, \u043f\u043e\u0437\u0438\u0446\u0438\u044f\u043c\u0438, \u043a\u0430\u0436\u0434\u0430\u044f \u043f\u043e\u0437\u0438\u0446\u0438\u044f \u2014 \u0441 \u0442\u043e\u0432\u0430\u0440\u043e\u043c, \u0443 \u0442\u043e\u0432\u0430\u0440\u0430 \u2014 \u043a\u0430\u0442\u0435\u0433\u043e\u0440\u0438\u044f, \u0443 \u0437\u0430\u043a\u0430\u0437\u0430 \u2014 \u0434\u043e\u0441\u0442\u0430\u0432\u043a\u0430 \u0441 \u0430\u0434\u0440\u0435\u0441\u043e\u043c, \u043e\u043f\u043b\u0430\u0442\u0430 \u0441 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f\u043c\u0438. \u0418\u0442\u043e\u0433\u043e 10\u201330 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0441\u0443\u0449\u043d\u043e\u0441\u0442\u0435\u0439. EF Core:<\/p>\n

var order = await context.Orders    .Include(o => o.Customer)    .Include(o => o.Items).ThenInclude(i => i.Product)        .ThenInclude(p => p.Category)    .Include(o => o.Items).ThenInclude(i => i.Discounts)    .Include(o => o.Shipping).ThenInclude(s => s.Address)    .Include(o => o.Payment).ThenInclude(p => p.Transactions)    \/\/ ... \u0435\u0449\u0451 \u0441\u0442\u0440\u043e\u043a 30 ...    .FirstOrDefaultAsync(o => o.Id == orderId);<\/code>
<\/a><\/div><\/pre>\n
\u0417\u0430\u0431\u044b\u043b \u043e\u0434\u0438\u043d Include \u2014 runtime. \u0414\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u043f\u043e\u043b\u0435 \u0432 \u043c\u043e\u0434\u0435\u043b\u044c \u2014 \u043c\u0438\u0433\u0440\u0430\u0446\u0438\u044f \u2192 \u0437\u0430\u044f\u0432\u043a\u0430 \u043d\u0430 DBA \u2192 staging \u2192 deploy. \u0422\u0440\u0438 \u0434\u043d\u044f \u043d\u0430 ALTER TABLE ADD COLUMN<\/code>.<\/p>\n
\u0425\u043e\u0442\u0435\u043b\u043e\u0441\u044c: \u043e\u043f\u0438\u0441\u0430\u0442\u044c \u043c\u043e\u0434\u0435\u043b\u044c \u043a\u0430\u043a C#-\u043a\u043b\u0430\u0441\u0441, \u0438 \u0447\u0442\u043e\u0431\u044b \u0434\u0432\u0438\u0436\u043e\u043a \u0441\u0430\u043c \u0440\u0430\u0437\u043e\u0431\u0440\u0430\u043b\u0441\u044f \u043a\u0430\u043a \u044d\u0442\u043e \u0445\u0440\u0430\u043d\u0438\u0442\u044c. \u0411\u0435\u0437 \u043c\u0438\u0433\u0440\u0430\u0446\u0438\u0439, \u0431\u0435\u0437 \u043c\u0430\u043f\u043f\u0438\u043d\u0433\u0430, \u0431\u0435\u0437 Include.<\/p>\n
\u041d\u0430\u043f\u0438\u0441\u0430\u043b. \u0412\u044b\u043b\u043e\u0436\u0438\u043b \u043f\u043e\u0434 Apache 2.0.<\/p>\n
Production case<\/h4>\n
\u0420\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0432 \u043f\u0440\u043e\u0434\u0435 \u0432 \u043a\u0440\u0443\u043f\u043d\u043e\u043c HoReCa-\u0434\u0438\u0441\u0442\u0440\u0438\u0431\u044c\u044e\u0442\u043e\u0440\u0435 (~150k \u0437\u0430\u043a\u0430\u0437\u043e\u0432\/\u043c\u0435\u0441, ~20k B2B-\u043a\u043b\u0438\u0435\u043d\u0442\u043e\u0432, \u0441\u043e\u0431\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u0430\u0432\u0442\u043e\u043f\u0430\u0440\u043a). \u0412\u043d\u0443\u0442\u0440\u0435\u043d\u043d\u044f\u044f TMS \u2014 ~500 \u0432\u043e\u0434\u0438\u0442\u0435\u043b\u0435\u0439 + ~50 \u0434\u0438\u0441\u043f\u0435\u0442\u0447\u0435\u0440\u043e\u0432, 3-\u043d\u043e\u0434\u043e\u0432\u044b\u0439 \u043a\u043b\u0430\u0441\u0442\u0435\u0440 (Xeon, 4 \u044f\u0434\u0440\u0430 \/ 8 \u0413\u0411 \/ 50 \u0413\u0411 SSD \u043d\u0430 \u043d\u043e\u0434\u0443), ~3 \u043c\u0435\u0441\u044f\u0446\u0430 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0439 \u0440\u0430\u0431\u043e\u0442\u044b, 10\u201315% CPU \u043f\u043e\u0434 \u043f\u043e\u043b\u043d\u043e\u0439 \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u043e\u0439. \u0418\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u0438 \u0447\u0435\u0440\u0435\u0437 redb.Route: SAP, Kafka, RabbitMQ, GPS-\u0444\u0438\u0434\u044b, \u041c\u0435\u0440\u043a\u0443\u0440\u0438\u0439, \u0415\u0413\u0410\u0418\u0421, \u0427\u0435\u0441\u0442\u043d\u044b\u0439 \u0417\u041d\u0410\u041a, \u0424\u0413\u0418\u0421 \u0417\u0435\u0440\u043d\u043e.<\/p>\n
\u0412\u0442\u043e\u0440\u043e\u0439 production-\u043f\u0440\u043e\u0434\u0443\u043a\u0442: \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0430\u044f \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0430 (~672k \u043e\u0431\u044a\u0435\u043a\u0442\u043e\u0432, ~8M \u0441\u0432\u043e\u0439\u0441\u0442\u0432). \u041d\u0438 \u043e\u0434\u043d\u043e\u0439 \u043c\u0438\u0433\u0440\u0430\u0446\u0438\u0438 \u0437\u0430 \u0432\u0435\u0441\u044c \u0441\u0440\u043e\u043a \u044d\u043a\u0441\u043f\u043b\u0443\u0430\u0442\u0430\u0446\u0438\u0438. \u0414\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u043f\u043e\u043b\u0435 \u0432 \u043c\u043e\u0434\u0435\u043b\u044c \u2014 \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u043e \u0432 C#-\u043a\u043b\u0430\u0441\u0441 \u2192 SyncSchemeAsync()<\/code> \u2192 \u0433\u043e\u0442\u043e\u0432\u043e.<\/p>\n
\u041a\u0430\u043a \u0432\u044b\u0433\u043b\u044f\u0434\u0438\u0442 \u0432 \u043a\u043e\u0434\u0435<\/h4>\n
\u0412\u043e\u0442 \u0440\u0435\u0430\u043b\u044c\u043d\u0430\u044f \u043c\u043e\u0434\u0435\u043b\u044c \u0438\u0437 redb.Examples<\/code>:<\/p>\n
[RedbScheme(\"Employee\")]public class EmployeeProps{    public string FirstName { get; set; } = \"\";    public string LastName { get; set; } = \"\";    public int Age { get; set; }    public decimal Salary { get; set; }    public string Department { get; set; } = \"\";    public DateTime HireDate { get; set; }    public string[]? Skills { get; set; }    public Address? HomeAddress { get; set; }    public Contact[]? Contacts { get; set; }    public RedbObject<ProjectMetricsProps>? CurrentProject { get; set; }    public RedbObject<ProjectMetricsProps>[]? PastProjects { get; set; }    public Dictionary<int, decimal>? BonusByYear { get; set; }    public Dictionary<string, Department>? DepartmentHistory { get; set; }}<\/code>
<\/a><\/div><\/pre>\n
\u042d\u0442\u043e \u0432\u0441\u044f \u0441\u0445\u0435\u043c\u0430<\/strong>. \u0412\u043b\u043e\u0436\u0435\u043d\u043d\u044b\u0435 \u043a\u043b\u0430\u0441\u0441\u044b, \u043c\u0430\u0441\u0441\u0438\u0432\u044b, \u0441\u043b\u043e\u0432\u0430\u0440\u0438, \u0441\u0441\u044b\u043b\u043a\u0438 \u043d\u0430 \u0434\u0440\u0443\u0433\u0438\u0435 RedbObject \u2014 \u0432\u0441\u0451 \u0445\u0440\u0430\u043d\u0438\u0442\u0441\u044f \u0438 \u0437\u0430\u0433\u0440\u0443\u0436\u0430\u0435\u0442\u0441\u044f \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438.<\/p>\n
\u0421\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c:<\/strong><\/p>\n
var employee = new RedbObject<EmployeeProps>{    name = \"Alice Johnson\",    Props = new EmployeeProps    {        FirstName = \"Alice\",        LastName = \"Johnson\",        Age = 28,        Salary = 85000m,        Skills = [\"C#\", \"React\", \"SQL\"]    }};await redb.SaveAsync(employee);<\/code>
<\/a><\/div><\/pre>\n
\u0417\u0430\u0433\u0440\u0443\u0437\u0438\u0442\u044c:<\/strong><\/p>\n
var loaded = await redb.LoadAsync<EmployeeProps>(id);\/\/ loaded.Props.FirstName \u2192 \"Alice\"\/\/ loaded.Props.CurrentProject.Props \u2014 \u0437\u0430\u0433\u0440\u0443\u0436\u0435\u043d \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438\/\/ loaded.Props.Contacts[0].Value \u2014 \u0437\u0430\u0433\u0440\u0443\u0436\u0435\u043d \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438<\/code>
<\/a><\/div><\/pre>\n
\u0417\u0430\u043f\u0440\u043e\u0441\u0438\u0442\u044c:<\/strong><\/p>\n
var results = await redb.Query<EmployeeProps>()    .Where(e => e.Salary > 75000m && e.Skills.Contains(\"C#\"))    .OrderByDescending(e => e.Salary)    .Take(100)    .ToListAsync();<\/code>
<\/a><\/div><\/pre>\n
\u0417\u0430\u0431\u044b\u0442\u044c Include \u043d\u0435\u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e \u2014 Props \u0432\u0441\u0435\u0433\u0434\u0430 \u0437\u0430\u0433\u0440\u0443\u0436\u0435\u043d \u0446\u0435\u043b\u0438\u043a\u043e\u043c. \u041d\u0443\u0436\u043d\u0430 \u043f\u0440\u043e\u0435\u043a\u0446\u0438\u044f? \u0422\u043e\u0433\u0434\u0430 .Select()<\/code>:<\/p>\n
var projected = await redb.Query<EmployeeProps>()    .Select(x => new { x.Props.FirstName, x.Props.Salary })    .ToListAsync();<\/code>
<\/a><\/div><\/pre>\n
\u0421\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u0435: \u0442\u043e\u0442 \u0441\u0430\u043c\u044b\u0439 \u043e\u0431\u044a\u0435\u043a\u0442 \u0438\u0437 28 \u0442\u0430\u0431\u043b\u0438\u0446<\/h4>\n
\u0412 EF Core:<\/p>\n
var order = await context.Orders    .Include(o => o.Customer)    .Include(o => o.Items).ThenInclude(i => i.Product)        .ThenInclude(p => p.Category)    .Include(o => o.Items).ThenInclude(i => i.Discounts)    .Include(o => o.Shipping).ThenInclude(s => s.Address)    .Include(o => o.Payment).ThenInclude(p => p.Transactions)    \/\/ ... \u0435\u0449\u0451 35 \u0441\u0442\u0440\u043e\u043a Include ...    .FirstOrDefaultAsync(o => o.Id == orderId);<\/code>
<\/a><\/div><\/pre>\n
\u0412 RedBase:<\/p>\n
var order = await redb.LoadAsync<OrderProps>(orderId);<\/code>
<\/a><\/div><\/pre>\n
\u041e\u0434\u043d\u0430 \u0441\u0442\u0440\u043e\u043a\u0430. \u0412\u0441\u0435 \u0432\u043b\u043e\u0436\u0435\u043d\u043d\u044b\u0435 \u043e\u0431\u044a\u0435\u043a\u0442\u044b, \u043c\u0430\u0441\u0441\u0438\u0432\u044b, \u0441\u043b\u043e\u0432\u0430\u0440\u0438 \u2014 \u0437\u0430\u0433\u0440\u0443\u0436\u0435\u043d\u044b. \u0418 \u0431\u044b\u0441\u0442\u0440\u043e: \u0434\u0432\u0438\u0436\u043e\u043a \u0441\u043e\u0431\u0438\u0440\u0430\u0435\u0442 Props \u043e\u0434\u043d\u0438\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u043c \u043a \u043f\u043b\u043e\u0441\u043a\u043e\u0439 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0435, \u0431\u0435\u0437 JOIN-\u043a\u0430\u0441\u043a\u0430\u0434\u0430 \u043f\u043e 28 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c. \u0412 Pro \u2014 \u0435\u0449\u0451 \u0431\u044b\u0441\u0442\u0440\u0435\u0435: \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0447\u0435\u0440\u0435\u0437 Parallel.ForEach<\/code>, \u043a\u0430\u0436\u0434\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0433\u0440\u0430\u0444\u0430 \u0441\u043e\u0431\u0438\u0440\u0430\u0435\u0442\u0441\u044f \u043f\u0430\u0440\u0430\u043b\u043b\u0435\u043b\u044c\u043d\u043e.<\/p>\n
\u0410 \u0447\u0442\u043e \u0441 \u0434\u0435\u0440\u0435\u0432\u044c\u044f\u043c\u0438?<\/h4>\n
\u0412\u0441\u0442\u0440\u043e\u0435\u043d\u043e \u0438\u0437 \u043a\u043e\u0440\u043e\u0431\u043a\u0438. \u041d\u0435 \u043d\u0443\u0436\u0435\u043d \u043d\u0438 closure table \u0432\u0440\u0443\u0447\u043d\u0443\u044e, \u043d\u0438 \u0440\u0435\u043a\u0443\u0440\u0441\u0438\u0432\u043d\u044b\u0435 CTE \u0432 raw SQL:<\/p>\n
\/\/ \u0421\u043e\u0437\u0434\u0430\u0442\u044c \u0434\u0435\u0440\u0435\u0432\u043eawait redb.CreateChildAsync(department, parentDepartment);\/\/ \u0417\u0430\u0433\u0440\u0443\u0437\u0438\u0442\u044c \u0432\u0441\u0451 \u0434\u0435\u0440\u0435\u0432\u043e (\u0434\u043e 5 \u0443\u0440\u043e\u0432\u043d\u0435\u0439)var tree = await redb.LoadTreeAsync<DepartmentProps>(rootId, maxDepth: 5);\/\/ LINQ \u043f\u043e \u0434\u0435\u0440\u0435\u0432\u0443var bigDepts = await redb.TreeQuery<DepartmentProps>()    .Where(d => d.Budget > 500000m)    .WhereLevel(2)    .ToListAsync();\/\/ \u041d\u0430\u0439\u0442\u0438 \u0432\u0441\u0435\u0445, \u0443 \u043a\u043e\u0433\u043e \u043f\u0440\u0435\u0434\u043e\u043a \u0441 \u0431\u044e\u0434\u0436\u0435\u0442\u043e\u043c > 1Mvar rich = await redb.TreeQuery<DepartmentProps>()    .WhereHasAncestor<DepartmentProps>(a => a.Budget > 1_000_000m)    .ToListAsync();<\/code>
<\/a><\/div><\/pre>\n
\u041e\u043a\u043e\u043d\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438? GroupBy? \u0410\u0433\u0440\u0435\u0433\u0430\u0446\u0438\u0438?<\/h4>\n
\u0422\u043e\u0436\u0435 \u0447\u0435\u0440\u0435\u0437 LINQ:<\/p>\n
\/\/ ROW_NUMBER() PARTITION BY Department ORDER BY Salary DESCvar ranked = await redb.Query<EmployeeProps>()    .WithWindow(w => w        .PartitionBy(x => x.Department)        .OrderByDesc(x => x.Salary))    .SelectAsync(x => new    {        Name = x.Props.FirstName,        Department = x.Props.Department,        Rank = Win.RowNumber()    });\/\/ GroupBy + \u0430\u0433\u0440\u0435\u0433\u0430\u0446\u0438\u044fvar stats = await redb.Query<EmployeeProps>()    .GroupBy(x => x.Department)    .SelectAsync(g => new    {        g.Key,        Total = Agg.Count(),        AvgSalary = Agg.Average(g, x => x.Salary)    });<\/code>
<\/a><\/div><\/pre>\n
\u0427\u0442\u043e \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u0434\u0432\u0438\u0436\u043e\u043a \u043f\u043e\u0434 \u043a\u0430\u043f\u043e\u0442\u043e\u043c<\/h4>\n
\u041e\u0431\u044b\u0447\u043d\u043e SQL \u0437\u0430 LINQ-\u0437\u0430\u043f\u0440\u043e\u0441\u0430\u043c\u0438 \u0441\u043a\u0443\u0447\u043d\u044b\u0439. \u041d\u043e \u0432\u043e\u0442 \u043f\u0440\u0438\u043c\u0435\u0440, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442 \u043f\u043e\u0447\u0435\u043c\u0443 \u0437\u0434\u0435\u0441\u044c \u043d\u0443\u0436\u0435\u043d \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0439 query engine, \u0430 \u043d\u0435 \u00ab\u043f\u0440\u043e\u0441\u0442\u043e ORM\u00bb.<\/p>\n
\u041c\u043e\u0434\u0435\u043b\u044c:<\/p>\n
public class Address{    public string City   { get; set; } = string.Empty;    public string Street { get; set; } = string.Empty;}[RedbScheme(\"Employee\")]public class EmployeeProps{    \/\/ ...    public Dictionary<string, Address>? OfficeLocations { get; set; }}<\/code>
<\/a><\/div><\/pre>\n
LINQ-\u0437\u0430\u043f\u0440\u043e\u0441 \u2014 \u043d\u0430\u0439\u0442\u0438 \u0432\u0441\u0435\u0445 \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u043e\u0432, \u0443 \u043a\u043e\u0433\u043e HQ-\u043e\u0444\u0438\u0441 \u0432 \u041d\u044c\u044e-\u0419\u043e\u0440\u043a\u0435:<\/p>\n
var result = await redb.Query<EmployeeProps>()    .Where(e => e.OfficeLocations![\"HQ\"].City == \"New York\")    .Take(100)    .ToListAsync();<\/code>
<\/a><\/div><\/pre>\n
\u0427\u0442\u043e \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f PostgreSQL<\/strong>:<\/p>\n
-- PVT CTE (nested-only optimization): OfficeLocations[HQ].CityWITH pvt_cte AS (  WITH  nested_dict_0 AS (    SELECT dp._id_object         , (array_agg(nv._string)              FILTER (WHERE nv._id_structure = $5))[1] AS \"OfficeLocations[HQ].City\"    FROM _values dp    LEFT JOIN _values nv           ON nv._array_parent_id = dp._id          AND nv._id_structure = $5    WHERE dp._id_structure = $3       -- \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 \u0441\u043b\u043e\u0432\u0430\u0440\u044f OfficeLocations      AND dp._array_index  = $4       -- \u043a\u043b\u044e\u0447 \"HQ\"      AND dp._id_object IN (            SELECT _id FROM _objects WHERE _id_scheme = $1          )    GROUP BY dp._id_object  )  SELECT nd0._id_object       , nd0.\"OfficeLocations[HQ].City\"  FROM nested_dict_0 nd0  WHERE nd0.\"OfficeLocations[HQ].City\" = $2   -- \"New York\")SELECT o.*FROM _objects oJOIN pvt_cte ON pvt_cte._id_object = o._idWHERE o._id_scheme = $1LIMIT 100<\/code>
<\/a><\/div><\/pre>\n
\u0427\u0442\u043e \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f MSSQL<\/strong>:<\/p>\n
-- PVT CTE (nested MAX CASE WHEN): OfficeLocations[HQ].City;WITHraw_values AS (  SELECT nv._array_parent_id AS _parent_id       , MAX(CASE WHEN nv._id_structure = 1010067                  THEN nv._string END) AS [OfficeLocations$LHQ$R$DCity]  FROM _values nv  WHERE nv._id_structure IN (1010067)    AND nv._array_parent_id IS NOT NULL  GROUP BY nv._array_parent_id),pvt_cte AS (  SELECT dp._id_object       , rv.[OfficeLocations$LHQ$R$DCity]  FROM _values dp  JOIN raw_values rv ON rv._parent_id = dp._id  WHERE dp._id_structure = @p2      -- \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 \u0441\u043b\u043e\u0432\u0430\u0440\u044f OfficeLocations    AND dp._array_index  = @p3      -- \u043a\u043b\u044e\u0447 \"HQ\"    AND dp._id_object IN (          SELECT _id FROM _objects WHERE _id_scheme = @p0        )    AND rv.[OfficeLocations$LHQ$R$DCity] = @p1   -- \"New York\")SELECT o.*FROM _objects oJOIN pvt_cte ON pvt_cte._id_object = o._idWHERE o._id_scheme = @p0ORDER BY o._idOFFSET 0 ROWS FETCH NEXT 100 ROWS ONLY<\/code>
<\/a><\/div><\/pre>\n
\u041e\u0434\u043d\u0430 \u0441\u0442\u0440\u043e\u043a\u0430 LINQ \u2014 \u0434\u0432\u0430 \u0434\u0438\u0430\u043b\u0435\u043a\u0442\u0430, \u0434\u0432\u0430 \u0440\u0430\u0437\u043d\u044b\u0445 \u043f\u043e\u0434\u0445\u043e\u0434\u0430 \u043a \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 (PostgreSQL \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442 array_agg FILTER<\/code>, MSSQL \u2014 MAX CASE WHEN<\/code>). SQL \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u043f\u043e\u0434 \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u044b\u0439 \u0434\u0438\u0430\u043b\u0435\u043a\u0442 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438. \u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0447\u0442\u043e \u0438\u043c\u0435\u043d\u043d\u043e \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043b\u043e\u0441\u044c \u0432\u0441\u0435\u0433\u0434\u0430 \u043c\u043e\u0436\u043d\u043e \u0447\u0435\u0440\u0435\u0437 .ToSqlStringAsync()<\/code>.<\/p>\n
\u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 \u2014 5 \u0441\u0442\u0440\u043e\u043a<\/h4>\n
PostgreSQL \u0438\u043b\u0438 MSSQL \u2014 \u0432\u044b\u0431\u0438\u0440\u0430\u0435\u0442\u0441\u044f \u043e\u0434\u043d\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u043e\u0439:<\/p>\n
\/\/ PostgreSQL + Pro\/\/ jit=off \u2014 \u043e\u0442\u043a\u043b\u044e\u0447\u0430\u0435\u043c JIT-\u043a\u043e\u043c\u043f\u0438\u043b\u044f\u0446\u0438\u044e PostgreSQL, \u043d\u0430 \u043a\u043e\u0440\u043e\u0442\u043a\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u0430\u0445 \u043e\u043d\u0430 \u0442\u043e\u043b\u044c\u043a\u043e \u0437\u0430\u043c\u0435\u0434\u043b\u044f\u0435\u0442builder.Services.AddRedbPro(options => options    .UsePostgres(\"Host=localhost;Database=mydb;Username=postgres;Password=pass;Options=-c jit=off\")    .WithLicense(\"YOUR-LICENSE-KEY\")    .Configure(c =>    {        c.EnablePropsCache = true;        c.EnableLazyLoadingForProps = false;    }));\/\/ MSSQL + Probuilder.Services.AddRedbPro(options => options    .UseMsSql(\"Server=localhost;Database=mydb;Trusted_Connection=true\")    .WithLicense(\"YOUR-LICENSE-KEY\"));\/\/ Free (Apache 2.0) \u2014 PostgreSQLbuilder.Services.AddRedb(options => options    .UsePostgres(\"Host=localhost;Database=mydb;Username=postgres;Password=pass;Options=-c jit=off\"));\/\/ Free (Apache 2.0) \u2014 MSSQLbuilder.Services.AddRedb(options => options    .UseMsSql(\"Server=localhost;Database=mydb;Trusted_Connection=true\"));<\/code>
<\/a><\/div><\/pre>\n
Free vs Pro<\/h4>\n
\u042f\u0434\u0440\u043e \u2014 open source, Apache 2.0. PostgreSQL \u0438 MSSQL. \u041f\u043e\u043b\u043d\u044b\u0439 LINQ, \u0434\u0435\u0440\u0435\u0432\u044c\u044f, \u0441\u043f\u0438\u0441\u043a\u0438, \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0438, \u044d\u043a\u0441\u043f\u043e\u0440\u0442\/\u0438\u043c\u043f\u043e\u0440\u0442.<\/p>\n
\u041e\u0431\u0430 \u0432\u0430\u0440\u0438\u0430\u043d\u0442\u0430 \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0442 \u0438 \u0441 PostgreSQL, \u0438 \u0441 MSSQL. \u0423 \u0434\u0432\u0438\u0436\u043a\u0430 \u0435\u0434\u0438\u043d\u044b\u0439 SQL-\u0430\u0431\u0441\u0442\u0440\u0430\u043a\u0442\u043d\u044b\u0439 \u0441\u043b\u043e\u0439 \u2014 \u043f\u0435\u0440\u0435\u0435\u0437\u0434 \u043c\u0435\u0436\u0434\u0443 \u0431\u0430\u0437\u0430\u043c\u0438 \u044d\u0442\u043e \u0441\u043c\u0435\u043d\u0430 \u043e\u0434\u043d\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u0438 (.UsePostgres()<\/code> \u2194 .UseMsSql()<\/code>). \u0410 redb.Export<\/code> \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u044d\u043a\u0441\u043f\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u0438\u0437 \u043e\u0434\u043d\u043e\u0439 \u0431\u0430\u0437\u044b \u0438 \u0438\u043c\u043f\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0432 \u0434\u0440\u0443\u0433\u0443\u044e \u2014 PostgreSQL \u2192 MSSQL \u0438 \u043e\u0431\u0440\u0430\u0442\u043d\u043e.<\/p>\n
Pro \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u0442 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c:<\/p>\n