I'm starting to play with NHibernate to make a case for its use in our
company's projects. I've created a branch of one of our solutions and
have started to convert some of the data access to using NHibernate as
a proof-of-concept. However, while looking at SQL Profiler, I
discovered that NHibernate is issuing an update command to the
database when I databind an IList that I get back from a Criteria
query to a Datalist control. The Criteria query looks like this:
var contacts = session.Get<Location>(LocationId).Contacts
.OrderBy(x => x.LastName)
.ThenBy(x => x.FirstName)
.ThenBy(x => x.ContactType.TypeName)
.ThenBy(x => x.ContactID);
dlContact.DataSource = contacts;
dlContact.DataBind();
I'm getting the list of contacts that are associated with a particular
location in our system. To be clear, the update does not seem to be
issued right as DataBind() is called, but when the session is flushed
at the end of the request. It issues an update to the Contacts table,
not the Location table. And it's a single update, too, not one update
for each contact associated with the location.
Why does NHibernate think it needs to update the database? Is the
databinding changing the value of one of the Contact entities returned
from the query somehow? I'm just displaying the values on the page,
not changing them anywhere that I can tell.
Any help would be much appreciated. I can provide more code context if
it would be helpful.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to nhusers@googlegroups.com
To unsubscribe from this group, send email to
nhusers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
