EF join + 动态条件
EntityFramwork join + 动态条件
SchoolEntities db = new SchoolEntities();
var query = from u in db.UserBaseInfo
join m in db.Membership on u.UserId equals m.UserId
select new { UserName = u.Username, m.RealName };//使用sql server profiler 这里就已经查了数据库了~ 所以数据太多的说
if (!string.IsNullOrWhiteSpace(entName))
{
query.Where(x => x.RealName.Contains(entName));
}
count = query.Count();
怎么解决好 谢谢!