var query = from Log in dt.AsEnumberable() where Log.id>100 select;
日期转换你可以用sql完成剩下的查询用linq完成。
var query=from m in member where m.id>100 select new{ companyname, ddate=Convert.ToDateTime(t.registerdate).Year-DateTime.Now.Year}
var m = (from l in Logistic.member where l.id > 100 select new { companyname = l.companyname, registerdate = Convert.ToDateTime(l.registerdate).Year - DateTime.Now.Year });
var m = (from l in Logistic.member where l.id > 100 select new { companyname = l.companyname, registerdate = Convert.ToDateTime(l.registerdate).Year - DateTime.Now.Year }); LINQ to Entities 不识别方法“System.DateTime ToDateTime(System.DateTime)”,
var m = (from l in Logistic.member where l.id > 100 select new { companyname = l.companyname, registerdate = DateTime.Now.Year-l.registerdate.Year}); 这样写就对了
where Log.id>100
select;
where m.id>100
select new{
companyname,
ddate=Convert.ToDateTime(t.registerdate).Year-DateTime.Now.Year}
LINQ to Entities 不识别方法“System.DateTime ToDateTime(System.DateTime)”,
这样写就对了