Cannot execute stored procedure #5016

squaresunion created 8 years ago

Hello something that is really killing me

trying to execute a stored proc (Angular 5 .Net Core) g.Database.ExecuteSqlCommand("EXEC sp_GetNextBusinessId"); But is is always returning -1. Tried to use an output parameter, always returning value 0; Can somebody help. Please.

Regards

2 Answer(s)

0

squaresunion created 8 years ago

Ok found the proper way to do it.

SqlParameter param = new SqlParameter() { ParameterName = "@MyID", SqlDbType = SqlDbType.BigInt, Direction = ParameterDirection.Output }; var t = g.Database.ExecuteSqlCommand("EXEC sp_GetNextBusinessId @MyID OUT", param);

this works fine

Markdown is supported

Copy & paste or drag & drop images (max 30 MB per image)
0

alper created 8 years ago
Support Team

hi,

Check out Using Entity Framework Code First with Stored Procedures that have Output Parameters

Markdown is supported

Copy & paste or drag & drop images (max 30 MB per image)

Have an answer to this question? Log in and write your answer.