ConnectionProviderSql Members

Implements the base functionality for SQL-based data store adapters, including the MSSqlConnectionProvider and other adapters listed in the Database Systems Supported by XPO topic.

Fields

Name	Description
DefaultCommandTimeout	Specifies the timeout value passed to the IDbCommand.CommandTimeout property of each created command, in seconds.
EnableConnectionStringArgumentEscaping static
GlobalDefaultCommandTimeout static	Specifies the timeout value passed to the IDbCommand.CommandTimeout property, in seconds. Can be overridden by the ConnectionProviderSql.DefaultCommandTimeout field. The default is 300.
GlobalQueryParameterMode static	Specifies how connection providers initialize command parameters. Use the QueryParameterMode property to change this setting for a specific connection provider.
GlobalUseLegacyDateOnlyAndTimeOnlySupport static
GlobalUseLegacyUntypedParameters static	This property is now obsolete. Use GlobalQueryParameterMode instead.
IdentityColumnMagicName
MaxDeadLockRetryDelayMilliseconds static
MaxDeadLockTryCount static
QueryParameterMode	Specifies how a connection provider initializes command parameters.
UseLegacyTimeSpanSupport static
UseLegacyUntypedParameters	This property is now obsolete. Use QueryParameterMode instead.
XpoProviderTypeParameterName static	Returns a parameter name used to denote a provider type in a connection string. The default value is “XpoProvider”. Inherited from DataStoreBase.

Properties

Name	Description
AutoCreateOption	Returns which operations are performed when a data store is accessed for the first time. Inherited from DataStoreBase.
BraceJoin
CanCreateDatabase
CanCreateSchema
Connection
ConnectionString
CustomAggregates	Gets a collection of custom aggregate functions supplied by the current metadata provider.
CustomFunctionOperators
Factories static	Returns registered provider factories. Inherited from DataStoreBase.
NativeOuterApplySupported
NativeSkipTakeSupported
SupportNamedParameters
SyncRoot	Obsolete. This API is obsolete now.
Transaction

Methods

