SqlServerFactory Class |  |
This is the class that implements a Factory to access data through the Ado.Net Microsoft SQL Server classes.
Inheritance HierarchyNamespace: XSharp.Data
Assembly: XSharp.Data (in XSharp.Data.dll) Version: 2.19
SyntaxThe SqlServerFactory type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | SqlServerFactory | Initializes a new instance of the SqlServerFactory class |
Properties| Name | Description | |
|---|---|---|
 | CanCreateDataSourceEnumerator | Does the factory support datasource enumeration. (Inherited from AbstractSqlFactory.) |
| Name | Return the name of the factory. (Overrides Name.) |
| ParameterNameInQuery | Should the parameter name be included in the query. Defaults to FALSE for ODBC and OLEDB and TRUE for SQLServer (Overrides ParameterNameInQuery.) |
| ParameterPrefix | Define the character with which parameters are prefixed in queries. For example '?' (ODBC, OLEDB) or '@' (SQLServer) (Overrides ParameterPrefix.) |
| QuoteChar | Return the quote character for table and column names. (Overrides QuoteChar.) |
Methods| Name | Description | |
|---|---|---|
| AfterCommit | This method is called after a transaction was committed. (Inherited from AbstractSqlFactory.) |
| AfterConnect | This method is called after a connection was opened. (Inherited from AbstractSqlFactory.) |
| AfterDisConnect | This method is called after a connection was disconnected. (Inherited from AbstractSqlFactory.) |
| AfterOpen | This method is called after a datareader was opened. (Inherited from AbstractSqlFactory.) |
| AfterRollBack | This method is called after a transaction was rolled back. (Inherited from AbstractSqlFactory.) |
| BeforeCommit | This method is called before a transaction is committed. (Inherited from AbstractSqlFactory.) |
| BeforeConnect | This method gets called before connecting. This allows to adjust the connection string. (Inherited from AbstractSqlFactory.) |
| BeforeDisConnect | This method is called before a connection is disconnected. (Inherited from AbstractSqlFactory.) |
| BeforeRollBack | This method is called before a transaction is rolled back. (Inherited from AbstractSqlFactory.) |
| CreateCommand | Returns a new instance of the provider's class that implements the DbCommand class. (Inherited from AbstractSqlFactory.) |
| CreateCommandBuilder | Returns a new instance of the provider's class that implements the DbCommandBuilder class. (Inherited from AbstractSqlFactory.) |
| CreateConnection | Returns a new instance of the provider's class that implements the DbConnection class. (Inherited from AbstractSqlFactory.) |
| CreateConnectionStringBuilder | Returns a new instance of the provider's class that implements the DbConnectionStringBuilder class. (Inherited from AbstractSqlFactory.) |
| CreateDataAdapter | Returns a new instance of the provider's class that implements the DbDataAdapter class. (Inherited from AbstractSqlFactory.) |
| CreateDataSourceEnumerator | Returns a new instance of the provider's class that implements the DbDataSourceEnumerator class. (Inherited from AbstractSqlFactory.) |
| CreateParameter | Returns a new instance of the provider's class that implements the DbParameter class. (Inherited from AbstractSqlFactory.) |
| DriverConnect | This method is called to show an interactive dialog to select a connection. (Overrides DriverConnect(IntPtr, Object, Object).) |
| EnhanceException | This method is called after a transaction was committed. (Inherited from AbstractSqlFactory.) |
| GetMetaDataColumnValues | Create an object array of column properties from the current datarow in the schema rowset (Overrides GetMetaDataColumnValues(DataRow).) |
| GetMetaDataTableValues | Create an object array of table properties from the current datarow in the schema rowset (Overrides GetMetaDataTableValues(DataRow).) |
| GetName | Return the name of the factory. (Overrides GetName(DbConnection).) |
| HandleSpecialValue | This method is called to translate result values for a column. (Inherited from AbstractSqlFactory.) |
| TranslateStatement | This method is called before a statement is sent to the server. (Inherited from AbstractSqlFactory.) |
See Also