C# (CSharp) DbConnectionExtension.SafeChangeDatabase Examples

Example #1

File: PostgreSqlDbObjects.cs Project: janproch/datadmin

 public override DataTable LoadOverview(DbConnection conn, ObjectPath parpath)
 {
     DbConnectionExtension.SafeChangeDatabase(conn, parpath);
     return(DbConnectionExtension.LoadTableFromQuery(conn, SqlScripts.getsequences));
 }

Example #2

 public override DataTable LoadOverview(DbConnection conn, ObjectPath parpath)
 {
     DbConnectionExtension.SafeChangeDatabase(conn, parpath);
     return(DbConnectionExtension.LoadTableFromQuery(conn, "SHOW ENGINES"));
 }

Example #3

 public override DataTable LoadOverview(DbConnection conn, ObjectPath parpath)
 {
     DbConnectionExtension.SafeChangeDatabase(conn, parpath);
     return(DbConnectionExtension.LoadTableFromQuery(conn, "SHOW FUNCTION STATUS WHERE Db='" + parpath.DbName + "'"));
 }

Example #4

File: OracleDbObject.cs Project: janproch/datadmin

 public override DataTable LoadOverview(DbConnection conn, ObjectPath parpath)
 {
     DbConnectionExtension.SafeChangeDatabase(conn, parpath);
     return(DbConnectionExtension.LoadTableFromQuery(conn, "select * from USER_SEQUENCES"));
 }