Select with null in previous properties

Question

Is it possible to do:

IEnumerable<MyModel> models = context.MyDBModels .Include(x => x.ConnectionA) .Select(x => new MyModel{ SomeData = new SomeDataClass { prop1 = x.ConnectionA.ConnectionB.prop1, prop2 = x.ConnectionA.ConnectionB.prop2, } });

when ConnectionB for example is null since null propagating operator is not possible in tree expressions like these.

I tested it and it looks like it works (it doesn't throw exceptions and in prop1/prop2 I have null as I want), but I want to be sure

It should work, even better, you can remove Include, it is not needed when you have custom projection. — Svyatoslav Danyliv
– Svyatoslav Danyliv, Commented Dec 31, 2020 at 14:07

NetMage · Accepted Answer · 2020-12-31 18:25:52Z

When using LINQ to databases, the LINQ is translated to SQL (or other database query language) and the handling of null depends on that language. In the case of SQL, null propagation is essentially automatic, though you have to be aware if you switch to client side processing somewhere in the LINQ query.

Collectives™ on Stack Overflow

Select with null in previous properties

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related