啥叫不支持Like关键字? 用StartsWith,EndsWith,Contains做等价替换就可以了啊 List<string> list = new List<string>(); list.AddRange(new string[]{"Test1","Test2","T3"}); list = (from s in list where s.StartsWith("Test") select s).ToList(); list.ForEach(s => Console.WriteLine(s));
我希望以这种方式查询: .Where("id = @0 , name like @1 ", 1, "jack") 还有,例如sql:select name like '%jack',查询以'jack'开头的name值,该怎么查询?
where s.StartsWith("Test")
select s).ToList(); list.ForEach(s => Console.WriteLine(s));
.Where("id = @0 , name like @1 ", 1, "jack")
还有,例如sql:select name like '%jack',查询以'jack'开头的name值,该怎么查询?