R – SubSonic 3.0 stored procedure generation

stored-proceduressubsonic3

When using SubSonic 3.0.0.3 and the StoredProcedures.tt template, the generated code won't compile and throws an error:

… 'DB' does not contain a definition for 'Provider' …

This is in the calling method for the sproc.

StoredProcedure sp = new StoredProcedure("Company_Get", this.Provider);

Am I missing something or is there a bug in the 3.0 templates for generating wrappers around stored procedures?

Best Answer

I guess those of us wanting to use v3 of SubSonic are on the bleeding edge. I needed to generate the code with the context.tt as well. This corrected my problem. This is really cool stuff, but the screen casts and the docs are not keeping up with how quickly the product is evolving.

Related Solutions

Sql-server – Select columns from result set of stored procedure

Can you split up the query? Insert the stored proc results into a table variable or a temp table. Then, select the 2 columns from the table variable.

Declare @tablevar table(col1 col1Type,..
insert into @tablevar(col1,..) exec MyStoredProc 'param1', 'param2'

SELECT col1, col2 FROM @tablevar

Sql – Insert results of a stored procedure into a temporary table

You can use OPENROWSET for this. Have a look. I've also included the sp_configure code to enable Ad Hoc Distributed Queries, in case it isn't already enabled.

CREATE PROC getBusinessLineHistory
AS
BEGIN
    SELECT * FROM sys.databases
END
GO

sp_configure 'Show Advanced Options', 1
GO
RECONFIGURE
GO
sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO

SELECT * INTO #MyTempTable FROM OPENROWSET('SQLNCLI', 'Server=(local)\SQL2008;Trusted_Connection=yes;',
     'EXEC getBusinessLineHistory')

SELECT * FROM #MyTempTable

Best Answer

Related Solutions

Sql-server – Select columns from result set of stored procedure

Sql – Insert results of a stored procedure into a temporary table

Related Topic