Name	Description
CollectTablesToCreate(ICollection)
CompareSchema(IEnumerable<DBTable>, SchemaMigrationOptions)
ComposeSafeColumnName(String)
ComposeSafeConstraintName(String)
ComposeSafeSchemaName(String)
ComposeSafeTableName(String)
CreateColumn(DBTable, DBColumn)
CreateCommand()
CreateForeignKey(DBTable, DBForeignKey)
CreateIndex(DBTable, DBIndex)
CreateObjRef(Type)	Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. Inherited from MarshalByRefObject.
CreatePrimaryKey(DBTable)
CreateTable(DBTable)
Equals(Object, Object) static	Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object)	Determines whether the specified object is equal to the current object. Inherited from Object.
EscapeConnectionStringArgument(String) static
ExecSql(Query)
ExecSqlAsync(Query, AsyncOperationIdentifier, CancellationToken)
ExecuteUpdateSchemaStatements(IEnumerable<UpdateSchemaStatement>)
ExplicitBeginTransaction()
ExplicitBeginTransaction(IsolationLevel)
ExplicitCommitTransaction()
ExplicitRollbackTransaction()
FormatBinary(BinaryOperatorType, String, String)
FormatColumn(String, String)
FormatColumn(String)
FormatColumnSafe(String)
FormatConstraint(String)
FormatConstraintSafe(String)
FormatDelete(String, String)
FormatFunction(FunctionOperatorType, String[])
FormatFunction(ProcessParameter, FunctionOperatorType, Object[])
FormatInsert(String, String, String)
FormatInsertDefaultValues(String)
FormatOrder(String, SortingDirection)
FormatOuterApply(String, String)
FormatSelect(String, String, String, String, String, String, Int32, Int32)
FormatSelect(String, String, String, String, String, String, Int32)
FormatTable(String, String, String)
FormatTable(String, String)
FormatTableSafe(DBTable)
FormatUnary(UnaryOperatorType, String)
FormatUpdate(String, String, String)
FormatUpdateSchemaScript(IEnumerable<UpdateSchemaStatement>)
FormatUpdateSchemaStatements(IEnumerable<UpdateSchemaStatement>)
GenerateStoredProcedures(DBTable, out String)
GenerateStoredProceduresInfoOnce()
GetColumnType(DbType, Boolean) static
GetCustomAggregate(String)	Searches custom aggregate functions registered in an application via the RegisterCustomAggregate(ICustomAggregateFormattable) and RegisterCustomAggregates(ICollection<ICustomAggregateFormattable>) method calls for a function with the specified name.
GetCustomFunctionOperator(String)
GetDbType(DBColumnType) static
GetHashCode()	Serves as the default hash function. Inherited from Object.
GetLifetimeService()	Retrieves the current lifetime service object that controls the lifetime policy for this instance. Inherited from MarshalByRefObject.
GetParameterName(OperandValue, Int32, ref Boolean)
GetSqlCreateColumnFullAttributes(DBTable, DBColumn, Boolean)
GetSqlCreateColumnFullAttributes(DBTable, DBColumn)
GetStorageTables(String[])
GetStorageTablesList(Boolean)
GetStoredProcedures()
GetTableSchema(DBTable, Boolean, Boolean)
GetType()	Gets the Type of the current instance. Inherited from Object.
InitializeLifetimeService()	Obtains a lifetime service object to control the lifetime policy for this instance. Inherited from MarshalByRefObject.
MemberwiseClone() protected	Creates a shallow copy of the current Object. Inherited from Object.
MemberwiseClone(Boolean) protected	Creates a shallow copy of the current MarshalByRefObject object. Inherited from MarshalByRefObject.
ModifyData(ModificationStatement[])
ModifyDataAsync(CancellationToken, ModificationStatement[])
QueryDataStore(IDbConnection, AutoCreateOption) static	Creates a data store based on specified settings. Inherited from DataStoreBase.
QueryDataStore(String, String, AutoCreateOption, out IDisposable[]) static	Creates a data store based on specified settings. Inherited from DataStoreBase.
ReferenceEquals(Object, Object) static	Determines whether the specified Object instances are the same instance. Inherited from Object.
RegisterCustomAggregate(ICustomAggregateFormattable)	Registers a custom aggregate function to use in any CriteriaOperator-based criteria in your application.
RegisterCustomAggregates(ICollection<ICustomAggregateFormattable>)	Registers custom aggregate functions to use in any CriteriaOperator-based criteria in your application.
RegisterCustomFunctionOperator(ICustomFunctionOperatorFormattable)
RegisterCustomFunctionOperators(ICollection<ICustomFunctionOperatorFormattable>)
RegisterDataStoreProvider(String, DataStoreCreationFromConnectionDelegate) static	Registers a data store provider using a specified connection type name and a procedure that establishes a connection for the provider. Inherited from DataStoreBase.
RegisterDataStoreProvider(String, DataStoreCreationFromStringDelegate) static	Registers a data store provider using a specified name and a procedure that establishes a connection for the provider. Inherited from DataStoreBase.
RegisterFactory(ProviderFactory) static	Registers a specified data store provider factory. Inherited from DataStoreBase.
SelectData(SelectStatement[])
SelectDataAsync(CancellationToken, SelectStatement[])
ToString()	Returns a string that represents the current object. Inherited from Object.
UnregisterCustomAggregate(ICustomAggregateFormattable)	Unregisters a specified custom aggregate function from use in any ConnectionProviderSql-based connection provider in your application.
UnregisterCustomAggregate(String)	Unregisters a custom aggregate function with the specified name from use in any ConnectionProviderSql-based connection provider in your application.
UnregisterCustomFunctionOperator(ICustomFunctionOperatorFormattable)
UnregisterCustomFunctionOperator(String)
UpdateSchema(DBTable[])	Updates a data store’s schema according to specified settings. Inherited from DataStoreBase.
UpdateSchema(Boolean, DBTable[])
UpdateSchemaAsync(CancellationToken, Boolean, DBTable[])

Events

Name
Reconnected