SqlFunctions
C# Linq to Enitty Lamda中日期格式化,请使用SqlFunctions.DateName
var data = db.Invoice.Select(i => new InvoiceVM { InvoiceId = i.InvoiceId, GroupIds = SqlFunctions.DateName("yyyy", i.BillDate )+"-"+SqlFunctions.Date ......
C# EF Linq SqlFunctions.DatePart
if (!string.IsNullOrEmpty(searchInfo.AuthorisedDate)) list_A = list_A.Where(q => q.AUTHORISED_DATE.HasValue && SqlFunctions.DatePart("yyyy", q.AUTHORI ......