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

怎么把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'
[解决办法]

C# code

from row in tab    where  SqlMethods.Like(row.field1 ,  '%string1%') select row.field1