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