Public Static Fields
  ProcPrefix | a string which can be used to filter out stored procs names when building config files |
Public Static Methods
 AddStatementForAllProcsInDatabaseToStatementsFile | Overloaded. Adds a statement for each stored procedures in the database to the specified statements.xml file. |
| AddStatementForAllProcsInDatabaseToStatementsFileSync | Overloaded. Adds a statement for each stored procedures in the database to the specified statements.xml file. |
| AddStatementForProcToStatementsFile | Overloaded. Adds a statement for the given stored procedure name to the specified statements.xml file. |
| CreateDeleteStatementForTable | Overloaded. Create Statement with the parameters needed to delete a record for the given database table |
| CreateInsertStatementForTable | Overloaded. Create Statement with the parameters needed to insert a record for the given database table with the default provider |
| CreateSelectStatementForTable | Overloaded. Create Statement with the parameters needed to select a record for the given database table |
| CreateSqlFile | Overloaded. Create a statement config file for the given stored procedure name |
| CreateSqlFiles | Overloaded. 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. |
| CreateSqlFilesSync | Overloaded. Syncronous version fo CreateSqlFiles |
| CreateUpdateStatementForTable | Overloaded. 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 |
| CreateParameter | Overloaded. 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
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