static void Main(string[] args)
{
MultiDbModelContainer mcontainer = new MultiDbModelContainer();
mcontainer.Database.Log = (log) => Console.WriteLine(log);
#region Insert data in table
//Member m1 = new Member { MemberName = "jeff" };
//Member m2 = new Member { MemberName = "sandy" };
//Member m3 = new Member { MemberName = "jiya" };
//Member m4 = new Member { MemberName = "reshma" };
//Game g1 = new Game { GameName = "cricket" };
//Game g2 = new Game { GameName = "football" };
//Game g3 = new Game { GameName = "soccer" };
//Game g4 = new Game { GameName = "chess" };
//m1.Games.Add(g1);
//m1.Games.Add(g2);
//m2.Games.Add(g2);
//m3.Games.Add(g3);
//m3.Games.Add(g4);
//m4.Games.Add(g4);
//mcontainer.Members.Add(m1);
//mcontainer.Members.Add(m2);
//mcontainer.Members.Add(m3);
//mcontainer.Members.Add(m4);
//int recEffected = mcontainer.SaveChanges();
//Console.WriteLine($"{recEffected} - Member and Games inserted.");
#endregion
#region MyRegion
//var result = (from m in mcontainer.Members
// select m);
foreach (var item in mcontainer.Members)
{
Console.WriteLine($"Name: {item.MemberName}");
foreach (var gg in item.Games)
{
Console.WriteLine($"\tGame:{gg.GameName}, Fess:{gg.Fees}");
}
}
#endregion
}
static void Main(string[] args)
{
MultiDbModelContainer mContainer = new MultiDbModelContainer();
mContainer.Database.Log = (log) => Console.WriteLine(log);
Member m1 = new Member {
MemberName = "D"
};
Member m2 = new Member {
MemberName = "Donald"
};
Member m3 = new Member {
MemberName = "M"
};
Member m4 = new Member {
MemberName = "Mickey"
};
Game g1 = new Game {
GameName = "Cricket", Fees = 900
};
Game g2 = new Game {
GameName = "Tennis", Fees = 2900
};
Game g3 = new Game {
GameName = "Football", Fees = 1900
};
Game g4 = new Game {
GameName = "BasketBall", Fees = 400
};
m1.Games.Add(g1);
m1.Games.Add(g2);
m2.Games.Add(g2);
m3.Games.Add(g3);
m3.Games.Add(g4);
m4.Games.Add(g4);
mContainer.Members.Add(m1);
mContainer.Members.Add(m2);
mContainer.Members.Add(m3);
mContainer.Members.Add(m4);
int recEffected = mContainer.SaveChanges();
Console.WriteLine($"{recEffected} - Members games Added...");
}