The expression is very simple: Report report = datacontext.Reports.SingleOrDefault(d => d.Id == 100);
The result is: report.Id = 100; report.EngineId = 1; report.Engine = null; I don't know if work in SQLite and I can't test it now. On Sep 7, 10:23 pm, Jonathan Pryor <[email protected]> wrote: > See below... > > > > On Mon, 2009-09-07 at 06:01 -0700, Marco Fracassi wrote: > > I try to use DBLinq 0.18 with MySQL in my project but I have this > > problem: > ... > > When I use generated code to find entity.Id = 1 the result EntitySet > > Engine.Report is fill correctly. > > When I try to find report.Id = 100 the EntityRef Report.Engine is set > > to null. Why? > > Any number of reasons why (sadly), so the question is, what exactly is > your query expression? (The followup-question: does it work properly in > SQLite or not?) > > It could be expected behavior (depending on the query), a DbLinq core > bug (likely if it's wrong for both MySQL & SQLite), a DbLinq.MySql bug, > or something else. Knowing your exactly query expression would be > useful. > > Also, you may consider using DbLinq trunk. 0.18 is ancient (over a year > old). (Yes, I realize that we should push a 0.19 if we're going to tell > people to use trunk, and pushing out a 0.19 release is high on my > priority list...) > > - Jon --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dblinq?hl=en -~----------~----~----~----~------~----~------~--~---
