C# Class PetShop.Data.SqlClient.StoredProcedureProvider

Private Properties

Property	Type	Description
Deserialize	object
GetProcedureBodyFromEmbeddedResource	string
InitializeProcedureLookupTables	void

Method	Description
GetCommandWrapper ( Microsoft.Practices.EnterpriseLibrary.Data.Database database, String commandName, Type columnEnum, SqlFilterParameterCollection parameters, String orderBy, int start, int pageLength ) : DbCommand	Gets the command wrapper for a dynamically generated query and optionally includes server-side paging.
GetCommandWrapper ( Microsoft.Practices.EnterpriseLibrary.Data.Database database, string commandName, bool useStoredProcedure ) : DbCommand	Get the command wrapper, either from the stored procedures or from the embedded queries.
Serialize ( string filename ) : void	Serializes the specified filename.
StoredProcedureProvider ( ) : System	Creates a new StoredProcedureProvider instance.
this ( int index ) : Procedure	Gets or sets the Procedure instance at the specified index.
this ( string name ) : Procedure	Gets or sets the Procedure instance with the specified name.

Method	Description
Deserialize ( ) : object	Deserializes this instance.
GetProcedureBodyFromEmbeddedResource ( string name ) : string	Get the query text from the embedded xml file.
InitializeProcedureLookupTables ( ) : void

Gets the command wrapper for a dynamically generated query and optionally includes server-side paging.

public static GetCommandWrapper ( Microsoft.Practices.EnterpriseLibrary.Data.Database database, String commandName, Type columnEnum, SqlFilterParameterCollection parameters, String orderBy, int start, int pageLength ) : DbCommand
database	Microsoft.Practices.EnterpriseLibrary.Data.Database
commandName	String
columnEnum	System.Type
parameters	SqlFilterParameterCollection
orderBy	String
start	int
pageLength	int
return	System.Data.Common.DbCommand

Get the command wrapper, either from the stored procedures or from the embedded queries.

public static GetCommandWrapper ( Microsoft.Practices.EnterpriseLibrary.Data.Database database, string commandName, bool useStoredProcedure ) : DbCommand
database	Microsoft.Practices.EnterpriseLibrary.Data.Database	The database instance.
commandName	string	the name of the sp.
useStoredProcedure	bool	Indicates if we want stored procedure.
return	System.Data.Common.DbCommand

Serializes the specified filename.

public Serialize ( string filename ) : void
filename	string	Filename.
return	void

Creates a new StoredProcedureProvider instance.

public StoredProcedureProvider ( ) : System
return	System

Gets or sets the Procedure instance at the specified index.

public this ( int index ) : Procedure
index	int
return	Procedure

Gets or sets the Procedure instance with the specified name.

public this ( string name ) : Procedure
name	string
return	Procedure