private static void DisplaySeededData(FootballDbContext context) { System.Console.WriteLine("Display seeded data."); foreach (var team in context.Set<Team>()) { System.Console.WriteLine("\t Team:"); System.Console.WriteLine("\t Id: {0}", team.Id); System.Console.WriteLine("\t Name: {0}", team.Name); System.Console.WriteLine(); System.Console.WriteLine("\t\t Stadion:"); System.Console.WriteLine("\t\t Name: {0}", team.Stadion.Name); System.Console.WriteLine("\t\t Street: {0}", team.Stadion.Street); System.Console.WriteLine("\t\t City: {0}", team.Stadion.City); System.Console.WriteLine(); foreach (var player in team.Players) { System.Console.WriteLine("\t\t Player:"); System.Console.WriteLine("\t\t Id: {0}", player.Id); System.Console.WriteLine("\t\t FirstName: {0}", player.FirstName); System.Console.WriteLine("\t\t LastName: {0}", player.LastName); System.Console.WriteLine("\t\t Street: {0}", player.Street); System.Console.WriteLine("\t\t City: {0}", player.City); System.Console.WriteLine(); } } }
private static FootballDbContext CreateAndSeedDatabase() { System.Console.WriteLine("Create and seed the database."); var context = new FootballDbContext(); System.Console.WriteLine("Completed."); System.Console.WriteLine(); return context; }
private static FootballDbContext CreateAndSeedDatabase() { System.Console.WriteLine("Create and seed the database."); var context = new FootballDbContext(); System.Console.WriteLine("Completed."); System.Console.WriteLine(); return(context); }
private static void StartDemoUseFile() { System.Console.WriteLine("Starting Demo Application (File)"); System.Console.WriteLine(string.Empty); using (var context = new FootballDbContext("footballDb")) { CreateAndSeedDatabase(context); DisplaySeededData(context); } }
private static void StartDemoUseInMemory() { System.Console.WriteLine("Starting Demo Application (In Memory)"); System.Console.WriteLine(string.Empty); using (var sqLiteConnection = new SQLiteConnection("data source=:memory:")) { // This is required if a in memory db is used. sqLiteConnection.Open(); using (var context = new FootballDbContext(sqLiteConnection, false)) { CreateAndSeedDatabase(context); DisplaySeededData(context); } } }
private static void DisplaySeededData(FootballDbContext context) { System.Console.WriteLine("Display seeded data."); foreach (var team in context.Set <Team>()) { System.Console.WriteLine("\t Team:"); System.Console.WriteLine("\t Id: {0}", team.Id); System.Console.WriteLine("\t Name: {0}", team.Name); System.Console.WriteLine(); System.Console.WriteLine("\t\t Stadion:"); System.Console.WriteLine("\t\t Name: {0}", team.Stadion.Name); System.Console.WriteLine("\t\t Street: {0}", team.Stadion.Street); System.Console.WriteLine("\t\t City: {0}", team.Stadion.City); System.Console.WriteLine(); System.Console.WriteLine("\t\t Coach:"); System.Console.WriteLine("\t\t Id: {0}", team.Coach.Id); System.Console.WriteLine("\t\t FirstName: {0}", team.Coach.FirstName); System.Console.WriteLine("\t\t LastName: {0}", team.Coach.LastName); System.Console.WriteLine("\t\t Street: {0}", team.Coach.Street); System.Console.WriteLine("\t\t City: {0}", team.Coach.City); System.Console.WriteLine(); foreach (var player in team.Players) { System.Console.WriteLine("\t\t Player:"); System.Console.WriteLine("\t\t Id: {0}", player.Id); System.Console.WriteLine("\t\t Number: {0}", player.Number); System.Console.WriteLine("\t\t FirstName: {0}", player.FirstName); System.Console.WriteLine("\t\t LastName: {0}", player.LastName); System.Console.WriteLine("\t\t Street: {0}", player.Street); System.Console.WriteLine("\t\t City: {0}", player.City); System.Console.WriteLine(); } } }