public static IDatabase getDatabaseHelper(String databaseType
, AdoTemplate template
, string connectionString
, String databaseName
, string projectNamespace
, string projectFolder
, bool semaIsminiSorgulardaKullan
, bool semaIsminiDizinlerdeKullan
, bool dboSemaTablolariniAtla
, bool sysTablolariniAtla
)
{
IDatabase helper = null;
switch (databaseType)
{
case DatabaseType.SqlServer:
helper = new DatabaseSqlServer(template, connectionString, databaseName, projectNamespace, projectFolder, "System.Data.SqlClient", semaIsminiSorgulardaKullan, semaIsminiDizinlerdeKullan, sysTablolariniAtla, null);
break;
case DatabaseType.Oracle:
helper = new DatabaseOracle(template, connectionString, databaseName, projectNamespace, projectFolder, "System.Data.OracleClient", semaIsminiSorgulardaKullan, semaIsminiDizinlerdeKullan, sysTablolariniAtla, null);
break;
case DatabaseType.Sqlite:
helper = new DatabaseSqlite(template, connectionString, databaseName, projectNamespace, projectFolder, "System.Data.SQLite", semaIsminiSorgulardaKullan, semaIsminiDizinlerdeKullan, sysTablolariniAtla, null);
break;
}
return(helper);
}
private static DataTable executeQuery(string query)
{
DatabaseSqlite db = DatabaseSqlite.Instance;
db.openConnection();
var ret = db.executeQuery(query);
db.closeConnection();
return(ret);
}
private static int executeNonQuery(string query)
{
DatabaseSqlite db = DatabaseSqlite.Instance;
db.openConnection();
db.beginTransaction();
int ret = db.executeNonQuery(query);
db.commit();
db.closeConnection();
return(ret);
}
private void testSqlite(string connectionString)
{
Assembly assembly = Assembly.LoadWithPartialName("System.Data.SQLite");
Object objReflection = Activator.CreateInstance(assembly.FullName, "System.Data.SQLite.SQLiteConnection");
if (objReflection != null && objReflection is ObjectHandle)
{
ObjectHandle handle = (ObjectHandle)objReflection;
Object objConnection = handle.Unwrap();
connection = (DbConnection)objConnection;
connection.ConnectionString = connectionString;
connection.Open();
connection.Close();
template = new AdoTemplate();
template.Connection = connection;
template.DbProviderName = "System.Data.SQLite";
DatabaseHelper = new DatabaseSqlite(template);
}
}
