public static void Main(string[] args) {
//OGen.Libraries.DataLayer.UnitTests.UT_DBConnection _unittest
// = new OGen.Libraries.DataLayer.UnitTests.UT_DBConnection();
//_unittest.TestFixtureSetUp();
//_unittest.UT_getBDs();
//_unittest.TestFixtureTearDown();
//return;
DBConnection _con = new DBConnection_PostgreSQL(
"Server=127.0.0.1;Port=5432;User ID=postgres;Password=passpub;Database=OGen-NTier_UTs;",
#if !NET_1_1
System.Configuration.ConfigurationManager.AppSettings["DBLogfile"]
#else
System.Configuration.ConfigurationSettings.AppSettings["DBLogfile"]
#endif
);
_con.Open();
_con.Transaction.Begin();
try {
#region _con.Execute_SQLQuery_returnDataTable(...);
DataTable _datatable = _con.Execute_SQLQuery_returnDataTable("select * from \"User\"");
for (int r = 0; r < _datatable.Rows.Count; r++) {
if (r == 0) {
for (int c = 0; c < _datatable.Columns.Count; c++) {
Console.Write("{0}\t", _datatable.Columns[c].Caption);
}
Console.WriteLine();
}
for (int c = 0; c < _datatable.Columns.Count; c++) {
Console.Write("{0}\t", _datatable.Rows[r][c]);
}
Console.WriteLine();
}
#endregion
#region ...; _con.getTables(); ...
string[] _dbs = _con.SchemaDatabases();
for (int d = 0; d < _dbs.Length; d++) {
Console.WriteLine("#{0}/{1} - {2}", d + 1, _dbs.Length, _dbs[d]);
}
DBTableField[] _fields;
DBTable[] _tables = _con.SchemaDatabaseTables();
for (int t = 0; t < _tables.Length; t++) {
Console.WriteLine(
"\t#{0}/{1} - {2}",
t + 1,
_tables.Length,
_tables[t].Name
);
_fields = _con.SchemaDatabaseTableFields(_tables[t].Name);
for (int f = 0; f < _fields.Length; f++) {
Console.WriteLine(
"\t\t#{0}/{1} - {2}",
f + 1,
_fields.Length,
_fields[f].Name
);
}
}
#endregion
_con.Transaction.Commit();
} catch (Exception _ex) {
Console.WriteLine(_ex.Message);
_con.Transaction.Rollback();
}
_con.Transaction.Terminate();
_con.Close();
//_con.Dispose();
Console.Write("Press any key to continue . . . ");
#if !NET_1_1
Console.ReadKey(true);
#else
Console.ReadLine();
#endif
}
