My query is return not table values

Cass

New Member
Hai i have FinancialCompliances and Compliance tables. Below my query work flow is get one latest row .The problem is i have empty values in table because i deleted all rows in my table .But my below query is return one old rows .\[code\]var Compliance = (from c in datamodel.Compliances join f in datamodel.FinancialCompliances on c.ComplianceId equals f.ComplianceId where (c.VerifierId == userId || c.OwnerId == userId || c.UserId == userId) && (f.ComplianceId == c.ComplianceId) orderby (f.AddedDate) select f); financialCompliance = Compliance.ToList().LastOrDefault();\[/code\]What problem?
 
Back
Top