NHibernate的使用
hibernate.cfg.xml
1 <?xml version="1.0" encoding="utf-8" ?> 2 <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" > 3 <session-factory name="NHibernate.Test"> 4 <property name="connection.connection_string"> 5 Data Source=.;database=NHibernate;Integrated Security=True;Pooling=False 6 </property> 7 <property name="show_sql">true</property> 8 <property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property> 9 <mapping assembly="NHibernateSpringTest"/> 10 </session-factory> 11 </hibernate-configuration>
User.hbm.xml
1 <?xml version="1.0" encoding="utf-8" ?> 2 <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"> 3 <class name="NHibernateSpringTest.User, NHibernateSpringTest" table="my_users"> 4 <id name="LoginId" column="LogonId" type="String" length="20"> 5 <generator class="assigned" /> 6 </id> 7 <property name="UserName" column="UserName" type="String" length="40"/> 8 <property name="Age" column="Age" type="Int32"/> 9 </class> 10 </hibernate-mapping>
Program.cs
1 Configuration cfg = new Configuration().Configure(); 2 ISessionFactory factory = cfg.BuildSessionFactory(); 3 ISession session = factory.OpenSession(); 4 //1.Search 5 User singleUser = (User)session.Get(typeof(User), "andy"); 6 Console.WriteLine("name:{0},age:{1}", singleUser.UserName, singleUser.Age);