Click or drag to resize

SqlServerFactory Class

X#
This is the class that implements a Factory to access data through the Ado.Net Microsoft SQL Server classes.
Inheritance Hierarchy
Object
  AbstractSqlFactory
    SqlServerFactory

Namespace:  XSharp.Data
Assembly:  XSharp.Data (in XSharp.Data.dll) Version: 2.19
Syntax
 CLASS SqlServerFactory INHERIT AbstractSqlFactory
Request Example View Source

The SqlServerFactory type exposes the following members.

Constructors
  NameDescription
Public methodSqlServerFactory
Initializes a new instance of the SqlServerFactory class
Top
Properties
  NameDescription
Public propertyCanCreateDataSourceEnumerator
Does the factory support datasource enumeration.
(Inherited from AbstractSqlFactory.)
Public propertyName
Return the name of the factory.
(Overrides Name.)
Public propertyParameterNameInQuery
Should the parameter name be included in the query. Defaults to FALSE for ODBC and OLEDB and TRUE for SQLServer
(Overrides ParameterNameInQuery.)
Public propertyParameterPrefix
Define the character with which parameters are prefixed in queries. For example '?' (ODBC, OLEDB) or '@' (SQLServer)
(Overrides ParameterPrefix.)
Public propertyQuoteChar
Return the quote character for table and column names.
(Overrides QuoteChar.)
Top
Methods
  NameDescription
Public methodAfterCommit
This method is called after a transaction was committed.
(Inherited from AbstractSqlFactory.)
Public methodAfterConnect
This method is called after a connection was opened.
(Inherited from AbstractSqlFactory.)
Public methodAfterDisConnect
This method is called after a connection was disconnected.
(Inherited from AbstractSqlFactory.)
Public methodAfterOpen
This method is called after a datareader was opened.
(Inherited from AbstractSqlFactory.)
Public methodAfterRollBack
This method is called after a transaction was rolled back.
(Inherited from AbstractSqlFactory.)
Public methodBeforeCommit
This method is called before a transaction is committed.
(Inherited from AbstractSqlFactory.)
Public methodBeforeConnect
This method gets called before connecting. This allows to adjust the connection string.
(Inherited from AbstractSqlFactory.)
Public methodBeforeDisConnect
This method is called before a connection is disconnected.
(Inherited from AbstractSqlFactory.)
Public methodBeforeRollBack
This method is called before a transaction is rolled back.
(Inherited from AbstractSqlFactory.)
Public methodCreateCommand
Returns a new instance of the provider's class that implements the DbCommand class.
(Inherited from AbstractSqlFactory.)
Public methodCreateCommandBuilder
Returns a new instance of the provider's class that implements the DbCommandBuilder class.
(Inherited from AbstractSqlFactory.)
Public methodCreateConnection
Returns a new instance of the provider's class that implements the DbConnection class.
(Inherited from AbstractSqlFactory.)
Public methodCreateConnectionStringBuilder
Returns a new instance of the provider's class that implements the DbConnectionStringBuilder class.
(Inherited from AbstractSqlFactory.)
Public methodCreateDataAdapter
Returns a new instance of the provider's class that implements the DbDataAdapter class.
(Inherited from AbstractSqlFactory.)
Public methodCreateDataSourceEnumerator
Returns a new instance of the provider's class that implements the DbDataSourceEnumerator class.
(Inherited from AbstractSqlFactory.)
Public methodCreateParameter
Returns a new instance of the provider's class that implements the DbParameter class.
(Inherited from AbstractSqlFactory.)
Public methodDriverConnect
This method is called to show an interactive dialog to select a connection.
(Overrides DriverConnect(IntPtr, Object, Object).)
Public methodEnhanceException
This method is called after a transaction was committed.
(Inherited from AbstractSqlFactory.)
Public methodGetMetaDataColumnValues
Create an object array of column properties from the current datarow in the schema rowset
(Overrides GetMetaDataColumnValues(DataRow).)
Public methodGetMetaDataTableValues
Create an object array of table properties from the current datarow in the schema rowset
(Overrides GetMetaDataTableValues(DataRow).)
Public methodGetName
Return the name of the factory.
(Overrides GetName(DbConnection).)
Public methodHandleSpecialValue
This method is called to translate result values for a column.
(Inherited from AbstractSqlFactory.)
Public methodTranslateStatement
This method is called before a statement is sent to the server.
(Inherited from AbstractSqlFactory.)
Top
See Also