Table of Contents

Class AccessTools

Namespace
LinqToDB.DataProvider.Access
Assembly
linq2db.dll

Contains Access provider management tools.

public static class AccessTools
Inheritance
object
AccessTools

Properties

AutoDetectProvider 

public static bool AutoDetectProvider { get; set; }

Property Value

bool

Methods

CreateDataConnection(DbConnection, AccessVersion, AccessProvider) 

public static DataConnection CreateDataConnection(DbConnection connection, AccessVersion version = AccessVersion.AutoDetect, AccessProvider provider = AccessProvider.AutoDetect)

Parameters

connection DbConnection
version AccessVersion
provider AccessProvider

Returns

DataConnection

CreateDataConnection(DbTransaction, AccessVersion, AccessProvider) 

public static DataConnection CreateDataConnection(DbTransaction transaction, AccessVersion version = AccessVersion.AutoDetect, AccessProvider provider = AccessProvider.AutoDetect)

Parameters

transaction DbTransaction
version AccessVersion
provider AccessProvider

Returns

DataConnection

CreateDataConnection(string, AccessVersion, AccessProvider) 

public static DataConnection CreateDataConnection(string connectionString, AccessVersion version = AccessVersion.AutoDetect, AccessProvider provider = AccessProvider.AutoDetect)

Parameters

connectionString string
version AccessVersion
provider AccessProvider

Returns

DataConnection

CreateDatabase(string, bool, AccessVersion)

Creates new Access database file. Requires Access OLE DB provider (JET or ACE) and ADOX.

public static void CreateDatabase(string databaseName, bool deleteIfExists = false, AccessVersion version = AccessVersion.Ace)

Parameters

databaseName string

Name of database to create.

deleteIfExists bool

If true, existing database will be removed before create.

version AccessVersion

Access engine to use to create database. Default value: Ace.

DropDatabase(string, string?)

Removes database file by database name.

public static void DropDatabase(string databaseName, string? extension = null)

Parameters

databaseName string

Name of database to remove.

extension string

GetDataProvider(AccessVersion, AccessProvider, string?, DbConnection?, DbTransaction?)

Returns instance of Access database provider.

public static IDataProvider GetDataProvider(AccessVersion version = AccessVersion.AutoDetect, AccessProvider provider = AccessProvider.AutoDetect, string? connectionString = null, DbConnection? connection = null, DbTransaction? transaction = null)

Parameters

version AccessVersion
provider AccessProvider
connectionString string
connection DbConnection
transaction DbTransaction

Returns

IDataProvider