public DataTable getDbObjectList()
{
DataTable dt = new DataTable();
try
{
DbConnection cn = db2.CreateConnection();
cn.Open();
try
{
dt = cn.GetSchema();
}
catch
{
dt = null;
}
cn.Close();
}
catch (Exception)
{
throw;
// throw new Exception(exception.Message);
}
return(dt);
}
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);
}
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);
}
