public string ForeignKeys(string connectionString, string database, string fileName)
{
using (var conn = Connection(database,connectionString))
{
var tables = new DataBaseObjects (conn, new ITableFilter[] {}, new ITableFilter[] {});
using (FileStream fs = File.Open(fileName, FileMode.Create))
using (TextWriter txtWriter = new StreamWriter(fs)) {
txtWriter.Write (JsonConvert.SerializeObject (tables.ForeignKeys, Formatting.Indented));
txtWriter.Flush ();
}
}
return null;
}
public void Serialize(DbConnection conn)
{
var tables = new DataBaseObjects (conn, new ITableFilter[] {}, new ITableFilter[] {});
using (FileStream fs = File.Open(TablesFileName, FileMode.Create))
using (TextWriter txtWriter = new StreamWriter(fs)) {
txtWriter.Write (JsonConvert.SerializeObject (tables.Tables.Values, Formatting.Indented));
txtWriter.Flush ();
}
using (FileStream fs = File.Open(ForeignKeysFileName, FileMode.Create))
using (TextWriter txtWriter = new StreamWriter(fs)) {
txtWriter.Write (JsonConvert.SerializeObject (tables.ForeignKeys, Formatting.Indented));
txtWriter.Flush ();
}
}
public string TableCount(string connectionString, string database, string fileName)
{
using (var conn = Connection(database,connectionString))
{
var tables = new DataBaseObjects (conn, new ITableFilter[] {}, new ITableFilter[] {});
using (
FileStream fs =
File.Open(
fileName,
FileMode.Create))
using (TextWriter txtWriter = new StreamWriter(fs)) {
var tableCounts = from table in tables.Tables
let count = tables.GetTableCount (table.Key)
select new KeyValuePair<string, int> (table.Key, count);
// .GetProbableForeignKeys().Where(fk => !tables.ForeignKeys.Any(rfk => rfk.Equals(fk)));
txtWriter.Write (JsonConvert.SerializeObject (tableCounts, Formatting.Indented));
txtWriter.Flush ();
}
}
return null;
}
