ASP.NET MVC Entity Framework - Linq query with order by

Question

I have data table call issue_line_person (above picture). I want to retrieve set of rows which are equal to specific line_id and issue_id, with ascending order according to the levelOfResponsibility.

This is the SQL query for that.

SELECT * 
FROM issue_line_person 
WHERE line_id = " + line_line_id + " AND issue_id = " + issueId + " 
ORDER BY levelOfResponsibility

How to do that using Entity Framework and a Linq method?

A good start would be to show your Entity Framework model. We have no idea at which stage of the process you're stuck. — Gert Arnold
– Gert Arnold, Commented Nov 24, 2018 at 10:06

Ivaylo Stoev · Accepted Answer · 2018-11-24 11:11:15Z

1

Assuming you have an entity "Issue_Line_Person" in your EF model without properties in child entities.

var result = Issue_Line_Person.Where(_=>_.line_id == LINEID && _.issue_id == ISSUEID).OrderBy(_=>_.levelOfResponsibility).ToList()

answered Nov 24, 2018 at 11:11

Ivaylo Stoev

4874 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ASP.NET MVC Entity Framework - Linq query with order by

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related