public static int RemoveSampleTables(CConfiguration configuration) { using (var connection = new SqlConnection(configuration.Datasource.First().ConnectionString)) { return(connection.Execute(configuration.Dataset.First().ToSchemaDropString())); } }
public static int CreateSampleTables(CConfiguration configuration) { using (var connection = new SqlConnection(configuration.Datasource.First().ConnectionString)) { var rows = connection.Execute(configuration.Dataset.First().ToSchemaString()); return(connection.Execute(configuration.Dataset.First().ToInsertString(3))); } }
public static DataTable ToDataTable(this CConfiguration configuration, int top = 100) { var table = new DataTable("configuration"); table.Columns.AddRange(new DataColumn[] { new DataColumn("name", typeof(string)), new DataColumn("tables", typeof(int)), new DataColumn("relations", typeof(int)), new DataColumn("queries", typeof(int)) }); foreach (var d in configuration.Dataset.Take(top)) { var row = table.NewRow(); row["name"] = d.name; row["tables"] = d.Table.Count; row["relations"] = d.Relationship.Count; row["queries"] = d.Query.Count; table.Rows.Add(row); } return(table); }