Hi,
In our application, there was a reauirement to have Guids as Ids. However we
have an odd behaviour: havina a class Texture, with and Id:Guid and a
property Path:string if I do something like:
Texture t=null;
using(SessionScope s1 = new SessionScope())
{
t = Texture.Find(someTexture.Id);// we added it before
}
using(SessionScope s1 = new SessionScope())
{
t.Save();
}
on t.Save() it will do an update such as:
UPDATE Textures SET Version = @p0, Path = @p1, WHERE Id = @p2 AND Version =
@p3' AND Path = @p1,
Problems:
1. Since NH has dirty checking why does it even perform the update since
nothing is changed.
2. Even if something has changed why isn't the update only using the Id like
UPDATE Textures SET Version = @p0, Path = @p1, WHERE Id = @p2
and not all the properties??
Thanks,
Because of problem 1 we have a multitude of UPDATES being performed some
with BLOBS and it is killing the sql server.
--
Dan Bunea
http://www.danbunea.ro
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Castle Project Users" 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/castle-project-users?hl=en
-~----------~----~----~----~------~----~------~--~---
