static void Main(string[] args)
{
using (var db = new ActorDBContext())
{
db.Actors.AddRange(new Actor {
Name = "Maurilio", Age = 35, AcademyWinner = false
},
new Actor {
Name = "Vanessa", Age = 32, AcademyWinner = true
});
var count = db.SaveChanges();
Console.WriteLine("{0} adocional register to database", count);
Console.WriteLine();
Console.WriteLine("All Actors in DB");
foreach (var Actor in db.Actors)
{
Console.WriteLine($"Bame = {Actor.Name}, \t\t" +
$"Age: {Actor.Age}, \t\t" +
$"Academy Winner: {Actor.AcademyWinner}");
}
}
}
static void Main(string[] args)
{
Console.WriteLine("EF Core Demo:\n");
using (var context = new ActorDBContext())
{
//Delete old data
context.Actors.Load();
context.Actors.Local.Clear();
context.Database.ExecuteSqlCommand("DBCC CHECKIDENT ('Actors', RESEED, 0);");
context.SaveChanges();
//Load initial data
context.Actors.AddRange(
new Actor()
{
Name = "Bruce Lee", Age = 35, AcademyWinner = false
},
new Actor()
{
Name = "Sharon Stone", Age = 21, AcademyWinner = false
},
new Actor()
{
Name = "Jack Nicolson", Age = 71, AcademyWinner = true
},
new Actor()
{
Name = "John Doe", Age = 27, AcademyWinner = true
},
new Actor()
{
Name = "Arnold Shwarzineger", Age = 65, AcademyWinner = false
},
new Actor()
{
Name = "James Baldwin", Age = 60, AcademyWinner = true
},
new Actor()
{
Name = "Jenifer Lopez", Age = 25, AcademyWinner = false
}
);
//Save the data
int count = context.SaveChanges();
//Fetch the data
Console.WriteLine($"{count} additional records added.\n");
ConsoleColor bg = Console.BackgroundColor;
ConsoleColor fg = Console.ForegroundColor;
Console.BackgroundColor = ConsoleColor.Blue;
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("--------------------------------------------");
Console.WriteLine(String.Format("| {0,-2} | {1,-20} | {2,10} |", "ID", "Name", "Award Winner"));
Console.WriteLine("--------------------------------------------");
Console.BackgroundColor = bg;
Console.ForegroundColor = fg;
context.Actors.Load();
var actors = context.Actors.Local.OrderBy((o) => o.Id).ToList();
actors.ForEach((a) => Console.WriteLine($"| {a.Id, -2} | {a.Name, -20} | {a.AcademyWinner, 12} |"));
Console.WriteLine("--------------------------------------------");
}
Console.ReadKey();
}