ASP.NET MVC Entity Framework - Linq query with order by
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?
asp.net-mvc linq
add a comment |
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?
asp.net-mvc linq
1
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
Nov 24 '18 at 10:06
add a comment |
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?
asp.net-mvc linq
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?
asp.net-mvc linq
asp.net-mvc linq
edited Nov 24 '18 at 9:29
marc_s
572k12811071253
572k12811071253
asked Nov 24 '18 at 9:22
Kalpa WijesooriyaKalpa Wijesooriya
175
175
1
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
Nov 24 '18 at 10:06
add a comment |
1
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
Nov 24 '18 at 10:06
1
1
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
Nov 24 '18 at 10:06
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
Nov 24 '18 at 10:06
add a comment |
1 Answer
1
active
oldest
votes
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()
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53456813%2fasp-net-mvc-entity-framework-linq-query-with-order-by%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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()
add a comment |
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()
add a comment |
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()
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 '18 at 11:11
Ivaylo StoevIvaylo Stoev
20216
20216
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53456813%2fasp-net-mvc-entity-framework-linq-query-with-order-by%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
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
Nov 24 '18 at 10:06