xpo-devexpress-dot-xpo-dot-db-dot-mssqlconnectionprovider-dot-underscore-members.md
Implements data-aware operations for working with an Microsoft SQL Server or Microsoft SQL Azure database.
| Name | Description |
|---|---|
| MSSqlConnectionProvider(IDbConnection, AutoCreateOption) | Initializes a new instance of the MSSqlConnectionProvider class with the specified settings. |
| Name | Description |
|---|---|
| DefaultCommandTimeout | Specifies the timeout value passed to the IDbCommand.CommandTimeout property of each created command, in seconds. Inherited from ConnectionProviderSql. |
| EnableConnectionStringArgumentEscaping static | Inherited from ConnectionProviderSql. |
| 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. Inherited from ConnectionProviderSql. |
| GlobalQueryParameterMode static | Specifies how connection providers initialize command parameters. Use the QueryParameterMode property to change this setting for a specific connection provider. Inherited from ConnectionProviderSql. |
| GlobalUseLegacyDateOnlyAndTimeOnlySupport static | Inherited from ConnectionProviderSql. |
| GlobalUseLegacySqlClient static | Disables the smart discovery service that loads a data provider library. |
| GlobalUseLegacyUntypedParameters static | This property is now obsolete. Use GlobalQueryParameterMode instead. Inherited from ConnectionProviderSql. |
| IdentityColumnMagicName static | Inherited from ConnectionProviderSql. |
| IsNotForReplication static | Specifies whether or not the “NOT FOR REPLICATION” option is used in SQL statements that create constraints. |
| MaxDeadLockRetryDelayMilliseconds static | Inherited from ConnectionProviderSql. |
| MaxDeadLockTryCount static | Inherited from ConnectionProviderSql. |
| MaximumBinarySize | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| MaximumStringSize | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| ObjectsOwner | The default owner of the objects in the Microsoft SQL database. By default “dbo”. |
| QueryParameterMode | Specifies how a connection provider initializes command parameters. Inherited from ConnectionProviderSql. |
| UseLegacyTimeSpanSupport static | Inherited from ConnectionProviderSql. |
| UseLegacyUntypedParameters | This property is now obsolete. Use QueryParameterMode instead. Inherited from ConnectionProviderSql. |
| XpoProviderTypeParameterName static | Returns a parameter name used to denote a provider type in a connection string. The default value is “XpoProvider”. Inherited from DataStoreBase. |
| XpoProviderTypeString | Gets the name of the current connection provider. This name is used internally when generating a connection string via the MSSqlConnectionProvider.GetConnectionString method. |
| Name | Description |
|---|---|
| AutoCreateOption | Returns which operations are performed when a data store is accessed for the first time. Inherited from DataStoreBase. |
| BraceJoin | Inherited from ConnectionProviderSql. |
| CanCreateDatabase | Inherited from ConnectionProviderSql. |
| CanCreateSchema | Inherited from ConnectionProviderSql. |
| Connection | Inherited from ConnectionProviderSql. |
| ConnectionString | Inherited from ConnectionProviderSql. |
| CustomAggregates | Gets a collection of custom aggregate functions supplied by the current metadata provider. Inherited from ConnectionProviderSql. |
| CustomFunctionOperators | Inherited from ConnectionProviderSql. |
| Factories static | Returns registered provider factories. Inherited from DataStoreBase. |
| NativeOuterApplySupported | Indicates whether the connection provider supports the OUTER APPLY operators. |
| NativeSkipTakeSupported | Indicates whether the connection provider supports the SKIP and TAKE (TOP) operators. |
| SupportNamedParameters | Inherited from ConnectionProviderSql. |
| SyncRoot | Obsolete. This API is obsolete now. Inherited from ConnectionProviderSql. |
| Transaction | Inherited from ConnectionProviderSql. |
| Name | Description |
|---|---|
| ClearDatabase(IDbCommand) static | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| CollectTablesToCreate(ICollection) | This method supports the internal infrastructure and is not intended to be called directly from your code. |
| CompareSchema(IEnumerable<DBTable>, SchemaMigrationOptions) | Inherited from ConnectionProviderSql. |
| ComposeSafeColumnName(String) | Inherited from ConnectionProviderSql. |
| ComposeSafeConstraintName(String) | Inherited from ConnectionProviderSql. |
| ComposeSafeSchemaName(String) | Returns the valid schema name for the specified table’s name. |
| ComposeSafeTableName(String) | Inherited from ConnectionProviderSql. |
| CreateColumn(DBTable, DBColumn) | Inherited from ConnectionProviderSql. |
| CreateCommand() | Inherited from ConnectionProviderSql. |
| CreateConnection(String) static | For internal use. |
| CreateForeignKey(DBTable, DBForeignKey) | Inherited from ConnectionProviderSql. |
| CreateIndex(DBTable, DBIndex) | Inherited from ConnectionProviderSql. |
| CreatePrimaryKey(DBTable) | Inherited from ConnectionProviderSql. |
| CreateProviderFromConnection(IDbConnection, AutoCreateOption) static | This method supports the internal infrastructure and is not intended to be called directly from your code. |
| CreateProviderFromString(String, AutoCreateOption, out IDisposable[]) static | This method supports the internal infrastructure and is not intended to be called directly from your code. |
| CreateTable(DBTable) | Inherited from ConnectionProviderSql. |
| EmptyAllTablesInDatabase(IDbCommand) static | This method supports the internal infrastructure and is not intended to be used directly in your code. |
| 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 | Inherited from ConnectionProviderSql. |
| ExecSql(Query) | Inherited from ConnectionProviderSql. |
| ExecSqlAsync(Query, AsyncOperationIdentifier, CancellationToken) | Inherited from ConnectionProviderSql. |
| ExecuteUpdateSchemaStatements(IEnumerable<UpdateSchemaStatement>) | Inherited from ConnectionProviderSql. |
| ExplicitBeginTransaction() | Inherited from ConnectionProviderSql. |
| ExplicitBeginTransaction(IsolationLevel) | Inherited from ConnectionProviderSql. |
| ExplicitCommitTransaction() | Inherited from ConnectionProviderSql. |
| ExplicitRollbackTransaction() | Inherited from ConnectionProviderSql. |
| FormatBinary(BinaryOperatorType, String, String) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| FormatColumn(String, String) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| FormatColumn(String) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| FormatColumnSafe(String) | Inherited from ConnectionProviderSql. |
| FormatConstraint(String) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| FormatConstraintSafe(String) | Inherited from ConnectionProviderSql. |
| FormatDelete(String, String) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| FormatFunction(FunctionOperatorType, String[]) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| FormatFunction(ProcessParameter, FunctionOperatorType, Object[]) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| FormatInsert(String, String, String) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| FormatInsertDefaultValues(String) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| FormatOrder(String, SortingDirection) | Inherited from ConnectionProviderSql. |
| FormatOuterApply(String, String) | Inherited from ConnectionProviderSql. |
| FormatSelect(String, String, String, String, String, String, Int32, Int32) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| FormatSelect(String, String, String, String, String, String, Int32) | Inherited from ConnectionProviderSql. |
| FormatTable(String, String, String) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| FormatTable(String, String) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| FormatTableSafe(DBTable) | Inherited from ConnectionProviderSql. |
| FormatUnary(UnaryOperatorType, String) | Inherited from ConnectionProviderSql. |
| FormatUpdate(String, String, String) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| FormatUpdateSchemaScript(IEnumerable<UpdateSchemaStatement>) | Inherited from ConnectionProviderSql. |
| FormatUpdateSchemaStatements(IEnumerable<UpdateSchemaStatement>) | Inherited from ConnectionProviderSql. |
| GenerateStoredProcedures(DBTable, out String) | Generates DDL (Data Description Language) code for the Generating Persistent Classes wizard, when mapping persistent classes to Microsoft SQL Server database views with the help of INSTEAD-OF triggers and stored procedures. |
| GenerateStoredProceduresInfoOnce() | Inherited from ConnectionProviderSql. |
| GetColumnType(DbType, Boolean) static | Inherited from ConnectionProviderSql. |
| GetConnectionString(String, Int32, String, String, String) static | Returns a connection string used to open a specified Microsoft SQL database using provided login credentials. |
| GetConnectionString(String, Int32, String) static | Returns a connection string used to open a specified Microsoft SQL database using provided login credentials. |
| GetConnectionString(String, String, String, String) static | Returns a connection string used to open a specified Microsoft SQL database using provided login credentials. |
| GetConnectionString(String, String) static | Returns a connection string used to open a specified Microsoft SQL database using Windows Integrated Security. |
| GetConnectionString2005CacheRoot(String, String, String, String) static | Returns a connection string used to open a specified Microsoft SQL database using provided login credentials and to enable the SqlDependency feature. |
| GetConnectionString2005CacheRoot(String, String) static | Returns a connection string used to open a specified Microsoft SQL database using Windows Integrated Security and to enable the SqlDependency feature. |
| GetConnectionString2005WithCache(String, String, String, String) static | Returns a connection string used to open a specified Microsoft SQL database using provided login credentials and to enable the SqlDependency feature. |
| GetConnectionString2005WithCache(String, String) static | Returns a connection string used to open a specified Microsoft SQL database using Windows Integrated Security and to enable the SqlDependency feature. |
| GetConnectionStringWithAttach(String, String, Boolean) static | Returns a connection string to connect to a Microsoft SQL Server database by attaching a specified .mdf database file to a specific server using Windows Integrated Security. |
| GetConnectionStringWithAttach(String, String, String, String, Boolean) static | Returns a connection string to connect to a Microsoft SQL Server database by attaching a specified .mdf database file to a specific server using specified login credentials. |
| GetConnectionStringWithAttachForLocalDB(String, String, String) static | Returns the connection string to SQL Server 2012 Express LocalDB for the specified server, database and database file location. |
| GetConnectionStringWithoutIntegratedSecurity(String, String, String, String) static | |
| GetConnectionStringWithoutIntegratedSecurity(String, String, String) 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. Inherited from ConnectionProviderSql. |
| GetCustomFunctionOperator(String) | Inherited from ConnectionProviderSql. |
| GetDbType(DBColumnType) static | Inherited from ConnectionProviderSql. |
| 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) | This member supports the .NET Framework infrastructure and cannot be used directly from your code. |
| GetSqlCreateColumnFullAttributes(DBTable, DBColumn, Boolean) | |
| GetSqlCreateColumnFullAttributes(DBTable, DBColumn) | This method supports the internal infrastructure and is not intended to be used directly from your code. |
| GetStorageTables(String[]) | Inherited from ConnectionProviderSql. |
| GetStorageTablesList(Boolean) | Returns a list of the available tables in the data store. |
| GetStoredProcedures() | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| GetTableSchema(DBTable, Boolean, Boolean) | This member supports the internal infrastructure and is not intended to be used directly from your code. |
| 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[]) | Inherited from ConnectionProviderSql. |
| ModifyDataAsync(CancellationToken, ModificationStatement[]) | Inherited from ConnectionProviderSql. |
| 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. |
| Register() static | Registers the provider for use with XPO. |
| RegisterCustomAggregate(ICustomAggregateFormattable) | Registers a custom aggregate function to use in any CriteriaOperator-based criteria in your application. Inherited from ConnectionProviderSql. |
| RegisterCustomAggregates(ICollection<ICustomAggregateFormattable>) | Registers custom aggregate functions to use in any CriteriaOperator-based criteria in your application. Inherited from ConnectionProviderSql. |
| RegisterCustomFunctionOperator(ICustomFunctionOperatorFormattable) | Inherited from ConnectionProviderSql. |
| RegisterCustomFunctionOperators(ICollection<ICustomFunctionOperatorFormattable>) | Inherited from ConnectionProviderSql. |
| 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[]) | Inherited from ConnectionProviderSql. |
| SelectDataAsync(CancellationToken, SelectStatement[]) | Inherited from ConnectionProviderSql. |
| 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. Inherited from ConnectionProviderSql. |
| UnregisterCustomAggregate(String) | Unregisters a custom aggregate function with the specified name from use in any ConnectionProviderSql-based connection provider in your application. Inherited from ConnectionProviderSql. |
| UnregisterCustomFunctionOperator(ICustomFunctionOperatorFormattable) | Inherited from ConnectionProviderSql. |
| UnregisterCustomFunctionOperator(String) | Inherited from ConnectionProviderSql. |
| UpdateSchema(DBTable[]) | Updates a data store’s schema according to specified settings. Inherited from DataStoreBase. |
| UpdateSchema(Boolean, DBTable[]) | Inherited from ConnectionProviderSql. |
| UpdateSchemaAsync(CancellationToken, Boolean, DBTable[]) | Inherited from ConnectionProviderSql. |
| Name | Description |
|---|---|
| Reconnected | Inherited from ConnectionProviderSql. |
See Also