Our Training Programs

All contents are copyright of their authors.

linq query

linq query

Sandeep Kumar

4yAsked Jul 14, 2022, 12:22 PM888.NET Core

in linq query ,it will use in asp.net core api

i want colored raw means if a personid has Actiontypyid=3 then actiontypeid =3 raw data

and another personid has only actionTypeId= 1 then actiontypeid =1 raw data

note:- actionTypeId=2 No Required

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Sachin Singh4y ago
Ok got it what do you want.
Use this
var res=_context.YourDbSet.GroupBy(l => l.PersonId)
.Select(g=>g.OrderByDescending(c=>c.ActionTypeId).FirstOrDefault())
.ToList()
Sandeep Kumar4y ago
it not easy like u thinking, i need two clored raw condtion is if personId cantains actiontypeId=3 then actiontypeId=3 raw and if another persionid has Actiontype id 1 only not actiontypeid=3 then actiontypeId=1 raw
always last .
Sachin Singh4y ago
What is the issue? Can't you use simple where() method?
var res= _context.DbContext.Where(x=>x.ActionTypeId==1 || x.ActionTypeId==3).ToList();
Sandeep Kumar4y ago
No No I am talking about Linq Query Not UI
How to write Linq Query to fetch Colored Raw
Jignesh Kumar4y ago
Hi Sandeep,

UI side with technology you are using, MVC or Angular, You just need to apply condition and css classes to change your color based on your requirement.