private static void ListDatabases() { string connStr = ConnectionStringManager.MakeSQLClient("sql.vnesoft.com", "", false, "Va!dO!#!167892g", "H@#d@Tag#6"); var df = new DataFactory(DatabaseProvider.SqlClient, connStr); df.TestConnection(); var ddl = df.Database.GetDatabases(true); Console.WriteLine(ddl.Count); var tdl = df.Database.GetTables(); }
private static void Dump(string query, string file) { Console.WriteLine("doing " + file); var df = new DataFactory(DatabaseProvider.SqlClient, ConnectionStringManager.MakeSQLClient("la1db2-dev-vm.mscorp.com", "testDb", true, null, null)); df.TestConnection(); var dt = df.FillTable(query); using (var w = new StreamWriter(file, false, Encoding.ASCII)) { foreach (DataRow dr in dt.Rows) { w.WriteLine(dr["foo"].ToString()); } w.Flush(); w.Close(); } }