Back to Devexpress

AccessConnectionProvider Members

xpo-devexpress-dot-xpo-dot-db-dot-accessconnectionprovider-dot-underscore-members.md

latest35.1 KB
Original Source

AccessConnectionProvider Members

Implements data-aware operations for working with Microsoft Access databases.

Constructors

NameDescription
AccessConnectionProvider(IDbConnection, AutoCreateOption)Initializes a new instance of the AccessConnectionProvider class with the specified settings.

Fields

NameDescription
DefaultCommandTimeoutSpecifies the timeout value passed to the IDbCommand.CommandTimeout property of each created command, in seconds. Inherited from ConnectionProviderSql.
EnableConnectionStringArgumentEscaping staticInherited from ConnectionProviderSql.
GlobalDefaultCommandTimeout staticSpecifies 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 staticSpecifies how connection providers initialize command parameters. Use the QueryParameterMode property to change this setting for a specific connection provider. Inherited from ConnectionProviderSql.
GlobalUseLegacyDateOnlyAndTimeOnlySupport staticInherited from ConnectionProviderSql.
GlobalUseLegacyUntypedParameters staticThis property is now obsolete. Use GlobalQueryParameterMode instead. Inherited from ConnectionProviderSql.
IdentityColumnMagicName staticInherited from ConnectionProviderSql.
MaxDeadLockRetryDelayMilliseconds staticInherited from ConnectionProviderSql.
MaxDeadLockTryCount staticInherited from ConnectionProviderSql.
MaximumStringSizeThis member supports the internal infrastructure and is not intended to be used directly from your code.
QueryParameterModeSpecifies how a connection provider initializes command parameters. Inherited from ConnectionProviderSql.
SortColumnsAlphabetically staticSpecifies how to order columns retrieved via the GetStorageTables and OleDBConnectionProvider.GetTableSchema methods. By default, this field is set to true , and the columns are listed alphabetically. If the field is set to false , the columns are returned as they appear in the database. Inherited from OleDBConnectionProvider.
UseLegacyTimeSpanSupport staticInherited from ConnectionProviderSql.
UseLegacyUntypedParametersThis property is now obsolete. Use QueryParameterMode instead. Inherited from ConnectionProviderSql.
XpoProviderTypeParameterName staticReturns a parameter name used to denote a provider type in a connection string. The default value is “XpoProvider”. Inherited from DataStoreBase.
XpoProviderTypeStringGets the name of the current connection provider. This name is used internally when generating a connection string via the AccessConnectionProvider.GetConnectionString method.

Properties

NameDescription
AutoCreateOptionReturns which operations are performed when a data store is accessed for the first time. Inherited from DataStoreBase.
BraceJoinInherited from ConnectionProviderSql.
CanCreateDatabaseInherited from ConnectionProviderSql.
CanCreateSchemaInherited from ConnectionProviderSql.
ConnectionInherited from ConnectionProviderSql.
ConnectionStringInherited from ConnectionProviderSql.
CustomAggregatesGets a collection of custom aggregate functions supplied by the current metadata provider. Inherited from ConnectionProviderSql.
CustomFunctionOperatorsInherited from ConnectionProviderSql.
Factories staticReturns registered provider factories. Inherited from DataStoreBase.
NativeOuterApplySupportedInherited from ConnectionProviderSql.
NativeSkipTakeSupportedInherited from ConnectionProviderSql.
SupportNamedParametersInherited from ConnectionProviderSql.
SyncRootObsolete. This API is obsolete now. Inherited from ConnectionProviderSql.
TransactionInherited from ConnectionProviderSql.

Methods

NameDescription
CollectTablesToCreate(ICollection)This method supports the internal infrastructure and is not intended to be called directly from your code. Inherited from OleDBConnectionProvider.
CompareSchema(IEnumerable<DBTable>, SchemaMigrationOptions)Inherited from ConnectionProviderSql.
ComposeSafeColumnName(String)Inherited from ConnectionProviderSql.
ComposeSafeConstraintName(String)Inherited from ConnectionProviderSql.
ComposeSafeSchemaName(String)Inherited from ConnectionProviderSql.
ComposeSafeTableName(String)Inherited from ConnectionProviderSql.
CreateColumn(DBTable, DBColumn)Inherited from ConnectionProviderSql.
CreateCommand()Inherited from ConnectionProviderSql.
CreateForeignKey(DBTable, DBForeignKey)Creates a foreign key.
CreateIndex(DBTable, DBIndex)Inherited from ConnectionProviderSql.
CreatePrimaryKey(DBTable)Inherited from ConnectionProviderSql.
CreateProviderFromConnection(IDbConnection, AutoCreateOption) staticThis method supports the internal infrastructure and is not intended to be called directly from your code.
CreateProviderFromString(String, AutoCreateOption, out IDisposable[]) staticThis method supports the internal infrastructure and is not intended to be called directly from your code.
CreateTable(DBTable)Inherited from ConnectionProviderSql.
Equals(Object, Object) staticDetermines 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) staticInherited 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)Inherited from ConnectionProviderSql.
FormatSelect(String, String, String, String, String, String, Int32)This member supports the internal infrastructure and is not intended to be used directly from your code.
FormatTable(String, String, String)This member supports the internal infrastructure and is not intended 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)Inherited from ConnectionProviderSql.
GenerateStoredProceduresInfoOnce()Inherited from ConnectionProviderSql.
GetColumnType(DbType, Boolean) staticInherited from ConnectionProviderSql.
GetConnectionString(String, String, String) staticReturns a connection string to the specified Microsoft Access database using the specified credentials.
GetConnectionString(String) staticReturns a connection string to the specified Microsoft Access data base using the default credentials.
GetConnectionStringACE(String, String) staticReturns a connection string to the specified Microsoft Access 2007 database using the default credentials.
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) staticInherited 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()Returns an array of stored procedures available within the data store.
GetTableSchema(DBTable, Boolean, Boolean)This member supports the internal infrastructure and is not intended to be used directly from your code. Inherited from OleDBConnectionProvider.
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() protectedCreates a shallow copy of the current Object. Inherited from Object.
MemberwiseClone(Boolean) protectedCreates a shallow copy of the current MarshalByRefObject object. Inherited from MarshalByRefObject.
ModifyData(ModificationStatement[])Inherited from ConnectionProviderSql.
ModifyDataAsync(CancellationToken, ModificationStatement[])Inherited from OleDBConnectionProvider.
QueryDataStore(IDbConnection, AutoCreateOption) staticCreates a data store based on specified settings. Inherited from DataStoreBase.
QueryDataStore(String, String, AutoCreateOption, out IDisposable[]) staticCreates a data store based on specified settings. Inherited from DataStoreBase.
ReferenceEquals(Object, Object) staticDetermines whether the specified Object instances are the same instance. Inherited from Object.
Register() staticRegisters 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) staticRegisters 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) staticRegisters a data store provider using a specified name and a procedure that establishes a connection for the provider. Inherited from DataStoreBase.
RegisterFactory(ProviderFactory) staticRegisters a specified data store provider factory. Inherited from DataStoreBase.
SelectData(SelectStatement[])Inherited from ConnectionProviderSql.
SelectDataAsync(CancellationToken, SelectStatement[])Inherited from OleDBConnectionProvider.
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 OleDBConnectionProvider.

Events

NameDescription
ReconnectedInherited from ConnectionProviderSql.

See Also

AccessConnectionProvider Class

DevExpress.Xpo.DB Namespace