LoadWith Option does not work

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
Posts: 390
Joined: Sat 09 Dec 2006 12:20

LoadWith Option does not work

Post by Zero-G. » Mon 07 Jun 2010 14:41


Using the latest available Version of dotConnect for mySQL.

I have a Mastertable with two related child-tables

Using LoadWith Option like:

Code: Select all

        Dim dl As New Devart.Data.Linq.DataLoadOptions
        dl.LoadWith(Of VOptNeuContext.Tagesabschluss)(Function(c) c.Tagesabschlussdetails)
        dl.LoadWith(Of VOptNeuContext.Tagesabschluss)(Function(c) c.Tagabkrankenkassenanteils)
        myDataContext.LoadOptions = dl
Does not work as expected, the "Tagesabschlussdetails" will be translated with a join, but "Tagabkrankenkassenanteils" is translated with a stand alone Select.
Please try to reproduce and let me know, why this happens.


Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 09 Jun 2010 15:29

Sorry, but this is a designed behaviour. The second join leads to performance loss, we have already discussed this behaviour with our users here, for example:

Post Reply