读书人

求通译一个 sql为linq

发布时间: 2013-04-20 19:43:01 作者: rapoo

求翻译一个 sql为linq
求翻译下面这个entity sql 翻译为 linq to entity
下面这是我自己写的多条件查询,linq怎么实现这种啊


public IEnumerable<Tfunction> GetTfunctionListByRole(IList<int> list)
{
using (MyHanMeErDunDbContext db = new MyHanMeErDunDbContext())
{
string sql = "select funcName from Tfunction where ";
for (int i = 0; i < list.Count; i++)
{
if (i == 0)
sql += "funcNo=" + list[0];
else
sql += " or funcNo=" + list[i];
}
var cmd = db.Database.Connection.CreateCommand();
db.Database.Connection.Open();
cmd.CommandText = sql;
List<Tfunction> fslist = new List<Tfunction>();
using (var reader = cmd.ExecuteReader(System.Data.CommandBehavior.SequentialAccess))
{
while (reader.Read())
{
Tfunction ts = new Tfunction();
ts.funcName = reader["funcName"].ToString();
fslist.Add(ts);
}
reader.Close();


}

db.Database.Connection.Close();
return fslist;
}
}

SQL LINQ entity
[解决办法]
linq可以用动态条件来查询
http://www.csharpwin.com/csharpspace/3466r990.shtml
http://www.cnblogs.com/livexy/archive/2010/07/12/1776032.html
[解决办法]
var query=Tfunction.Where(t=>list.Contains(t.funcNo)).Select(t=>t.funcName);

读书人网 >.NET

热点推荐