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); } }