I have a simple many to many association like below
1.User(UserId)
2.UserProjects(UserId,ProjectId,RowId)
3.Projects(ProjectId)
When I do a mapping with many to many with a bag collection of Users
in Projects the nhibernate query generated for adding a user to
project turns out to be
Dim p as Project = ProjectRepository.GetById(1)
Dim u as User = UserRepositoy.GetUser("Yuvan")
p.Users.Add(u)
p.SaveorUpdate()
[Note I already have users asscoiated with the project]
Nhibernate Query : Delete From UserProject Where ProjectId=1
Nhibernate Query : Insert into UserProject(1,"Yuvan")
Nhibernate Query : Insert into UserProject( ....)
Nhibernate Query : Insert into UserProject( ....)
When I do a mapping with a Iset collection there is no issues.Only one
insert for the newly associated user.
I do lazy loading for all collections and my cascades are set
properly.
So is this how bag collection works for many-to-many mapping ( deletes
all the rows in the association table and do an insert) or is that I
am missing something. I see a lot of docs and online examples using
bag for the many-to-many??However when I use bags for one-to-many
mapping and add/change collections I dont see this behaviour??
Can someone out there please explain me why???Please????
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
