运用EntityFramework里面SQL语句编写模糊查询
- 代码如下:
//获取【全部】数据
public static List<RankingList> GetRankings(string key = "")
{
using (MoviesEntities2 db = new MoviesEntities2())
{
return db.RankingList.Include("Area").Where(p => p.MovieName.Contains(key)).ToList();
}
}
- 效果图如下: