In all the queries I tried, the new provider performed better. If you can provide an example of something that works with the old one and breaks with the new one, it can get fixed.
Diego On Wed, May 12, 2010 at 16:05, Tim Scott <[email protected]>wrote: > Thanks Diego. We tried to upgrade to trunk back in February. It did > not go well. If memory serves, our current Linq queries kidna fell > apart under the new provider. We reverted, opting to tackle it later. > > Two questions: How feature complete is the new Linq provider today? > Has anyone tried to convert an existing app with a lot of > NHibernate.Linq to the new Linq provider? > > On May 12, 10:50 am, Diego Mijelshon <[email protected]> wrote: > > Unfortunately, that's the behavior of the criteria-based 2.x Linq > provider. > > The integrated Linq provider in 3.x works as expected. > > > > Diego > > > > On Wed, May 12, 2010 at 12:40, Tim Scott <[email protected] > >wrote: > > > > > > > > > I have an NHibernate.Linq query with a predicate like this: > > > > > foo => foo.Bar.Id == barId > > > > > It generates SQL like this: > > > > > ...FROM Foo this_ > > > left outer join Bar bar1_ on this_.BarID=bar1_.Id > > > WHERE (bar1_.Id = 379) > > > > > I was hoping it was clever enough to do it like this: > > > > > ...FROM Foo this_ > > > WHERE (this_.BarId = 379) > > > > > This query that will run every 5 seconds for all logged in users, so I > > > need to cut all possible fat. Is there some way to code this with > > > Linq so that it skips the unnecessary join? Keep in mind I do not > > > have a handle on Bar entity, just the ID. > > > > > -- > > > You received this message because you are subscribed to the Google > Groups > > > "nhusers" group. > > > To post to this group, send email to [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]<nhusers%[email protected]> > <nhusers%[email protected]<nhusers%[email protected]> > > > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/nhusers?hl=en. > > > > -- > > You received this message because you are subscribed to the Google Groups > "nhusers" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > > For more options, visit this group athttp:// > groups.google.com/group/nhusers?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" 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/nhusers?hl=en.
