R – How to use stored procedures in SubSonic 3.0.3

stored-proceduressubsonic3

I have a problem in SubSonic 3.0.3. When I use SubSonic to generate code, I can use all the tables in the database, but I can't see any of the stored procedures which had been defined in database.

Please help.

P.S. : I am using MSSQL

Best Answer

Make sure you are including the StoredProcedures.tt file. Running the t4 should generate the code for you to use stored procedures.

Related Solutions

Sql – Functions vs Stored Procedures

If you're likely to want to combine the result of this piece of code with other tables, then obviously a table-valued function will allow you to compose the results in a single SELECT statement.

Generally, there's a hierarchy (View < TV Function < Stored Proc). You can do more in each one, but the ability to compose the outputs, and for the optimizer to get really involved decreases as the functionality increases.

So use whichever one minimally allows you to express your desired result.

Mysql – List of Stored Procedures/Functions Mysql Command Line

SHOW PROCEDURE STATUS;
SHOW FUNCTION STATUS;

Best Answer

Related Solutions

Sql – Functions vs Stored Procedures

Mysql – List of Stored Procedures/Functions Mysql Command Line

Related Topic