nhibernate的问题~ 我在vs2005中学习nhibernate,按网上的教程做了几个试例,但都不成功,老是提示出错,请问各位谁有做过nhibernate在VS2005中的例 子!可以给个介绍吗?或有教程可以发一份吗,谢过了! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 NHibernate:One-to-Many一对多映射这个例子对楼主不知道有没有用http://www.1024k.cn/net/2006/200610/1032.html 下面给出一个在nhibernate中执行SQL语句的方法ExecuteSQL。public IList ExecuteSQL( string query ) { IList result = new ArrayList(); ISessionFactoryImplementor s = (ISessionFactoryImplementor)cfg.BuildSessionFactory(); IDbCommand cmd = s.ConnectionProvider.Driver.CreateCommand(); cmd.CommandText = query; IDbConnection conn = s.OpenConnection(); try { cmd.Connection = conn; IDataReader rs = cmd.ExecuteReader(); while ( rs.Read() ) { int fieldCount = rs.FieldCount; object[] values = new Object[ fieldCount ]; for ( int i = 0; i < fieldCount; i ++ ) values[i] = rs.GetValue(i); result.Add( values ); } } finally { s.CloseConnection(conn); } return result;}执行存储过程的方法. public IList ExecuteStoredProc( string spName, ICollection paramInfos ) { IList result = new ArrayList(); ISessionFactoryImplementor s = (ISessionFactoryImplementor)cfg.BuildSessionFactory(); IDbCommand cmd = s.ConnectionProvider.Driver.CreateCommand(); cmd.CommandText = spName; cmd.CommandType = CommandType.StoredProcedure; // 加入参数 if ( paramInfos != null ) { foreach( ParamInfo info in paramInfos ) { IDbDataParameter parameter = cmd.CreateParameter(); parameter.ParameterName = info.name; // driver.FormatNameForSql( info.Name ); parameter.Value = info.Value; cmd.Parameters.Add( parameter ); } } IDbConnection conn = s.OpenConnection(); try { cmd.Connection = conn; IDataReader rs = cmd.ExecuteReader(); while ( rs.Read() ) { int fieldCount = rs.FieldCount; object[] values = new Object[ fieldCount ]; for ( int i = 0; i < fieldCount; i ++ ) values[i] = rs.GetValue(i); result.Add( values ); } } finally { s.CloseConnection(conn); } return result;} 其中ParamInfo为存储参数信息的结构, 定义如下: public struct ParamInfo { public string Name; public object Value; } 我现在是不知怎么在VS2005中配置它!它老提示这句话出错!<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0"> 从ADO.NET进入LINQ,走一条阳关道吧。 http://www.cnblogs.com/Roping/archive/2007/03/27/689805.html 两个复选框全选问题 问一个简单的关于GridView模板列的问题。 怎样反编译一个ASP.net网站项目 如何实现GOOGLE的查询功能 求简单的access的UPDATE语句 怎么在button的click事件里面获取该button的名字? 100求新闻发布系统 存储过程 怎样输出包括+号的字符串 TreeView控件问题事件不能产生的问题 项目准备用NHibernate开发,用过的进来看看下面问题,能不能解决,在线等! 哪里有NHibernate的DTD文档(hibernate-mapping-1.0.dtd)
这个例子对楼主不知道有没有用
http://www.1024k.cn/net/2006/200610/1032.html
public IList ExecuteSQL( string query ) {
IList result = new ArrayList(); ISessionFactoryImplementor s = (ISessionFactoryImplementor)cfg.BuildSessionFactory();
IDbCommand cmd = s.ConnectionProvider.Driver.CreateCommand();
cmd.CommandText = query; IDbConnection conn = s.OpenConnection();
try {
cmd.Connection = conn;
IDataReader rs = cmd.ExecuteReader(); while ( rs.Read() ) {
int fieldCount = rs.FieldCount;
object[] values = new Object[ fieldCount ];
for ( int i = 0; i < fieldCount; i ++ )
values[i] = rs.GetValue(i);
result.Add( values );
}
}
finally {
s.CloseConnection(conn);
} return result;
}
执行存储过程的方法. public IList ExecuteStoredProc( string spName, ICollection paramInfos ) {
IList result = new ArrayList(); ISessionFactoryImplementor s = (ISessionFactoryImplementor)cfg.BuildSessionFactory();
IDbCommand cmd = s.ConnectionProvider.Driver.CreateCommand(); cmd.CommandText = spName;
cmd.CommandType = CommandType.StoredProcedure; // 加入参数
if ( paramInfos != null ) {
foreach( ParamInfo info in paramInfos ) {
IDbDataParameter parameter = cmd.CreateParameter();
parameter.ParameterName = info.name; // driver.FormatNameForSql( info.Name );
parameter.Value = info.Value;
cmd.Parameters.Add( parameter );
}
} IDbConnection conn = s.OpenConnection();
try {
cmd.Connection = conn;
IDataReader rs = cmd.ExecuteReader(); while ( rs.Read() ) {
int fieldCount = rs.FieldCount;
object[] values = new Object[ fieldCount ];
for ( int i = 0; i < fieldCount; i ++ )
values[i] = rs.GetValue(i);
result.Add( values );
}
}
finally {
s.CloseConnection(conn);
} return result;
}
其中ParamInfo为存储参数信息的结构, 定义如下:
public struct ParamInfo {
public string Name;
public object Value;
}