protected void InsertEmployeesBase()
{
var provider = GetIntProvider();
using (var cn = GetConnection())
{
DropTable(cn, "Organization");
provider.CreateTable <Organization>(cn);
DropTable(cn, "Employee");
provider.CreateTable <EmployeeInt>(cn);
var tdg = new TestDataGenerator();
tdg.Generate <Organization>(5, (record) =>
{
record.Name = tdg.Random(Source.UniqueWidget);
}, (records) =>
{
foreach (var record in records)
{
provider.Save(cn, record);
}
});
var orgIds = cn.Query <int>("SELECT Id FROM Organization").ToArray();
tdg.Generate <EmployeeInt>(100, (record) =>
{
record.OrganizationId = tdg.Random(orgIds);
record.FirstName = tdg.Random(Source.FirstName);
record.LastName = tdg.Random(Source.LastName);
record.Email = $"{record.FirstName}.{record.LastName}@nowhere.org";
}, (records) =>
{
foreach (var record in records)
{
provider.Save(cn, record);
}
});
}
}
private void InitItemTables()
{
using (var cn = GetConnection())
{
DropTable(cn, "Item");
DropTable(cn, "ItemType");
GetIntProvider().CreateTable <ItemType>(cn);
GetIntProvider().CreateTable <Item>(cn);
var tdg = new TestDataGenerator();
tdg.Generate <ItemType>(10, (it) =>
{
it.Name = tdg.Random(Source.WidgetName) + tdg.RandomInRange(100, 999).ToString();
}, (records) =>
{
foreach (var record in records)
{
GetIntProvider().Save(cn, record);
}
});
}
}