Include() not working

[haiduc32]

Hi,
we started using dbMonitor lately and I've spotted that the Include() has no action. For example:

Code: Select all

Customer customer = context.Customers.Include("Orders").Single( ... );
Order order = customer.Orders.First();

will generate 2 selects in db instead of expected only one.

Is this a known issue, some flag we have to set?

[Shalex]

generate 2 selects in db instead of expected only one.

Do you mean the "Prepare: Select..." and "Execute: Select..." records in dbMonitor? These are two stages of a single select.

[haiduc32]

hi,
to be more specific:

Code: Select all

Customer customer = context.Customers.Include("Orders").Single( ... ); 
//one select is done here on the Customers table
Order order = customer.Orders.First();
//one select is done here on the Orders table

[Shalex]

Could you please send us a small test project with the corresponding DDL/DML script to reproduce the issue in our environment?