protected override void CommonSetup(DbConnection connection, SqlDialectBase sqlDialect)
{
var config = DapperAsyncExtensions.Configure(typeof(AutoClassMapper <>), new List <Assembly>(), sqlDialect);
var sqlGenerator = new SqlGeneratorImpl(config);
Db = new AsyncDatabase(connection, sqlGenerator);
}
public void getDb(String dbName = null)
{
SqlDialectBase dialect = null;
if (String.IsNullOrEmpty(dbName))
{
dbname = ConfigFileTool.SAPGlobalSettings.GetCodeTemplateDb();
}
else
{
dbname = dbName;
}
if (string.IsNullOrEmpty(dbname))
{
throw new Exception("Con't get the db connection");
}
netlib = new netlib7(dbname);
connection = netlib.CreateConnection();
switch (netlib.ProviderType)
{
case netlib7.ProviderTypes.Oracle:
break;
case netlib7.ProviderTypes.SqlServer:
dialect = new SqlServerDialect();
break;
case netlib7.ProviderTypes.MsAccess:
dialect = new SqlCeDialect();
break;
case netlib7.ProviderTypes.MySql:
dialect = new MySqlDialect();
break;
case netlib7.ProviderTypes.PostgreSQL:
break;
case netlib7.ProviderTypes.OleDB:
dialect = new SqlCeDialect();
break;
case netlib7.ProviderTypes.SQLite:
dialect = new SqliteDialect();
break;
case netlib7.ProviderTypes.Unknown:
break;
default:
break;
}
var config = new DapperExtensionsConfiguration(typeof(AutoClassMapper <>), new List <Assembly>(), dialect);
var sqlGenerator = new SqlGeneratorImpl(config);
Db = new Database(connection, sqlGenerator);
}
private void InitDb(String dbName = "")
{
try
{
if (!String.IsNullOrEmpty(dbName))
{
m_dbname = dbName;
}
else
{
m_dbname = ConfigFileTool.SAPGlobalSettings.GetDefaultCodeManagerDb();
}
if (string.IsNullOrWhiteSpace(m_dbname))
{
throw new Exception("Can't get the dbName");
}
m_vdb = new SAPINTDB.netlib7(m_dbname);
connection = m_vdb.CreateConnection();
switch (m_vdb.ProviderType)
{
case netlib7.ProviderTypes.Oracle:
break;
case netlib7.ProviderTypes.SqlServer:
dialect = new SqlServerDialect();
break;
case netlib7.ProviderTypes.MsAccess:
dialect = new SqlCeDialect();
break;
case netlib7.ProviderTypes.MySql:
dialect = new MySqlDialect();
break;
case netlib7.ProviderTypes.PostgreSQL:
break;
case netlib7.ProviderTypes.OleDB:
dialect = new SqlCeDialect();
break;
case netlib7.ProviderTypes.SQLite:
dialect = new SqliteDialect();
break;
case netlib7.ProviderTypes.Unknown:
break;
default:
break;
}
var config = new DapperExtensionsConfiguration(typeof(AutoClassMapper <>), new List <Assembly>(), dialect);
var sqlGenerator = new SqlGeneratorImpl(config);
Db = new Database(connection, sqlGenerator);
}
catch (Exception)
{
throw;
}
}
