NHibernate中的many-to-many关系示范

根据下面这个blog修改而成:
http://blog.aspcool.com/billy_zh/archive/2005/11/12/926.html#3337

1. 生成数据库</p> <p>use master<br /> go<br /> create database Hibernate<br /> go<br /> use Hibernate<br /> go</p> <p>create table Users (user_id int identity primary key, name varchar(100))<br /> go</p> <p>create table Groups(group_id int identity primary key, name varchar(100), description varchar(100))<br /> go</p> <p>create table UserGroups (group_id int foreign key references Groups(group_id),<br /> user_id int foreign key references Users(user_id))<br /> go</p> <ol> <li>User.cs</li> </ol> <p>using System;<br /> using System.Collections;</p> <p>public class User {</p><div class='code-block code-block-3' style='margin: 8px 0; clear: both;'> <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> <ins class="adsbygoogle" style="display:block; text-align:center;" data-ad-layout="in-article" data-ad-format="fluid" data-ad-client="ca-pub-6768214833031159" data-ad-slot="4803962711"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script></div> <p>public User() {<br /> }</p> <p>public int UserId<br /> {<br /> get { return userId; }<br /> set { userId = value; }<br /> }</p> <p>public string Name<br /> {<br /> get { return name; }<br /> set { name = value; }<br /> }</p> <p>public IList Groups<br /> {<br /> get { return groups; }<br /> set { groups = value; }<br /> }</p> <p>private int userId;<br /> private string name;<br /> private IList groups = new ArrayList();</p> <p>} //class User</p> <ol> <li>Group.cs</li> </ol> <p>using System;<br /> using System.Collections;</p> <p>public class Group {</p> <p>public Group() {<br /> }</p> <p>public int GroupId<br /> {<br /> get { return groupId; }<br /> set { groupId = value; }<br /> }</p> <p>public string Name<br /> {<br /> get { return name; }<br /> set { name = value; }<br /> }</p> <p>public string Description<br /> {<br /> get { return description; }<br /> set { description = value; }<br /> }</p> <p>public IList Users<br /> {<br /> get { return users; }<br /> set { users = value; }<br /> }</p> <p>private int groupId;<br /> private string name;<br /> private string description;<br /> private IList users = new ArrayList();</p> <p>} //class Group</p> <ol> <li>User.hbm.xml</p> </li> <li> <p>Group.hbm.xml</p> </li> <li> <p>TestUser.cs</p> </li> </ol> <p>using System;<br /> using NHibernate;<br /> using NHibernate.Cfg;<br /> using System.Text;<br /> using System.Collections;<br /> using NHibernate.Expression;</p> <p>public class TestCreate<br /> {<br /> ISession session;</p> <pre><code>public TestCreate() { Configuration cfg = new Configuration(); cfg.AddXmlFile("User.hbm.xml"); cfg.AddXmlFile("Group.hbm.xml"); ISessionFactory factory = cfg.BuildSessionFactory(); session = factory.OpenSession(); } </code></pre> <p>public void Test()<br /> {<br /> User user1 = new User();<br /> user1.Name = “test1”;<br /> User user2 = new User();<br /> user2.Name = “test2”;</p> <p>Group group1 = new Group();<br /> group1.Name = “group1”;<br /> Group group2 = new Group();<br /> group2.Name = “group2”;</p> <p>user1.Groups.Add( group2);<br /> user2.Groups.Add( group1 );<br /> group1.Users.Add( user2 );<br /> group2.Users.Add( user1);</p> <p>ITransaction trans = null;<br /> try {<br /> trans = session.BeginTransaction();</p> <pre><code> session.Save( user1 ); session.Save( user2 ); session.Save( group1 ); session.Save( group2 ); trans.Commit(); </code></pre> <p>}<br /> catch ( Exception e ) {<br /> if ( trans != null ) trans.Rollback();<br /> throw e;<br /> }<br /> finally {<br /> session.Close();<br /> }</p> <p>}</p> <pre><code>static void Main() { TestCreate tc = new TestCreate(); tc.Test(); } </code></pre> <p>}</p> <ol> <li>TestUser.exe.config <pre><code> <section /> <section /> </code></pre> </li> <li>UserGroup.dll</p> </li> </ol> <p>csc /t:library /out:UserGroup.dll User.cs Group.cs</p> <ol> <li>TestUser.exe</li> </ol> <p>csc /r:Nhibernate.dll,UserGroup.dll TestUser.cs</p> <ol> <li>runtime assemblies needed</li> </ol> <p>HashCodeProvider.dll<br /> Iesi.Collections.dll<br /> log4net.dll<br /> NHibernate.dll</p> <p>

打赏作者