Entity Framework 6 and output parameter

Question

First time working with EF in general and wanted to call a stored procedure. So far I've added the stored procedure in a model (.edmx) and I believe that it's calling properly but I'm not sure how to add the output parameter.

This is what the stored procedure is accepting:

CREATE PROCEDURE [dbo].[uspProperty__Read] 
@Skip           INT = NULL,
@Take           INT = NULL,
@OrderBy        VARCHAR(50) = NULL,
@Return_Code        INT = 0 OUTPUT

I thought I could do this with the output parameter:

  var returnCode = new SqlParameter();
  returnCode.ParameterName = "@ReturnCode";
  returnCode.SqlDbType = SqlDbType.Int;
  returnCode.Direction = ParameterDirection.Output;

  var results = context.uspProperty__Read(10, 10, "NameDesc", out returnCode );

It looks like I've set the stored procedure correctly because "uspProperty_Read" comes up with the intellisense.

Error Message

Any suggestions are greatly appreciated. Thanks!

Have you seen this one? How to: Execute a Parameterized Stored Procedure Using EntityCommand — AndrasCsanyi
– AndrasCsanyi, Commented Jan 17, 2014 at 15:02

Cosmin Vană · Accepted Answer · 2014-01-17 15:04:20Z

2

Use ObjectParameter instead of SqlParameter.

answered Jan 17, 2014 at 15:04

Cosmin Vană

1,62214 silver badges28 bronze badges

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

1 Comment

Mike Stone Over a year ago

Thanks for the help! That resolved the issue. I can't believe I didn't look for ObjectParameter when it was staring in my face. Thanks again!

Collectives™ on Stack Overflow

Entity Framework 6 and output parameter

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