Using stored procedures with LINQ

Question

I want to use LINQ to call stored procedure in this way but stored procedure I want to call contain SQL string that executed by

EXEC sp_executesql @strSQL

In this way Visual Studio does not generate result class. To resolve this problem I execute SQL string by

INSERT INTO @Temp EXEC sp_executesql @strSQL
SELECT * from @Temp

Maybe it is not the best way but it works. The problem is that it sometimes return items in wrong sequence. How to fix it?

@BasB I don't know a reason. This is a little bit complicated query (written not by me) — shtkuh, Jan 03 '12 at 16:07

score 1 · Accepted Answer · edited Jan 03 '12 at 16:02

1

Use an Order By to specify the sort order

edited Jan 03 '12 at 16:02

Ian Nelson

answered Jan 03 '12 at 16:00

Joe

Thanks. I just moved Order By line from SQL string to final SELECT and it did the trick. – shtkuh Jan 03 '12 at 16:15

1 Answers1