Stored procedures with output parameters using SqlQuery in the DbContext API

re: Stored procedures with output parameters using SqlQuery in the DbContext API

Diego B Vega — Tue, 11 Sep 2012 23:20:50 GMT

Crob, thanks for sharing this detail. I didn't test this with different versions of SQL Server so I didn't hit a problem with the missing EXEC. I will add a note to the post.

re: Stored procedures with output parameters using SqlQuery in the DbContext API

Crob — Tue, 11 Sep 2012 19:13:31 GMT

Found the solution here:

stackoverflow.com/.../what-causes-incorrect-syntax-near-stored-procedure-name-in-ef-code-first-and

re: Stored procedures with output parameters using SqlQuery in the DbContext API

Crob — Tue, 11 Sep 2012 18:13:48 GMT

I am using this against a sql2008 server and it's working great for me. I need to get the application to work against a sql2000 server but when I try it I get the exception "Incorrect syntax near 'stored procedure name here'." If I build the query string myself without using parameters it goes through fine like below:

var spResults = context.Database.SqlQuery<GoldmineCustomerInfo>("spweb20_GetCustomerInfoFromGoldMine @custCode = 'custcodevalue').ToList();

Do I have to tell EF this is a sql2000 server in my configuration somewhere?

re: Stored procedures with output parameters using SqlQuery in the DbContext API

Diego B Vega — Wed, 23 May 2012 04:39:27 GMT

@Nadeem: If you are refering to doing eager loading with SqlQuery, we don't have plans to support that. You can use lazy loading with entities materialized using SqlQuery though.

re: Stored procedures with output parameters using SqlQuery in the DbContext API

Nadeem — Wed, 23 May 2012 04:28:26 GMT

Does EF 5 SqlQuery materialize related entities or is it not supported yet ?!!

Thanks.

re: Stored procedures with output parameters using SqlQuery in the DbContext API

Diego B Vega — Wed, 18 Jan 2012 06:59:38 GMT

Jimi, I have just sent an answer to the question you posted in StackOverflow at stackoverflow.com/.../8906234. I am not familiar with how this part of the Oracle provider works but if ref curors can be bound as DbParameters I think it should be possible to make them work with this SqlQuery and ExecuteSqlCommand. I have also forwarded your question to some folks hoping they will be able to help you.

re: Stored procedures with output parameters using SqlQuery in the DbContext API

Jimi — Wed, 18 Jan 2012 06:01:34 GMT

Any idea whether this would work with an Oracle 11g database (in particular, a SP returning a refcursor), or is this purely MSSQL at the moment?