读书人

如何把select [field1] from tab wher

发布时间: 2012-02-03 22:02:47 作者: rapoo

怎么把select [field1] from tab where [field1] like '%string1%'转换成linq
怎么把select [field1] from tab where [field1] like '%string1%'转换成linq

[解决办法]
from row in tab
where row.field1.Contains("string1")
select row.field1
[解决办法]
string.Contains("string")相当于'%string%'
string.StartWith("string")相当于'string%'
string.EndWith("string")相当于'%string'
[解决办法]

探讨
怎么把select [field1] from tab where [field1] like '%string1%'转换成linq

[解决办法]
写法很多,首先要了解大概的语句
[解决办法]
C# code
from row in tab    where  SqlMethods.Like(row.field1 ,  '%string1%') select row.field1 

读书人网 >.NET

热点推荐