public IDbContext ConnectionString(string connectionString, DbProviderTypes dbProviderType)
{
this.Data.ConnectionString = connectionString;
this.Data.ProviderType = dbProviderType;
this.Data.Provider = DbProviderFactory.GetDbProvider(dbProviderType);
return(this);
}
public virtual IDbProvider GetDbProvider(DbProviderTypes dbProvider)
{
IDbProvider provider = null;
DbProviderTypes types;
Label_008C:
types = dbProvider;
if (0x7fffffff != 0)
{
switch (types)
{
case DbProviderTypes.SqlServer:
case DbProviderTypes.SqlAzure:
return(new xb41ee2fa4b36daf9());
case DbProviderTypes.SqlServerCompact40:
return(new x5a504537ae2f4c91());
case DbProviderTypes.Oracle:
provider = new x82a2d569ac32b6b8();
if (0 != 0)
{
goto Label_008C;
}
return(provider);
case DbProviderTypes.MySql:
return(new xf31b6dba58427e49());
case DbProviderTypes.Access:
goto Label_001F;
case DbProviderTypes.Sqlite:
return(new x5fc4aec3fec9428d());
case DbProviderTypes.PostgreSql:
return(new xd77ea1a8e5e056c6());
case DbProviderTypes.DB2:
return(new x0c17e5843232952f());
}
return(provider);
}
if (0 != 0)
{
IDbProvider provider2;
return(provider2);
}
Label_001F:
provider = new x0048b3d0cfd2b5d3();
if (0 != 0)
{
goto Label_001F;
}
return(provider);
}
public static IDbProvider GetProvider(DbProviderTypes type, string connectionString)
{
IDbProvider provider = null;
if (type == DbProviderTypes.MsSql)
{
provider = new MsSqlDbProvider(connectionString);
}
return(provider);
}
public IDbContext ConnectionStringName(string connectionstringName, DbProviderTypes dbProviderType)
{
var settings = System.Configuration.ConfigurationManager.ConnectionStrings[connectionstringName];
if (settings == null || string.IsNullOrEmpty(settings.ConnectionString))
{
throw new DBClientException("A connectionstring with the specified name was not found in the .config file");
}
return(ConnectionString(settings.ConnectionString, dbProviderType));
}
public virtual IDbProvider GetDbProvider(DbProviderTypes dbProvider)
{
IDbProvider provider = null;
switch (dbProvider)
{
case DbProviderTypes.SqlServer:
case DbProviderTypes.SqlAzure:
provider = new SqlServerProvider();
break;
case DbProviderTypes.SqlServerCompact40:
provider = new SqlServerCompactProvider();
break;
case DbProviderTypes.Oracle:
provider = new OracleProvider();
break;
case DbProviderTypes.MySql:
provider = new MySqlProvider();
break;
case DbProviderTypes.Access:
provider = new AccessProvider();
break;
case DbProviderTypes.Sqlite:
provider = new Sqlite();
break;
case DbProviderTypes.PostgreSql:
provider = new PostgreSqlProvider();
break;
case DbProviderTypes.DB2:
provider = new DB2Provider();
break;
}
return(provider);
}
public static IDbProvider GetDbProvider(DbProviderTypes dbProvider)
{
IDbProvider provider = null;
switch (dbProvider)
{
case DbProviderTypes.SqlServer:
//case DbProviderTypes.SqlAzure:
provider = new SqlServerProvider();
break;
//case DbProviderTypes.SqlServerCompact40:
// provider = new SqlServerCompactProvider();
// break;
//case DbProviderTypes.Oracle:
// provider = new OracleProvider();
// break;
case DbProviderTypes.MySql:
provider = new MySqlProvider();
break;
//case DbProviderTypes.Access:
// provider = new AccessProvider();
// break;
//case DbProviderTypes.Sqlite:
// provider = new Sqlite();
// break;
//case DbProviderTypes.PostgreSql:
// provider = new PostgreSqlProvider();
// break;
//case DbProviderTypes.DB2:
// provider = new DB2Provider();
// break;
}
if (provider == null)
{
throw new DBClientException("DBProvider:" + dbProvider + " Not Supported.");
}
return(provider);
}
public IDbContext ConnectionStringName(string connectionstringName, DbProviderTypes dbProviderType)
{
this.xe6bfc0d601246e9e(this.xb470c845529d1dd5(connectionstringName), dbProviderType, new DbProviderFactory().GetDbProvider(dbProviderType));
return(this);
}
private void xe6bfc0d601246e9e(string x916ab12f6e6518fc, DbProviderTypes x6c4c7df1035313a9, IDbProvider x4088313242703400)
{
this.Data.ConnectionString = x916ab12f6e6518fc;
this.Data.ProviderType = x6c4c7df1035313a9;
this.Data.Provider = x4088313242703400;
}
public IDbContext ConnectionString(string connectionString, DbProviderTypes dbProviderType)
{
this.xe6bfc0d601246e9e(connectionString, dbProviderType, new DbProviderFactory().GetDbProvider(dbProviderType));
return(this);
}
public IDbContext ConnectionStringName(string connectionstringName, DbProviderTypes dbProviderType)
{
ConnectionStringInternal(GetConnectionStringFromConfig(connectionstringName), dbProviderType, new DbProviderFactory().GetDbProvider(dbProviderType));
return(this);
}
public IDbContext ConnectionString(string connectionString, DbProviderTypes dbProviderType)
{
ConnectionStringInternal(connectionString, dbProviderType, new DbProviderFactory().GetDbProvider(dbProviderType));
return(this);
}
private void ConnectionStringInternal(string connectionString, DbProviderTypes dbProviderType, IDbProvider dbProvider)
{
ContextData.ConnectionString = connectionString;
ContextData.ProviderType = dbProviderType;
ContextData.Provider = dbProvider;
}
public DbHelper(string connectionString, DbProviderTypes provider = DbProviderTypes.SqlServer)
{
_connectionString = connectionString;
_provider = provider;
}
