//这个方法报错了
void WhereFor()
{
var session = Z.Core.NHibernateCore.NHibernateHelper.GetCurrentSession();
var query = session.Linq<Model.Pub.Goods>().Where(l => 1 == 1);
var goods = new string[] { "A", "B", "C" };
for (int i = 0; i <= goods.Length - 1; i++)
{
query = query.Where(l => l.Code != goods[i]);
}
var count = query.Count();
Console.Write(count);
}
//这个方法没有报错正常运行,但他和上面的方法唯一区别就是声明了var item = goods[i]; 来代替goods[i]
void WhereForDeclare()
{
var session = Z.Core.NHibernateCore.NHibernateHelper.GetCurrentSession();
var query = session.Linq<Model.Pub.Goods>().Where(l => 1 == 1);
var goods = new string[] { "A", "B", "C" };
for (int i = 0; i <= goods.Length - 1; i++)
{
var item = goods[i];
query = query.Where(l => l.Code != item);
}
var count = query.Count();
Console.Write(count);
}
//这个方法也没有报错正常运行
void WhereForeach()
{
var session = Z.Core.NHibernateCore.NHibernateHelper.GetCurrentSession();
var query = session.Linq<Model.Pub.Goods>().Where(l => 1 == 1);
var goods = new string[] { "A", "B", "C" };
foreach (var item in goods)
{
query = query.Where(l => l.Code != item);
}
var count = query.Count();
Console.Write(count);
}这到底是为什么呢?
解决方案 »
- list的赋值
- 1000-7,1200-15,1500-30这样的数组如何拆分成2个数组
- 请问怎样把SqlDataSource的数据填充到DataTable 中?
- 如何实现struct结构中成员插入数据库
- 图片自动切换.应该怎么实现
- 水晶报表报错(无法将请求提交给后台处理)
- JSP 和ASP.NET比较一下,那个好??
- 想组织几个变量,写成标准的日期格式再插入数据库中,只有日期,不包括时间
- 急!高手请进!问一个动态生成按钮ID重复的问题。
- 如何设置两个frame之间的分割条颜色,如http://expert.csdn.net/expert/forum.asp为黑色一样
- 请高手帮帮忙DataList嵌套问题
- 菜鸟问个弱智问题!高分
{
var session = Z.Core.NHibernateCore.NHibernateHelper.GetCurrentSession();
var query = session.Linq<Model.Pub.Goods>().Where(l => 1 == 1);
var goods = new string[] { "A", "B", "C" };
query = query.Where(l => !goods .Contains(l.Code));
var count = query.Count();
Console.Write(count);
}
query.Where("Code in {"+lst+"}");Where(p=>!goods.Contains(p.Code))