Skip to main content
BuyLog In
XPO (.NET ORM Library)
Search in…
Docs > API Reference > DevExpress.Xpo.DB > MSSqlConnectionProvider > Members
All docs
V23.2
.NET 6.0+
.NET ORM Library (XPO)
.NET Support
Getting Started
Product Information
Connect to a Data Store
Create a Data Model
Create-Read-Update-Delete (CRUD)
Query and Shape Data
Best Practices and Troubleshooting
Design-Time Features
Examples
Member Tables
API Reference
DevExpress.Xpo
DevExpress.Xpo.DB
AccessConnectionProvider
AccessConnectionProviderMultiUserThreadSafe
CachedDataStoreClient
CachedDataStoreClientAsync
CachedDataStoreClientAsyncBase<TContractType>
CachedDataStoreService
DataStoreClient
DataStoreClientAsync
DataStoreService
FirebirdConnectionProvider
ICachedDataStoreService
ICachedDataStoreServiceAsync
ICachedDataStoreWarpService
ICachedDataStoreWarpServiceAsync
IDataStoreService
IDataStoreServiceAsync
IDataStoreWarpService
IDataStoreWarpServiceAsync
InMemoryDataStore
ISerializableObjectLayerService
MSSqlConnectionProvider
Members
Constructors
Fields
Properties
Methods
Events
OleDBConnectionProvider
OperationResult
OperationResult<T>
PostgreSqlConnectionProvider
SerializableObjectLayerProxyBase
SerializableObjectLayerService
SerializableObjectLayerServiceClient
ServiceBase
ServiceExceptionEventArgs
WebApiDataStoreClient
WebApiDataStoreService
DevExpress.Xpo.DB.Helpers
DevExpress.Xpo.Exceptions
DevExpress.Xpo.Helpers
DevExpress.Xpo.Metadata
Microsoft.Extensions.DependencyInjection
Download CHM

MSSqlConnectionProvider Members

Implements data-aware operations for working with an Microsoft SQL Server or Microsoft SQL Azure database.

Constructors

Name Description
MSSqlConnectionProvider(IDbConnection, AutoCreateOption) Initializes a new instance of the MSSqlConnectionProvider class with the specified settings.

Fields

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.
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.

Properties

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.

Methods

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.
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.

Events

Name Description
Reconnected Inherited from ConnectionProviderSql.
See Also