C# (CSharp) DbConnectionExtension.LoadTableFromQuery Examples

Example #1

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

Example #2

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 #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: EfzDbObject.cs Project: janproch/datadmin

 public override DataTable LoadOverview(DbConnection conn, ObjectPath parpath)
 {
     return(DbConnectionExtension.LoadTableFromQuery(conn, "SELECT * FROM INFORMATION_SCHEMA.TRIGGERS"));
 }

Example #5

File: MsSqlDbObject.cs Project: janproch/datadmin

 public override DataTable LoadOverview(DbConnection conn, ObjectPath parpath)
 {
     return(DbConnectionExtension.LoadTableFromQuery(conn, StdScripts.gettriggers));
 }

Example #6

File: OracleDbObject.cs Project: janproch/datadmin

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

Example #7

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