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