Skip to main content
A newer version of this page is available. .

AccessConnectionProvider Members

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

Constructors

Name Description
AccessConnectionProvider(IDbConnection, AutoCreateOption) Initializes a new instance of the AccessConnectionProvider 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.
IdentityColumnMagicName static Inherited from ConnectionProviderSql.
MaxDeadLockRetryDelayMilliseconds static Inherited from ConnectionProviderSql.
MaxDeadLockTryCount static Inherited from ConnectionProviderSql.
MaximumStringSize This member supports the internal infrastructure and is not intended to be used directly from your code.
SortColumnsAlphabetically static Specifies 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 static 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 AccessConnectionProvider.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.
CustomFunctionOperators Inherited from ConnectionProviderSql.
Factories static Returns registered provider factories. Inherited from DataStoreBase.
NativeOuterApplySupported Inherited from ConnectionProviderSql.
NativeSkipTakeSupported Inherited from ConnectionProviderSql.
SupportNamedParameters Inherited from ConnectionProviderSql.
SyncRoot Inherited from ConnectionProviderSql.
Transaction Inherited from ConnectionProviderSql.

Methods

Name Description
CollectTablesToCreate(ICollection) This method supports the internal infrastructure and is not intended to be called directly from your code. Inherited from OleDBConnectionProvider.
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.
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) 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.
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.
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.
GenerateStoredProcedures(DBTable, out String) Inherited from ConnectionProviderSql.
GenerateStoredProceduresInfoOnce() Inherited from ConnectionProviderSql.
GetColumnType(DbType, Boolean) static Inherited from ConnectionProviderSql.
GetConnectionString(String, String, String) static Returns a connection string to the specified MS Access database using the specified credentials.
GetConnectionString(String) static Returns a connection string to the specified MS Access data base using the default credentials.
GetConnectionStringACE(String, String) static Returns a connection string to the specified MS Access 2007 database using the default credentials.
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() 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() 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.
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.
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.
ToString() Returns a string that represents the current object. Inherited from Object.
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.

Events

Name Description
Reconnected Inherited from ConnectionProviderSql.
See Also