读书人

怎么将下面的SQL语句改成LINQ语句

发布时间: 2012-03-13 11:21:11 作者: rapoo

如何将下面的SQL语句改成LINQ语句
select * from dbo.View_1 where DepName like '%" + textbox + "%'or UserName like '%" + textbox + "%'"

[解决办法]
var q = from c in db.View_1
where SqlMethods.Like(c.DepName, "%"+textbox+"%")||
SqlMethods.Like(c.UserName, "%"+textbox+"%")
select c;

读书人网 >.NET

热点推荐