• Using the StoredProcedureFramework
• Table of Contents
• Representing Stored Procedures in Code
• General Rules
• Base Classes
• StoredProcedureBase
• NoParametersStoredProcedureBase
• NoReturnTypeStoredProcedureBase
• Type Parameters
• TReturn
• TParameters
• Constructors
• ctor()
• ctor(string procedureName) : base(procedureName) {}
• ctor(string schemaName, string procedureName) : base(schemaName, procedureName) {}
• ctor(TParameters parameters) : base(parameters) {}
• ctor(string procedureName, TParameters parameters) : base(procedureName, parameters) {}
• ctor(string schemaName, string procedureName, TParameters parameters) : base(schemaName, procedureName, parameters) {}
• Stored Procedure Attributes
• DirectionAttribute
• NameAttribute
• ParameterDbTypeAttribute
• PrecisionAttribute
• ScaleAttribute
• SchemaAttribute
• SizeAttribute
• Example Usage
• The most basic type of stored procedure
• NullStoredProcedureResult
• NullStoredProcedureParameters
• A Stored Procedure without Parameters
• A Stored Procedure with Parameters but without a Return Type
• A "Normal" Stored procedure
• A Stored Procedure With Multiple RecordSets
• A Stored Procedure with Table Value Parameters
• Calling the Stored Procedures from Code
• Calling the Stored Procedures from Code using SqlConnection
• Using Transactions with SqlConnection
• Using TransactionScope
• Rolling Back a Transaction
• Committing A Transaction
• SqlTransaction
• Rolling back a Transaction
• Committing a Transaction
• Calling the Stored Procedures from Code using DbContext
• Calling the Stored Procedures from Code using DbContext in traditional way
• Calling the Stored Procedures from Code using DbContext in Simplified API way
• Calling the Stored Procedures from Code using DbContext in Simplified API with In-Line Declaration
• Using Transactions with DbContext
• Using TransactionScope
• Rolling Back a Transaction
• Committing A Transaction
• SqlTransaction
• Rolling back a Transaction
• Committing a Transaction