如何将DateTime
转换为格式化的字符串?
需要帮助的是以下查询中的这一行:
StartDate = string.Format("{0:dd.MM.yy}", p.StartDate)
整个查询:
var offer = (from p in dc.CustomerOffer
join q in dc.OffersInBranch
on p.ID equals q.OfferID
where q.BranchID == singleLoc.LocationID
let value = (p.OriginalPrice - p.NewPrice) * 100 / p.OriginalPrice
orderby value descending
select new Offer()
{
Title = p.OfferTitle,
Description = p.Description,
BestOffer = value,
ID = p.ID,
LocationID = q.BranchID,
LocationName = q.CustomerBranch.BranchName,
OriginalPrice = SqlFunctions.StringConvert((decimal)p.OriginalPrice),
NewPrice = SqlFunctions.StringConvert((decimal)p.NewPrice),
StartDate = string.Format("{0:dd.MM.yy}", p.StartDate)
}).First();
我遇到了以下错误消息:
LINQ to Entities 不认识方法 'System.String ToString(System.String)',且此方法无法被转换为存储表达式。
using System.Data.Objects.SqlClient;
才能使用SqlFunctions
。 - Kristopher