NHibernate

前几天在回答一个问题时，我是凭直感回答的，因为没试过。正好最近对O/R Mapper感兴趣，所以决定试一下NHibernate，发现其Quick Start Guide 有几个地方不是很清楚，现在把试验的步骤记录如下。(因为试验的这台机器没有VS.NET，所以用了csc.exe来直接编译)

0. 安装<br /> NHibernate<br /> http://sourceforge.net/project/showfiles.php?group_id=73818<br /> log4net<br /> http://sourceforge.net/project/showfiles.php?group_id=31983&release_id=171808<br /> 1. 生成数据库<br /> use master<br /> go<br /> create database NHibernate<br /> go<br /> use NHibernate<br /> go<br /> CREATE TABLE users (<br /> LogonID nvarchar(20) NOT NULL default ‘0’,<br /> Name nvarchar(40) default NULL,<br /> Password nvarchar(20) default NULL,<br /> EmailAddress nvarchar(40) default NULL,<br /> LastLogon datetime default NULL,<br /> PRIMARY KEY (LogonID)<br /> )<br /> go<br /> 2. 生成persistent类: User.cs<br /> using System;<br /> //note, in the Quick Guide, it says NHibernate.Demo.QuickStart<br /> //you could use it, then you need to change the class name in<br /> //the User.hbm.xml file<br /> namespace NHibernate.Examples.QuickStart<br /> {<br /> public class User<br /> {<br /> private string id;<br /> private string userName;<br /> private string password;<br /> private string emailAddress;<br /> private DateTime lastLogon;<br /> public User()<br /> {<br /> }<br /> public string Id<br /> {<br /> get { return id; }<br /> set { id = value; }<br /> }<br /> public string UserName<br /> {<br /> get { return userName; }<br /> set { userName = value; }<br /> }<br /> public string Password<br /> {<br /> get { return password; }<br /> set { password = value; }<br /> }<br /> public string EmailAddress<br /> {<br /> get { return emailAddress; }<br /> set { emailAddress = value; }<br /> }<br /> public DateTime LastLogon<br /> {<br /> get { return lastLogon; }<br /> set { lastLogon = value; }<br /> }</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>}<br /> }<br /> 3. 生成影射文件 User.hbm.xml<br /> <?xml version=”1.0″ encoding=”utf-8″ ?><br /> <hibernate-mapping xmlns=”urn:nhibernate-mapping-2.0″><br /> <class name=”NHibernate.Examples.QuickStart.User, NHibernate.Examples” table=”users”><br /> <id name=”Id” column=”LogonId” type=”String” length=”20″><br /> <generator class=”assigned” /><br /> </id><br /> <property name=”UserName” column= “Name” type=”String” length=”40″/><br /> <property name=”Password” type=”String” length=”20″/><br /> <property name=”EmailAddress” type=”String” length=”40″/><br /> <property name=”LastLogon” type=”DateTime”/><br /> </class><br /> </hibernate-mapping><br /> 4. 生成配置文件 TestUser.exe.config<br /> <?xml version=”1.0″ encoding=”utf-8″ ?><br /> <configuration><br /> <configSections><br /> <section name=”nhibernate” type=”System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, Custom=null” /><br /> <section name=”log4net” type=”log4net.Config.Log4NetConfigurationSectionHandler, log4net” /><br /> </configSections></p> <p><nhibernate><br /> <add<br /> key=”hibernate.connection.provider”<br /> value=”NHibernate.Connection.DriverConnectionProvider”<br /> /><br /> <add<br /> key=”hibernate.dialect”<br /> value=”NHibernate.Dialect.MsSql2000Dialect”<br /> /><br /> <add<br /> key=”hibernate.connection.driver_class”<br /> value=”NHibernate.Driver.SqlClientDriver”<br /> /><br /> <add<br /> key=”hibernate.connection.connection_string”<br /> value=”Server=localhost;initial catalog=nhibernate;Integrated Security=SSPI”<br /> /><br /> </nhibernate><br /> <log4net><br /> <appender name=”ConsoleAppender” type=”log4net.Appender.ConsoleAppender”><br /> <layout type=”log4net.Layout.PatternLayout”><br /> <param name=”ConversionPattern” value=”%d [%t] %-5p %c [%x] -%m%n” /><br /> </layout><br /> <root><br /> <level value=”INFO” /><br /> <appender-ref ref=”ConsoleAppender” /><br /> </root><br /> </appender><br /> </log4net><br /> </configuration></p> <ol> <li>生成测试程序:TestUser.cs<br /> using System;<br /> //using System.Configurations;<br /> using NHibernate;<br /> using NHibernate.Cfg;<br /> using System.Collections;<br /> using NHibernate.Examples.QuickStart;<br /> using NHibernate.Expression;<br /> class TestConfig<br /> {<br /> public static void Main()<br /> {<br /> Configuration cfg = new Configuration();<br /> cfg.AddAssembly(“NHibernate.Examples”);<br /> ISessionFactory factory = cfg.BuildSessionFactory();<br /> ISession session = factory.OpenSession();<br /> ITransaction transaction = session.BeginTransaction();</p> <p>User newUser = new User();<br /> newUser.Id = “joe_cool”;<br /> newUser.UserName = “Joseph Cool”;<br /> newUser.Password = “abc123”;<br /> newUser.EmailAddress = “joe@cool.com”;<br /> newUser.LastLogon = DateTime.Now;</p> <p>// Tell NHibernate that this object should be saved<br /> session.Save(newUser);<br /> // commit all of the changes to the DB and close the ISession<br /> transaction.Commit();<br /> session.Close();</p> <p>Console.WriteLine(“go check in the database, enter return to continue….”);<br /> Console.ReadLine();<br /> //System.Threading.Thread.Sleep(2000);<br /> //Console.WriteLine(“enter return to continue….”);<br /> //Console.ReadLine();<br /> // open another session to retrieve the just inserted user<br /> session = factory.OpenSession();<br /> User joeCool = (User)session.Load(typeof(User), “joe_cool”);<br /> // set Joe Cool’s Last Login property<br /> joeCool.LastLogon = DateTime.Now;<br /> session.Update(joeCool);<br /> // flush the changes from the Session to the Database<br /> session.Flush();<br /> //Console.WriteLine(“enter return to continue….”);<br /> //Console.ReadLine();<br /> IList userList = session.CreateCriteria(typeof(User)).List();<br /> foreach(User user in userList)<br /> {<br /> Console.WriteLine(user.Id + ” last logged in at ” + user.LastLogon);<br /> }<br /> IList recentUsers = session.CreateCriteria(typeof(User))<br /> .Add(Expression.Gt(“LastLogon”, new DateTime(2004, 03, 14, 20, 0, 0)))<br /> .List();<br /> foreach(User user in recentUsers)<br /> {<br /> Console.WriteLine(user.Id + ” last logged in at ” + user.LastLogon);<br /> }</p> <p>session.Close();<br /> }<br /> }</p> </li> <li>copy or reference<br /> NHibernate.dll<br /> HashCodeProvider.dll (needed at runtime)<br /> log4net.dll (needed at runtime)</li> <li>compile User.cs:<br /> csc /t:library /out:NHibernate.Examples.dll /resource:User.hbm.xml User.cs</li> <li>compile TestUser.cs:<br /> csc /r:NHibernate.dll,NHibernate.Examples.dll TestUser.cs</li> <li>run TestUser.exe<br /> F:\test>TestUser<br /> go check in the database, enter return to continue….<br /> joe_cool last logged in at 12/15/2004 9:42:00 PM<br /> joe_cool last logged in at 12/15/2004 9:42:00 PM<br />

注，其中log4net的配置是从原提问者inelm处学来的