I want to receive the stored procedure OUTPUT Parameter

Asked 1 years ago, Updated 1 years ago, 80 views

I am developing an API with Visual Studio 2013 c#.

I'm going to use StoredProcedure to select the data in the table.
I don't know how to get the retrieved data with C# code.
I am using ObjectParameter, but I am getting the error System.InvalidOperationException: The type parameter 'System.String' in ExecuteFunction is incompatible~
I tried to find the error and fix the code, but there was nothing wrong.
So, I think I'm using ObjectParameter incorrectly, so
I would like to know how to use ObjectParameter in code.
Also, is it possible to bring the results selected in the procedure as a list?
For example, a person whose name starts with "ka" and is over 160 tall has been searched for more than 10 masterpieces.
How do I get this result?

By the way, I use Mysql.

c# mysql visual-studio entity-framework

2022-09-29 22:49

1 Answers

See how to run queries using the IN and OUT parameters and stored procedures.
Of course, it is possible to have multiple parameters.


2022-09-29 22:49

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.