Stored procedure works fine i db but not from the code

Question

User2054871671 posted

I have a stored procedure which works perfectly fie when I run it directly on the db. The same stored procedure gives me error when I run it from the c# code.

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 

Answer 1

User2103319870 posted

If possible provide the code in which you are facing this issue

Answer 2

User475983607 posted

I have a stored procedure which works perfectly fie when I run it directly on the db. The same stored procedure gives me error when I run it from the c# code.

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 

As the error states the procedure has an subquery that returns multiple results.  Your test does not cause the subquery to return multiple results.  The C# code is mostly likely passing parameters that cause the subquery to return more than one record which is not covered in your test.

Answer 3

User2054871671 posted

I have used the same parameters when I'm running it through code as well as when I'm running directly. In fact while debugging the code I checked if the correct parameters has been sent or not and everything looks good but I get the error when ran from code. 

Answer 4

User475983607 posted

I have used the same parameters when I'm running it through code as well as when I'm running directly. In fact while debugging the code I checked if the correct parameters has been sent or not and everything looks good but I get the error when ran from code. 

The error is very specific.  There is not much we can do without code that reproduces the error.