public System.Data.Objects.ObjectResult <RPT_MonthGiftSummary_Result> GetMonthlySummary() { /* * select * from * ( * SELECT Year(GiftDate) Year, Month(GiftDate) Month, SUBSTRING (DATENAME(Month, (GiftDate)),0, 4) + ' ' + CAST( Year(GiftDate) as nvarchar) MonthName, * case when c.ParentID is null then c.CommodityID else c.ParentID end as CommodityID, SUM(WeightInMT) Weight * from GiftCertificate g join GiftCertificateDetail d on g.GiftCertificateID = d.GiftCertificateID join Commodity c on d.CommodityID = c.CommodityID * group by SUBSTRING(DATENAME(Month, (GiftDate)),0 , 4) + ' ' + cast( Year(GiftDate) as nvarchar) ,case when c.ParentID is null then c.CommodityID else c.ParentID end, Year(GiftDate), MONTH(GiftDate) * * ) as PivotData * PIVOT * ( * Sum(Weight) * For CommodityID in * ( [1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12] ) * ) as PivotTable * Order By Year,Month * END * */ //(from gift in _context.GiftCertificates select new {gift.GiftDate.Year,gift.GiftDate.Month, gift.GiftDate.Day, gift. })} return(_context.GetMonthlySummary()); }