//using System.Data.Objects.SqlClient;
private void btnLike_Click(object sender, EventArgs e)
{
NorthwindEntities en = new NorthwindEntities();
var v = en.Employees.Where(x =>
SqlFunctions.PatIndex("%a%e%", x.FirstName) > 0);
//翻译成sql语句是
//WHERE ( CAST(PATINDEX(N'%a%e%', Employees.FirstName) AS int)) > 0
dataGridView1.DataSource = v.ToList();
}
内容全部来源于网络收集，如有侵权，请联系网站删除!