Question

asp.net mvc中使用linq to sql查询数据集(IQueryable类型) 怎么用foreach循环去数据集的数据?

StringBuilder str = new StringBuilder();
IQueryable<KyUserDev> n = udb.KyUserDev.OrderByDescending(d => d.ID);
n = from d in udb.KyUserDev
where d.IsCommend == "1"
orderby d.ID descending
select d;
n = n.Take(4);
if (n.Count() > 0)
{
foreach (var i in n)
{
str.AppendLine（i.name）;

}
}

Answer 1

你就不能转换成List<T>再用foreach吗？List<KyUserDev>list=n.ToList()

Answer 2

你这个应该交给Model，然后在视图里面foreach

Answer 3

foreach(var _var in und.KyUserDev)
{
if(_var.IsCommmend=="1")
{

}
}