can anyone help? ------ Joe Brockhaus [email protected] ------------
On Thu, Jun 2, 2011 at 7:32 PM, fel0niousmonk <[email protected]> wrote: > 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. > > -- 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.
