Get last record in linq c#
WebJul 1, 2014 · You should sort your records based on the ID instead of ScheduleId and also filter the records that has the empty Filename: objContext.SchedulesAndFiles .Where(x => x.ScheduleId == scheduleId && x.Filename != "") .OrderByDescending(x => x.ID) … WebAug 24, 2024 · You only want the first one when ordered by the Id in descending order. [HttpGet] public int GetStudentId () { var latestStudentRecord = _context.StudentModel .OrderByDescending (a => a.Id) .First (); // return only the Id property of the latest record return latestStudentRecord.Id; }
Get last record in linq c#
Did you know?
Webvar res = (from element in list) .OrderBy (x => x.F2) .GroupBy (x => x.F1) .Select () Now if you want to do something more complex like take the same grouping result but take the first element of F2 and the last element of F3 or something more custom you can do it by studing the code bellow WebI have a LINQ query to find records for the last 7 days which works fine No, you have a query that returns the calories burned more than 7 days ago (ie 8, 9, 10, etc). The way you structured your query, the correct way would be w.Date >= DateTime.Now.AddDays (-n) to get the last n days. Share Improve this answer Follow
WebNov 19, 2014 · var QueryDeatils = from M in db.Tr_Mealcode where M.codeDate.Date >= DateTime.Now.Date.AddDays (-7) group M by M.merchantID into G select new { MerchantId=G.Select (m=>m.merchantID) }; After trying this I got an exception The specified type member 'Date' is not supported in LINQ to Entities.
WebJul 26, 2016 · 1 I have list as follows static List CurrentMessage = new List (); Dynamically, values assigned to this list for example: CurrentMessage.Add (new MessageDetail { UserName = 123,GroupName = somegrp, Message = somemsg }); Here, I want to take last 5 or so records. WebMy Linq query returns one record for each company, but it doesn't return the most recent ones: var query = from p in db.Payments where p.Status == false && DateTime.Compare (DateTime.Now, p.NextPaymentDate.Value) == 1 group p by p.CompanyID into op select op.OrderByDescending (nd => nd.NextPaymentDate.Value).FirstOrDefault ();
WebApr 8, 2024 · Check if a string within a list contains a specific string with Linq. Proper LINQ where clauses. I'm using the version 6.0.10 of Entity Framework and SQL Server provider. But it's seems that these formulas cannot be translated, throwing an exception with the following message: The LINQ expression 'name => EntityShaperExpression: …
WebAug 14, 2012 · Have a look at the list of Supported and Unsupported LINQ Methods. Last () is not supported, but First () is, so you can just go on and reverse your ordering and use First () instead of Last (). mf => mf.AuditItems.OrderByDescending (ai => ai.DateOfAction).First ().Step == 1); Share Improve this answer Follow edited Aug 14, … ion-usd cryptoWeb2 days ago · In my ASP.NET Core web application, I have a client sided list of Roles objects. Each of those objects contains three string properties and a string list containing the role names. I need to query entities of type Notification from a SQL Server database using EF Core and filter based on those roles. To do this, I need to check if the list ... ion usb turntable ttusb manualWebHow to use MS-XCEP and MS-WSTEP in .NET or JavaScript to get a certificate from AD CS? Display treeviewitem as grid rows in wpf; Output logs to Xunit using Serilog Static Logger in C#; Getting "error": "unsupported_grant_type" when trying to get a JWT by calling an OWIN OAuth secured Web Api via Postman; How to select last record in a LINQ ... on the job the missing 8WebDec 16, 2011 · LINQ var lastFiveProducts = (from p in products orderby p.ProductDate descending select p).Take (5); Lambda var lastFiveProducts = products.OrderByDescending (p => p.ProductDate).Take (5); Which ever you prefer. Share Improve this answer Follow answered Dec 16, 2011 at 10:23 James 79.7k 18 163 236 on the job techniquesWebJun 7, 2011 · 15. I have this: var result = (from t in MyDC where t.UserID == 6 orderby t.UpdateTime select t.ID).Last (); Basically, I'm using Linq-to-Sql and it doesn't support the .Last operator. I could retrieve all the records of the user and then using linq to objects to get my value but I'm wondering how to do this with linq-to-sql and return only one ... ion usb turntable with builtin cd recordingWebJul 14, 2024 · 1. If the Employee.Empid is the primary key, a crude way to do this could be as follows: var empDepList = (from D in db.Department join E in db.Employee on D.Empid equals E.Empid where D.Status == 1 orderby E.Empid, D.Depid descending select new { D.DepartmentName, E.EmployeeName }).FirstOrDefault (); Share. on the jobs training in wilkes barre paWebDec 19, 2024 · As I understood, you need all records from Table, that belongs to active(IsActive = true) Customer with certain Id (CustomerId = ), and that records must be the latest (max(CreatedOn)). I didn't understand what is the ConsentId and do you … on the job: the missing 8