You need to create a model class that contains all stored procedure properties like below. Also because Entity Framework model class needs primary key, you can create a fake key by using Guid. public class GetFunctionByID { [Key] public Guid? GetFunctionByID { get; set; } // All the other properties. } then register the GetFunctionByID … Read more
So let’s say you have a stored procedure in tempdb: USE tempdb; GO CREATE PROCEDURE dbo.my_procedure AS BEGIN SET NOCOUNT ON; SELECT foo = 1, bar=”tooth”; END GO There is a quite convoluted way you can go about determining the metadata that the stored procedure will output. There are several caveats, including the procedure can … Read more
I found it! I can read the return value with an output parameter that has to be used in this way: // define a new output parameter var returnCode = new SqlParameter(); returnCode.ParameterName = “@ReturnCode”; returnCode.SqlDbType = SqlDbType.Int; returnCode.Direction = ParameterDirection.Output; // assign the return code to the new output parameter and pass it to … Read more
Stored procedures are a batch of SQL statements that can be executed in a couple of ways. Most major DBMs support stored procedures; however, not all do. You will need to verify with your particular DBMS help documentation for specifics. As I am most familiar with SQL Server I will use that as my samples. … Read more
Access 2010 has both stored procedures, and also has table triggers. And, both features are available even when you not using a server (so, in 100% file based mode). If you using SQL Server with Access, then of course the stored procedures are built using SQL Server and not Access. For Access 2010, you open … Read more
In my case I received this exception even when all parameter values were correctly supplied but the type of command was not specified : cmd.CommandType = System.Data.CommandType.StoredProcedure; This is obviously not the case in the question above, but exception description is not very clear in this case, so I decided to specify that.
There is no difference in terms of functionality. In fact, both do this: return this.Add(new SqlParameter(parameterName, value)); The reason they deprecated the old one in favor of AddWithValue is to add additional clarity, as well as because the second parameter is object, which makes it not immediately obvious to some people which overload of Add … Read more
MySQL 5.5 introduces signals, which are similar to exceptions in other languages: http://dev.mysql.com/doc/refman/5.5/en/signal.html For example, in the mysql command line client: mysql> SIGNAL SQLSTATE ‘45000’ SET MESSAGE_TEXT = ‘Custom error’; ERROR 1644 (45000): Custom error
Setting up a link between Oracle SQL objects and java objects manually is not a trivial task. In particular, arrays (or nested tables) of user-defined objects are more complex to pass from java to Oracle than arrays of standard datatypes. In other words, it is easier to call a procedure with signature: (TABLE OF NUMBER, … Read more
VARIADIC Like @mu provided, VARIADIC is your friend. One more important detail: You can also call a function using a VARIADIC parameter with an array type directly. Add the key word VARIADIC in the function call: SELECT * FROM f_test(VARIADIC ‘{1, 2, 3}’::int[]); is equivalent to: SELECT * FROM f_test(1, 2, 3); Other advice In … Read more