CODEWITHSUNDEEP
asp.netentity-frameworkasp.net-mvc-4entity
Hasib Tarafder
Hasib Tarafder

Reputation: 5813

Convert sql to entity in query syntax

How can i convert the following query to entity framework in query syntax..

SELECT MIN(Date) StartDate, MAX(Date) EndDate, Title, Flag FROM Holiday GROUP BY Title, Flag

Any help?

Upvotes: 1

Views: 159

Answers (2)

Damith
Damith

Reputation: 63065

var results = db.holidays.GroupBy(g => new { g.Title, g.Flag }).Select(k => new
{
    MinDate = k.Min(a => a.Date),
    StartDate = k.FirstOrDefault().StartDate,
    MaxDate = k.Max(b => b.Date),
    EndDate = k.FirstOrDefault().EndDate,
    Title = k.Key.Title,
    Flag = k.Key.Flag
}).ToList();

Upvotes: 0

Hasib Tarafder
Hasib Tarafder

Reputation: 5813

After a hard time i get the solution

(from e in db.Holidays
 group e by new {e.Title, e.Flag}
 into g
 select new AllEventViewModel
 {
 start = g.Max(e=>e.Date),
 end = g.Min(e => e.Date),
 title = g.Key.Title,
 Flag = g.Key.Flag
 }).AsEnumerable();

Upvotes: 1

Related Questions