desiredRecords = (from e in MdmsContext.ExtractSchedule join u in MdmsContext.ExtractDefinition on e.ExtractID equals u.Id where u.TenantId == Context.TenantId select new { e.Id, e.ExtractName, e.NextRunTime }).OrderByDescending(x => x.Id)
SELECT e.Id, e.ExtractName, e.NextRunTime FROM ExtractSchedule AS e INNER JOIN ExtractDefinition AS u ON e.ExtractID = u.Id AND u.TenantId == @TenantId ORDER BY e.Id DESC
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)