MSSqlConnectionProvider Methods

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

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.