C# EF中like使用方式
var query = db.Table.Where(x => x.Status);
if (!string.IsNullOrEmpty(keyword))
{
string keywordLike = $"%{keyword}%";
query = query.Where(q =>
EF.Functions.Like(q.Column, keywordLike));
}
var query = db.Table.Where(x => x.Status);
if (!string.IsNullOrEmpty(keyword))
{
string keywordLike = $"%{keyword}%";
query = query.Where(q =>
EF.Functions.Like(q.Column, keywordLike));
}