关注开源代码的实际应用
1、通过ICriteria结合Expression.Sql进行查询
- ICriteria cri = this.Session.DbSession.CreateCriteria(typeof(Mag.Article.LightNews));
- cri.Add(Expression.Sql(string.Format("contains(title,'{0}')", key)));
2、使用ISQLQuery直接通过SQL语句进行查询
- string sql = string.Format("select id from [user] where contains(loginname,'{0}')", pKey);
- ISQLQuery query = this.Session.DbSession.CreateSQLQuery(sql);
- query.AddScalar("id",NHibernateUtil.Int32);
- System.Collections.ArrayList ids = new System.Collections.ArrayList();
- query.List(ids);//或者使用query.List<Entity.TypeName>,但sql语句不能指定字段