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, Dec 31 '20 at 14:07

score 0 · Accepted Answer · answered Dec 31 '20 at 18:25

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.

Select with null in previous properties

1 Answers1