OK, doesn't it figure that as soon as I try to find help on a mysterious problem, it vanishes? lol
so I'm no longer seeing the unexpected child return count. I'm chalking that up to someone else mucking with the database while I'm troubleshooting. however, I'd really like some advice on the original problem: why won't the child entities load with the parent customer? On Jun 2, 7:27 pm, fel0niousmonk <[email protected]> wrote: > i'm still having a problem with this and it's driving me insane!! > > what I decided to do was query for the parent, then query for the > children using the parent's ID > (something like .. > customer.Children = sess.CreateCriteria<Child>() > > .Add(nhc.Expression.Eq("CustomerID", > customer.ID)) > .List<Child>(); > > this has so far worked great (well .. it works -- i wouldn't call it > great) > > However, there are a couple customers who, when I query for the > children, return (in my case) 20 entities, but these entities ARE NOT > in the database. NONE of them. > > While I can live with a seemingly broken load of the child entities > (which, btw are mapped bidirectionally, inverse on the customer), I > can't live with the other problem. Am I running into problems with the > cache being out of sync with the database (changes made through > database, not application)? or could i simply not have the 2nd level > cache setup/evicting correctly/timely enough? I've restarted the debug > session, killed all IIS instances, restarted the server numerous > times ... and all that leads me to believe the cache is not the > culprit (it's all in-mem afaik) ... but what else could be happening? > > any help/insight on/into either of these 2 problems would be greatly > appreciated. > > Recently, I did setup 2nd Level Cache using SysCache ... it's the only > thing I can think of that > > On May 13, 10:44 am, Joe Brockhaus <[email protected]> wrote: > > > > > oops, when i was redacting that I forgot to change the code .. > > > using (var session = > > MyDataContext.Current.SessionManager.OpenSession()) > > { > > using (var trans = session.BeginTransaction()) > > { > > var cust = > > session.CreateCriteria<Customer>() > > .Add(nhc.Expression.Eq(rValue.NameOf(x => > > x.BillingInstanceID), customerBillingInstanceID)) > > .SetFetchMode(rValue.NameOf(x => > > x.Children), FetchMode.Eager) > > .UniqueResult<Customer>(); > > > // var cust = > > session.Query<Customer>() > > // .Where(x => x.BillingInstanceID == > > customerBillingInstanceID) > > // .Single(); > > > rValue = cust; > > } > > } -- 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.
