public void Setup()
{
Dialect = new SqlServerDialect();
}
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);
}