how to retrieve the latestdate inspected from a column
In our app a user can inspect an item and when it inspected the current date is entered into the table. For the same item someother can uninspect it this time nothing is inserted into the table. Another user can inspect it and current date is inserted I need to get the LatestDate Inserted..how to get this with Linq
Let say table name is Statuses and col name is LastdateInspected
Select(grp => new { ID = grp.Key.ID, Day = grp. Key. Day, Date = grp.
Go to your SSMS or whatever tool you use and run your queries from there. If you can get your output from there then you can translate it to code. If you look at the previous comments, everyone, in essence, is telling you to review your data model.
Entity Framework Core uses Language-Integrated Query (LINQ) to query data from the database. LINQ allows you to use C# (or your . NET language of choice) to write strongly typed queries.
LINQ to Entities provides Language-Integrated Query (LINQ) support that enables developers to write queries against the Entity Framework conceptual model using Visual Basic or Visual C#. Queries against the Entity Framework are represented by command tree queries, which execute against the object context.
Sounds like you want something like:
var query = db.Statuses
.OrderByDescending(x => x.LastDateInspected)
.FirstOrDefault();
That will return null
if there are no entries, or the value with the latest LastDateInspected
value otherwise (i.e. the first result, having ordered by the last date inspected latest-first).
That will get you the whole record, of course. If you only want the date, you can select the LastDateInspected
column.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With