C# Linq to Enitty Lamda中日期格式化,请使用SqlFunctions.DateName

发布时间 2023-09-11 13:11:11作者: James·wang
var data = db.Invoice.Select(i => new InvoiceVM
{
InvoiceId = i.InvoiceId,
GroupIds = SqlFunctions.DateName("yyyy", i.BillDate )+"-"+SqlFunctions.DateName("MM", i.BillDate ),
Description = i.Description, CreateDate = i.CreateDate, }).OrderBy(i => i.InvoiceCode);
}