Skip to content

StrorProcedure To Generate Data Provider Class From Table

************** Execute StoreProcedure **************** sp_CreateDataProviderFromTable ‘Tablename’, ‘name’ ************** StoreProcedure to store *************** CREATE proc [dbo].[sp_CreateDataProviderFromTable] ( @TableName NVARCHAR(50), @MethodName varchar(100) ) as DECLARE @ProtdVars VARCHAR(max),@PublicProps VARCHAR(max), @CMDProps VARCHAR(max), @InsertStmt VARCHAR(max), […]

Store Procedure To Generate Class From Table

*********** Execute StoreProcedure ********************** sp_GenerateClassFromTable ‘TableName’ *********** StoreProcedure to store ********************* CREATE proc [dbo].[sp_GenerateClassFromTable] ( @TableName NVARCHAR(50) ) as DECLARE @ProtdVars NVARCHAR(max),@PublicProps NVARCHAR(max), @CMDProps NVARCHAR(max), @InsertStmt NVARCHAR(max), @UpdateStmt NVARCHAR(max) Declare […]