NHibernate----在线等待!!!

[已关闭问题] 关闭于 2008-08-21 16:23

持久化的C#类: ------------------------------------------------------------------------------------------------------------ namespace C.Student {     #region UserInfo     /// <summary>     /// UserInfo object for NHibernate mapped table 'UserInfo'.     /// </summary>     public class UserInfo : System.IComparable         {         #region Member Variables                 protected int _id;         protected string _userName;         protected string _userPwd;         protected string _userType;         protected string _userTitle;         protected int _sum;         protected static String _sortExpression = "Id";         protected static SortDirection _sortDirection = SortDirection.Ascending;         #endregion         #region Constructors         public UserInfo() { }         public UserInfo( string userName, string userPwd, string userType, string userTitle, int sum )         {             this._userName = userName;             this._userPwd = userPwd;             this._userType = userType;             this._userTitle = userTitle;             this._sum = sum;         }         #endregion         #region Public Properties         public int Id         {             get {return _id;}             set {_id = value;}         }         public string UserName         {             get { return _userName; }             set             {                 if ( value != null && value.Length > 50)                     throw new ArgumentOutOfRangeException("Invalid value for UserName", value, value.ToString());                 _userName = value;             }         }         public string UserPwd         {             get { return _userPwd; }             set             {                 if ( value != null && value.Length > 50)                     throw new ArgumentOutOfRangeException("Invalid value for UserPwd", value, value.ToString());                 _userPwd = value;             }         }         public string UserType         {             get { return _userType; }             set             {                 if ( value != null && value.Length > 50)                     throw new ArgumentOutOfRangeException("Invalid value for UserType", value, value.ToString());                 _userType = value;             }         }         public string UserTitle         {             get { return _userTitle; }             set             {                 if ( value != null && value.Length > 50)                     throw new ArgumentOutOfRangeException("Invalid value for UserTitle", value, value.ToString());                 _userTitle = value;             }         }         public int Sum         {             get { return _sum; }             set { _sum = value; }         }         public static String SortExpression         {             get { return _sortExpression; }             set { _sortExpression = value; }         }         public static SortDirection SortDirection         {             get { return _sortDirection; }             set { _sortDirection = value; }         }         #endregion                 #region IComparable Methods         public int CompareTo(object obj)         {             if (!(obj is UserInfo))                 throw new InvalidCastException("This object is not of type UserInfo");                         int relativeValue;             switch (SortExpression)             {                 case "Id":                     relativeValue = this.Id.CompareTo(((UserInfo)obj).Id);                     break;                 case "UserName":                     relativeValue = (this.UserName != null) ? this.UserName.CompareTo(((UserInfo)obj).UserName) : -1;                     break;                 case "UserPwd":                     relativeValue = (this.UserPwd != null) ? this.UserPwd.CompareTo(((UserInfo)obj).UserPwd) : -1;                     break;                 case "UserType":                     relativeValue = (this.UserType != null) ? this.UserType.CompareTo(((UserInfo)obj).UserType) : -1;                     break;                 case "UserTitle":                     relativeValue = (this.UserTitle != null) ? this.UserTitle.CompareTo(((UserInfo)obj).UserTitle) : -1;                     break;                 case "Sum":                     relativeValue = (this.Sum != null) ? this.Sum.CompareTo(((UserInfo)obj).Sum) : -1;                     break;                 default:                     goto case "Id";             }             if (UserInfo.SortDirection == SortDirection.Ascending)                 relativeValue *= -1;             return relativeValue;         }         #endregion     }     #endregion } ------------------------------------------------------------------------------------------------------------ NHibernate映射文件: <?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-lazy ="false">     <class name="C.Student.UserInfo, C.Student" table="UserInfo">         <id name="Id" type="Int32" unsaved-value="null">             <column name="UserID" length="4" sql-type="int" not-null="true" unique="true" index="PK_UserInfo"/>             <generator class="native" />         </id>         <property name="UserName" type="String">             <column name="UserName" length="50" sql-type="nvarchar" not-null="false"/>         </property>         <property name="UserPwd" type="String">             <column name="UserPwd" length="50" sql-type="nvarchar" not-null="false"/>         </property>         <property name="UserType" type="String">             <column name="UserType" length="50" sql-type="nvarchar" not-null="false"/>         </property>         <property name="UserTitle" type="String">             <column name="UserTitle" length="50" sql-type="nvarchar" not-null="false"/>         </property>         <property name="Sum" type="Int32">             <column name="Sum" length="4" sql-type="int" not-null="false"/>         </property>     </class> </hibernate-mapping> ------------------------------------------------------------------------------------------------------ App.config: <?xml version="1.0" encoding="utf-8" ?> <configuration>   <configSections>     <section name="hibernate-configuration"          type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate" />   </configSections>   <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">     <session-factory>       <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider, NHibernate</property>       <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>       <property name="connection.connection_string">         Server=(local);initial catalog=Chjw8016;Integrated Security=SSPI       </property>       <property name="show_sql">true</property>       <property name="dialect">NHibernate.Dialect.MsSql2000Dialect</property>     </session-factory>   </hibernate-configuration> </configuration> -------------------------------------------------------------------------------------------------------- 测试代码: using System; using System.Collections.Generic; using System.Text; using NHibernate; using NHibernate.Cfg; using C.Student; namespace ConsoleApp {     class Program     {         static void Main(string[] args)         {             Configuration conf = new Configuration().AddAssembly("C.Student") ;             ISessionFactory factory = conf.BuildSessionFactory();             ISession session = factory.OpenSession();             UserInfo user = new UserInfo();             user.UserName = "Chjw8016";             ITransaction trans = session.BeginTransaction();             try             {                 session.Save(user);                 trans.Commit();                 session.Close();                 Console.WriteLine("Insert Success!");                 Console.ReadLine();             }             catch (Exception ex)             {                 trans.Rollback();                 session.Close();                 Console.WriteLine(ex.Message);                 Console.ReadLine();             }         }     } } ------------------------------------------------------------------------------------------------------------------------------- 问题: <img src="http://www.cnblogs.com/images/cnblogs_com/chjw8016/UseInCode/11111.PNG" mce_src="http://www.cnblogs.com/images/cnblogs_com/chjw8016/UseInCode/11111.PNG" height="185" width="670"> 不知道是什么会事,老是插入不成功!!不知道问题出在那里????

.NET技术 .NET开源项目

问题补充： 持久化类和映射文件，都是CodeSimth生成的。还有我用的是nhibernate2.0

伽马科技.攻城师 | 小虾三级 | 园豆：1303
提问于：2008-08-07 14:49

< >

所有回答(1)

Server=(local);initial catalog=Chjw8016;Integrated Security=SSPI？写成 server=localhost;Database=Test;uid=sa;pwd=sa; 看看！

Jerry Young | 园豆：435 (菜鸟二级) | 2008-08-07 15:55

清除回答草稿

您需要登录以后才能回答，未注册用户请先注册。

欢迎，请先 登录 或者 注册 。

NHibernate----在线等待!!!

欢迎，请先登录或者注册。