/// <summary>
/// Заполнить таблицу Toys
/// </summary>
/// <param name="model"></param>
private static void AddDataIntoToys(MyModel1 model)
{
model.Toys.Add(new Toys()
{
Toy_Id = 1,
Child_Id = 3,
Toy_Name = "Мяч",
Color = "Красный"
});
model.Toys.Add(new Toys()
{
Toy_Id = 2,
Child_Id = 1,
Toy_Name = "Слон",
Color = "Оранжевый"
});
model.Toys.Add(new Toys()
{
Toy_Id = 3,
Child_Id = 2,
Toy_Name = "Каракатица",
Color = "Розовый"
});
model.Toys.Add(new Toys()
{
Toy_Id = 4,
Child_Id = 3,
Toy_Name = "Попугай",
Color = "Зеленый"
});
}
static void Main(string[] args)
{
MyModel1 model = new MyModel1();
Database.SetInitializer(new DropCreateDatabaseAlways <MyModel1>());
// Заполняем таблички
AddDataIntoChildren(model);
AddDataIntoToys(model);
model.SaveChanges();
var childNames = model.Toys.Include(x => x.Children).ToList();
PrintItems(childNames.Select(x => x.Toy_Name).ToList());
var children = model.Children.Find(3);
Console.WriteLine($"Found child: {children.Child_Name}");
Console.ReadLine();
}
/// <summary>
/// Заполнить таблицу Children
/// </summary>
/// <param name="model"></param>
private static void AddDataIntoChildren(MyModel1 model)
{
model.Children.Add(new Children()
{
Child_Id = 1,
Child_Name = "Максим",
Child_Age = 9
});
model.Children.Add(new Children()
{
Child_Id = 2,
Child_Name = "Аня",
Child_Age = 5
});
model.Children.Add(new Children()
{
Child_Id = 3,
Child_Name = "Толик",
Child_Age = 3
});
}