someone please change the select to linq query
select DISTINCT(ID),Test from testcategory order by ID asc
Loading
4 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Hi Sangeetha,
Please try below Code,
Here tblTestCategroy is your entity object or any collection which you are getting from database
- var result= (from category in tblTestCategroy
- select category.ID, category .Test).Distinct().OrderBy(x => x.ID).ToList();;
Hi sangeetha,
- List
category = null ; // Fetched category from db - var data = category.Select(x => new { Id = x.ID, Name = x.Name).Distinct().OrderBy(z => z.Id).ToList();
@sangeetha palaniswamy
select DISTINCT(ID),Test from testcategory order by ID asc
LINQ
objtestcategory.Select(o=> new {
Id=o.ID,
Name = o.Name
}).Distinct()
Mark as answer,If it helps.
Thank you.
Laxmidhar SahooPosted Mar 14, 2020, 1:54 AM