Home
Options

Please Close - Found my answer. Newb question...Between 2 Dates

edited March 2023

With the following SQL query I get 15 rows as expected....What would it look like in Linq?
SELECT pr.PowerReadingId, pr.ReadingDate, pr.Reading, t.TenantID, c.ContactID, pr.SiteID, pr.ParkID
FROM PowerReadings pr
INNER JOIN Tenants t ON pr.SiteID = t.SiteID
INNER JOIN Contacts c ON t.ContactID = c.ContactID
WHERE t.TenantID = @TenantID
AND pr.ReadingDate BETWEEN '02/20/2023' AND '03/20/2023'
ORDER BY pr.ReadingDate DESC;

Sign In or Register to comment.