Loading

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

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

Adrian Reszka

10y969LINQ

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,-2,GETDATE()) AND DATEADD(ww,4,GETDATE())
Group by [PID_unique_ID]

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mansi Gupta10y ago
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 <= dtEndDate
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
};
0
Bhuvanesh Mohankumar10y ago
PublicclassDateInformation
{
publicintId;
publicDateTimeStartDate;
publicDateTimeEndDate;
}
varcurrentDate=DateTime.Now;
vardateInfo=fromdateDetailinDateInformation
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.
0