SnapDAL Library Documentation

SqlProvider Members

SqlProvider overview

Public Static Fields

ProcPrefix a string which can be used to filter out stored procs names when building config files

Public Static Methods

AddStatementForAllProcsInDatabaseToStatementsFileOverloaded. Adds a statement for each stored procedures in the database to the specified statements.xml file.
AddStatementForAllProcsInDatabaseToStatementsFileSyncOverloaded. Adds a statement for each stored procedures in the database to the specified statements.xml file.
AddStatementForProcToStatementsFileOverloaded. Adds a statement for the given stored procedure name to the specified statements.xml file.
CreateDeleteStatementForTableOverloaded. Create Statement with the parameters needed to delete a record for the given database table
CreateInsertStatementForTableOverloaded. Create Statement with the parameters needed to insert a record for the given database table with the default provider
CreateSelectStatementForTableOverloaded. Create Statement with the parameters needed to select a record for the given database table
CreateSqlFileOverloaded. Create a statement config file for the given stored procedure name
CreateSqlFilesOverloaded. Create statement config files for all of the stored procedures in the database referred to by the connection string and put them in the given cacheDir. This command is long running so it is executed asynchronously. If you want to wait for the results, use the xxxSync version of the command.
CreateSqlFilesSyncOverloaded. Syncronous version fo CreateSqlFiles
CreateUpdateStatementForTableOverloaded. Create Statement with the parameters needed to update a record for the given database table
CreateXMLForStatement Create the xml for the given Statement. Used for the creation of statement files where multiple statements are combined into a single statement file

Public Instance Properties

Name The provider name
ParamTypeMappings (inherited from Provider) The parameter type mapping associated with the provider. See the documentation
Statements (inherited from Provider) The statement manager and cache.

Public Instance Methods

CreateCommand (inherited from Provider) Create a command for this provider. In this version, the actual sql is used instead of a statement name
CreateConnection (inherited from Provider) Create a Connection for this provider
CreateDataAdapter (inherited from Provider)Overloaded. Create a DataAdapter for this provider
CreateParameter (inherited from Provider)Overloaded. Create a parameter for this provider and set the value
CreateParameterOverloaded. Create a SQLParameter for this provider.
Equals (inherited from Object)Determines whether the specified Object is equal to the current Object.
GetHashCode (inherited from Object)Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table.
GetStatement (inherited from Provider)Overloaded. Looks up a statement from the manager. Allows for abstractions away from the StatementManager.
GetType (inherited from Object)Gets the Type of the current instance.
ToString (inherited from Object)Returns a String that represents the current Object.

Protected Instance Fields

_classTypes (inherited from Provider)A holder class for the types of objects a provider can create
_paramTypes (inherited from Provider)The mapping of CLR/Types to DB types (enum values for each provider)
_recordToDir (inherited from Provider) Do we record the data as we get it?
_statements (inherited from Provider)The StatmentmentManage who can cache and collect statements

Protected Instance Methods

CloneCommand (inherited from Provider) Clones a command from the statement.
Finalize (inherited from Object)Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
GetStatement (inherited from Provider)Overloaded. Looks up a statement from the manager. Allows for abstractions away from the StatementManager.
MemberwiseClone (inherited from Object)Creates a shallow copy of the current Object.

Protected Internal Instance Constructors

SqlProvider Constructor

Protected Internal Instance Methods

CreateDataAdapter (inherited from Provider)Overloaded. Create a DataAdapter for this provider
ExecuteScalar (inherited from Provider) 
GetDataSet (inherited from Provider) 
GetDataTable (inherited from Provider) 
LoadDefaultParamTypes (inherited from Provider) Set up the default parameter types. This method is where the provider determines both the parameter types that are supported, as well as the mapping between the IDb types and the real parameter types.

See Also

SqlProvider Class | SnapDAL.Providers Namespace