If no sorting order mentioned in SQL Server fetching data through EntityFramework gives different result.

Question

4.11/5 (2 votes)

See more:

, +

Hi,

I have a stored procedure which returns two records while executing directly from SQL Server Management Studio from which i am taking the top 1 record only.

Let say Record 1 & Record 2

When executing the stored procedure directly from SQL Server Management Studio it returns Record 1 but, calling the same procedure through Entity Framework returns Record 2. but if i'll sort the records it is giving correct result.

I just wanted to know is the default sorting order differs/matters in this case ? Is it different for both the cases ? Can anybody help me in this regard ?

Thanks in advance.

Posted 19-Aug-14 21:12pm

SRS(The Coder)

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Magic Wonder · Answer 1 · 2014-08-19T21:37:00

Solution 1

Hi,

As i know, data stored in database is in scattered manner. So, whenever you execute query without sorting, it displays result in that order in which it get data first. Whenever you mentioned the sorting, it again fetches the data in same manner but after fetching all data it apply sorting condition and displays the result as per sorting mentioned.

Hope this will give you some help.

Cheers

Posted 19-Aug-14 21:37pm

Magic Wonder

Comments

SRS(The Coder) 20-Aug-14 3:46am

There are two Date columns let say Date1 & Date2, the ordering is made on Date1 column but for this scenario Date1 is same for two records. When i am calling the stored procedure directly the sort order is different Record1 then Record2 but calling the same at the same time through EntityFramework returns result like Record2 first and then Record1.

My concern is why is it behaving differently same procedure when called from Entity Framework ?

Magic Wonder 20-Aug-14 3:57am

As you said, both records are having same value so whichever record is encountering first while fetching data will get display in that order as your data is already sorted. Database will give priority to First come basis.

SRS(The Coder) 20-Aug-14 4:45am

Here point is same procedure called directly and through Entity Framework and giving different result, which i do not understand..

Magic Wonder 20-Aug-14 5:17am

I have given importance of execution of query with or without sorting. By the way, execution from stored proc directly from MGMT studio is always giving same result? How many records are there in your table?

SRS(The Coder) 20-Aug-14 5:22am

table is having around 50 records from which procedure returning two from which i am taking TOP 1. So top 1 record varies when procedure called directly and when called through entity framework imported function.

Magic Wonder 20-Aug-14 5:36am

Okay but my query is still same. Is your top 1 record varying every time when you execute proc directly from MGMT? or is it same?

Is above case same with Entity Framework?

Here i am assuming both execution without sorting.

SRS(The Coder) 20-Aug-14 5:42am

same every time when called procedure directly as record1 then record2
only differs when called same procedure through entity framework as record2 then record1

Magic Wonder 20-Aug-14 5:59am

Not sure why it is behaving differently, but still i will check and then will get back to your query.

SRS(The Coder) 20-Aug-14 6:09am

Thanks a lot for the response and efforts you spent for this issue.

Magic Wonder 20-Aug-14 6:10am

Your welcome.