How to write a linq query to match this sql one ... ?

Question

Hi Can someone help me out with writing a linq querry to match this sql one ? SELECT [PID_unique_ID] min(AllocationStart) as 'start'  max(AllocationStart) as 'end' GETDATE() AS CurrentDateTime FROM [table].[dbo].[table_name] Where table_name.AllocationStart BETWEEN DATEADD(ww-2GETDATE()) AND DATEADD(ww4GETDATE()) Group by [PID_unique_ID]

Bhuvanesh Mohankumar · Answer

Public class DateInformation { public int Id; public DateTimeStartDate; public DateTimeEndDate; } varcurrentDate=DateTime.Now; vardateInfo=fromdateDetail in DateInformation Where(dateDetail.StartDate>currentDate&& dateDetail.EndDate SelectdateDetail.Id; Please try this Note: Its sample snippet I never tested the code please fix if has anysmall issues. Mark as answer if helpful.

Mansi Gupta · Answer

Try the below sample code var dtStartDate = DateTime .Now.AddDays(-14).Date; var dtEndDate = DateTime .Now.AddDays(28).Date; var result = from alloc in lstAllocation where alloc.AllocationStart >= dtStartDate && alloc.AllocationStart group alloc by alloc.PID_unique_ID into allocTemp select new { PID_unique_ID = allocTemp.Key start = allocTemp.Select(a => a.AllocationStart).Min() end = allocTemp.Select(a => a.AllocationStart).Max() CurrentDateTime = DateTime .Now };