This is my simple query: IList<Pizza> pizzas = FromRestaurant(); can you guess why I have a query per each pizza ?
can you recreate the same issue in a test ? If you try the "test-way" please avoid the copy-&-paste of everything and do it step-by-step, you will probably found the cause. If you are using the cache, look at it after write the test. On Tue, Sep 21, 2010 at 7:02 PM, Scott <[email protected]> wrote: > Can someone tell me why when I use the NHibernate Linq inhibitor it > gets the entire table when I trace it in Sql Profiler and if I use it > in the from it gets the entire table 1 record at a time. > > Simple query > > IList<Item> item = FromSomeSource(); > var score = (from i in items > join s in NHibernateSession.Linq<Score>() on i equals s.Item > select s); > > -- > 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. > > -- Fabio Maulo -- 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.
