Entity Framework returns 0 rows, when the same SQL command returns many rows

Question

I have a model (M) that contains two tables(A and B). When I run the code from my MVC application to get the rows from (A) like this:

var context =new ClaimsHistorical();
context.CommandTimeout = 120;
IList<ClaimsSLAMonth> list = context.ClaimsSLAMonths.Where(x=>x.timeperiod == "2012-03").ToList();
var final = list.Select(c => new[]{
            c.branch.ToString().Trim(), c.NLPR_SLA.ToString() ?? null, c.NLPR_count.ToString() ?? null, c.NLPR_AvgLocktime.ToString() ?? null, c.NLPR_PIn.ToString() ?? null, c.NLPR_POut.ToString() ?? null,
            c.NLGA_SLA.ToString() ?? null, c.NLGA_count.ToString() ?? null, c.NLGA_AvgLocktime.ToString() ?? null, c.NLGA_PIn.ToString() ?? null, c.NLGA_POut.ToString() ?? null
        });

When I set a breakpoint for the list.Select to check the command it gives me the SQL which works in SSMS

It returns 0 rows (no errors, warnings, messages). I copied the SQL query that is being "executed" by the EF and pasted it to SQL Server Management Studio, it returns me the 5 or so rows.

Also when I run the exact same code except I substitute the table name to (B) I get the rows correctly. I tried to recreate the Model and it still returns nothing. Am I missing something obvious, or is there something seriously wrong?

You said you took the SQL that EF "executed", so you ran the SQL profiler, copied the generated SQL statement, and ran it in SSMS? Correct? — M.Babcock
– M.Babcock, Commented Apr 12, 2012 at 20:36
What @M.Babcock means is did you use the actual statement from SQL Profiler, or did you use the statement displayed by the debugger when you examine the query? — Erik Funkenbusch
– Erik Funkenbusch, Commented Apr 12, 2012 at 20:40
Yep. Put a breakpoint at the moment it was selecting stuff, looked at the object properties (where it has the connection string and the command string) copied it to SSMS and it gave me the rows i wanted. — Drakkainen
– Drakkainen, Commented Apr 12, 2012 at 20:41
What's your datatype? I'm wondering if your data might be padded (like you used a char datatype) so the exact compare fails. Maybe try a .Startswith() — Mark Peters
– Mark Peters, Commented Apr 12, 2012 at 20:51

Drakkainen · Accepted Answer · 2012-04-13 15:18:32Z

2

So apparently rebooting the computer fixed the problem?

If anyone has any possible reasons for this (caches, settings, anything) that would help in preventing this from happening again.

answered Apr 13, 2012 at 15:18

Drakkainen

1,14212 silver badges25 bronze badges

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

1 Comment

Jean-Paul Over a year ago

Is there another way to do this that you know off?

Collectives™ on Stack Overflow

Entity Framework returns 0 rows, when the same SQL command returns many rows

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related