C# Class NLite.Data.DbConfiguration

ファイルを表示 Open project: netcasewqs/elinq Class Usage Examples

Public Methods

Method Description
BuildAccessConnectionString ( string databaseFile ) : string

构造Access连接字符串

BuildSQLExpressConnectionString ( string databaseFile ) : string

构造SQLExpress Connection String

BuildSQLiteConnectionString ( string databaseFile ) : string

构造SQLite连接字符串

BuildSQLiteConnectionString ( string databaseFile, bool failIfMissing ) : string

构造SQLite连接字符串

BuildSQLiteConnectionString ( string databaseFile, string password ) : string

构造SQLite连接字符串

BuildSQLiteConnectionString ( string databaseFile, string password, bool failIfMissing ) : string

构造SQLite连接字符串

BuildSqlCeConnectionString ( string databaseFile ) : string

构造SqlCe连接字符串

Configure ( ) : DbConfiguration

通过缺省的连接字串配置创建DbConfiguration对象(当且仅当配置文件中只有一个数据库连接字符串配置时才能使用)

Configure ( DbConnection conn ) : DbConfiguration

通过DbConnection对象创建DbConfiguration对象

Configure ( string connectionStringName ) : DbConfiguration

通过connectionStringName对象创建DbConfiguration对象(可以用于配置文件中有多个数据库连接字符串配置)

Configure ( string connectionString, string providerName ) : DbConfiguration

通过connectionString和providerName创建DbConfiguration对象

ConfigureAccess ( string databaseFile ) : DbConfiguration

配置Access

ConfigureMySQL ( string connectionString ) : DbConfiguration

配置MySQL

ConfigureOracle ( string connectionString ) : DbConfiguration

配置Oracle

ConfigureOracleODP ( string connectionString ) : DbConfiguration

配置Oracle ODP

ConfigureSQLExpress ( string databaseFile ) : DbConfiguration

配置SQLExpress

ConfigureSQLite ( string databaseFile ) : DbConfiguration

配置SQLite

ConfigureSQLite ( string databaseFile, bool failIfMissing ) : DbConfiguration

配置SQLite

ConfigureSQLite ( string databaseFile, string password ) : DbConfiguration

配置SQLite

ConfigureSQLite ( string databaseFile, string password, bool failIfMissing ) : DbConfiguration

配置SQLite

ConfigureSqlCe35 ( string databaseFile ) : DbConfiguration

配置SqlCe35

ConfigureSqlCe4 ( string databaseFile ) : DbConfiguration

配置SqlCe4

ConfigureSqlServer ( string connectionString ) : DbConfiguration

配置SqlServer

CreateDatabase ( ) : void

创建数据库

CreateDbConnection ( ) : DbConnection

创建DbConnection对象

CreateDbContext ( ) : IDbContext

创建DbContext(必须先注册实体到数据表的映射后才可创建DbContext)

CreateTables ( ) : void

创建数据表

DatabaseExists ( ) : bool

判断数据库是否存在

DeleteDatabase ( ) : void

删除数据库

GetProperty ( string name, string defaultValue ) : string

得到配置属性

MakeDefault ( ) : DbConfiguration

把当前DbConfiguration标志为缺省DbConfiguration

MakeEnableValidateSchema ( ) : DbConfiguration

Schema校验开关,调用该方法将打开,默认是关闭状态

SetProperty ( string name, string value ) : DbConfiguration

设置配置属性

SetSqlLogger ( Func logger ) : DbConfiguration

设置sql语句输出日志

Private Methods

Method Description
AutoMatchDialect ( DbConfiguration cfg, string connectionString, string providerName, DbProviderFactory factory ) : void
BuildAccessConnectionString ( string provider, string databaseFile ) : string
CheckDataDirectory ( string dataDirectory ) : string
CreateDbContext ( IDbContext ctx ) : IDbContext
DbConfiguration ( ) : System
DbConfiguration ( string providerName, string name, string connectionString, DbProviderFactory dbProviderFactory ) : System
Get ( string dbConfigurationName ) : DbConfiguration
GetDatabaseName ( ) : string
InitMsSql2000 ( DbConfiguration cfg ) : void
PopulateSqlServer2000 ( DbConfiguration cfg, DbProviderFactory factory ) : void
PopulateSqlServer2000 ( DbConnection conn, DbProviderFactory factory, DbConfiguration cfg ) : void
connection_StateChange ( object sender, StateChangeEventArgs e ) : void

Method Details

BuildAccessConnectionString() public static method

构造Access连接字符串
public static BuildAccessConnectionString ( string databaseFile ) : string
databaseFile string
return string

BuildSQLExpressConnectionString() public static method

构造SQLExpress Connection String
public static BuildSQLExpressConnectionString ( string databaseFile ) : string
databaseFile string
return string

BuildSQLiteConnectionString() public static method

构造SQLite连接字符串
public static BuildSQLiteConnectionString ( string databaseFile ) : string
databaseFile string
return string

BuildSQLiteConnectionString() public static method

构造SQLite连接字符串
public static BuildSQLiteConnectionString ( string databaseFile, bool failIfMissing ) : string
databaseFile string
failIfMissing bool
return string

