Problems with multilevel includes

Nov 29, 2013 at 12:47 PM
Hello,
I wonder if Effort is unable to handle multilevel includes or if the error is made by me.
My Datalogic uses multilevel includes at certain places and this works great when working against real database providers.

When running my Logic against Effort, everything is fine for simple includes but using lmultilevel includes throws a null reference exception as soon as there are no results for the 2nd level.

Example:
dbContext.Table1.Include(t => t.Table2); //works
dbContext.Table1.Include(t => t.Table2.Table3); //throws exception

If 'Table2' is empty for any element of 'Table1', the exception is thrown for the 2nd line of code. Same data on a real database and it works without exception.
Any suggestions?

Thanks in advance...
Coordinator
Nov 29, 2013 at 3:28 PM
Edited Nov 29, 2013 at 4:05 PM
Hello,

Thank you for reporting this issue!

It should handle these queries, but a bug can always exist. A similar issue has been submitted recently, so I will dig into this in the near future.
Coordinator
Dec 3, 2013 at 9:25 AM
Recent nightly build of Effort contains a fix, check if it solved your problem:
http://development.flamich.net/oss-nightly/download/
Marked as answer by stiefel on 12/3/2013 at 11:00 PM
Dec 4, 2013 at 6:00 AM
Hi,
it works, thanks a lot!