The methods of the SqlProvider class are listed below. For a complete list of SqlProvider class members, see the SqlProvider Members topic.
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 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 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 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