BuildSQLiteConnectionString() public static method

构造SQLite连接字符串
public static BuildSQLiteConnectionString ( string databaseFile, string password ) : string
databaseFile string
password string
return string

BuildSQLiteConnectionString() public static method

构造SQLite连接字符串
public static BuildSQLiteConnectionString ( string databaseFile, string password, bool failIfMissing ) : string
databaseFile string
password string
failIfMissing bool
return string

BuildSqlCeConnectionString() public static method

构造SqlCe连接字符串
public static BuildSqlCeConnectionString ( string databaseFile ) : string
databaseFile string
return string

Configure() public static method

通过缺省的连接字串配置创建DbConfiguration对象(当且仅当配置文件中只有一个数据库连接字符串配置时才能使用)
public static Configure ( ) : DbConfiguration
return DbConfiguration

Configure() public static method

通过DbConnection对象创建DbConfiguration对象
public static Configure ( DbConnection conn ) : DbConfiguration
conn DbConnection
return DbConfiguration

Configure() public static method

通过connectionStringName对象创建DbConfiguration对象(可以用于配置文件中有多个数据库连接字符串配置)
public static Configure ( string connectionStringName ) : DbConfiguration
connectionStringName string
return DbConfiguration

Configure() public static method

通过connectionString和providerName创建DbConfiguration对象
public static Configure ( string connectionString, string providerName ) : DbConfiguration
connectionString string
providerName string
return DbConfiguration

ConfigureAccess() public static method

配置Access
public static ConfigureAccess ( string databaseFile ) : DbConfiguration
databaseFile string
return DbConfiguration

ConfigureMySQL() public static method

配置MySQL
public static ConfigureMySQL ( string connectionString ) : DbConfiguration
connectionString string
return DbConfiguration

ConfigureOracle() public static method

配置Oracle
public static ConfigureOracle ( string connectionString ) : DbConfiguration
connectionString string
return DbConfiguration

ConfigureOracleODP() public static method

配置Oracle ODP
public static ConfigureOracleODP ( string connectionString ) : DbConfiguration
connectionString string
return DbConfiguration

ConfigureSQLExpress() public static method

配置SQLExpress
public static ConfigureSQLExpress ( string databaseFile ) : DbConfiguration
databaseFile string
return DbConfiguration

ConfigureSQLite() public static method

配置SQLite
public static ConfigureSQLite ( string databaseFile ) : DbConfiguration
databaseFile string
return DbConfiguration

ConfigureSQLite() public static method

配置SQLite
public static ConfigureSQLite ( string databaseFile, bool failIfMissing ) : DbConfiguration
databaseFile string
failIfMissing bool
return DbConfiguration

ConfigureSQLite() public static method

配置SQLite
public static ConfigureSQLite ( string databaseFile, string password ) : DbConfiguration
databaseFile string
password string
return DbConfiguration

ConfigureSQLite() public static method

配置SQLite
public static ConfigureSQLite ( string databaseFile, string password, bool failIfMissing ) : DbConfiguration
databaseFile string
password string
failIfMissing bool
return DbConfiguration

ConfigureSqlCe35() public static method

配置SqlCe35
public static ConfigureSqlCe35 ( string databaseFile ) : DbConfiguration
databaseFile string
return DbConfiguration

ConfigureSqlCe4() public static method

配置SqlCe4
public static ConfigureSqlCe4 ( string databaseFile ) : DbConfiguration
databaseFile string
return DbConfiguration

ConfigureSqlServer() public static method

配置SqlServer
public static ConfigureSqlServer ( string connectionString ) : DbConfiguration
connectionString string
return DbConfiguration

CreateDatabase() public method

创建数据库
public CreateDatabase ( ) : void
return void

CreateDbConnection() public method

创建DbConnection对象
public CreateDbConnection ( ) : DbConnection
return DbConnection

CreateDbContext() public method

创建DbContext(必须先注册实体到数据表的映射后才可创建DbContext)
public CreateDbContext ( ) : IDbContext
return IDbContext

CreateTables() public method

创建数据表
public CreateTables ( ) : void
return void

DatabaseExists() public method

判断数据库是否存在
public DatabaseExists ( ) : bool
return bool

DeleteDatabase() public method

删除数据库
public DeleteDatabase ( ) : void
return void

GetProperty() public method

得到配置属性
public GetProperty ( string name, string defaultValue ) : string
name string
defaultValue string
return string

MakeDefault() public method

把当前DbConfiguration标志为缺省DbConfiguration
public MakeDefault ( ) : DbConfiguration
return DbConfiguration

MakeEnableValidateSchema() public method

Schema校验开关,调用该方法将打开,默认是关闭状态
public MakeEnableValidateSchema ( ) : DbConfiguration
return DbConfiguration

SetProperty() public method

设置配置属性
public SetProperty ( string name, string value ) : DbConfiguration
name string
value string
return DbConfiguration

SetSqlLogger() public method

设置sql语句输出日志
public SetSqlLogger ( Func logger ) : DbConfiguration
logger Func
return DbConfiguration