static void Main(string[] args) { using (var db = new ActorDbContext()) { db.Actors.AddRange( new Actor() { Name = "Vikas", Age = 26, AcademyWinner = true }, new Actor() { Name = "Vishal", Age = 22, AcademyWinner = true }, new Actor() { Name = "Vivek", Age = 20, AcademyWinner = true }); var count = db.SaveChanges(); //Fetch data and write it out Console.WriteLine($"{count} record added sucessfully"); foreach (var actor in db.Actors) { Console.WriteLine($"Name : {actor.Name}, \t\t" + $"Age : {actor.Age}, \t\t" + $"AcadenyWinner {actor.AcademyWinner}"); } Console.ReadLine(); } }
public static void Main(string[] args) { using (var db = new ActorDbContext()) { // Seed db.Actors.AddRange( new Actor { Name = "Bruce Lee", Age = 75, AcademyWinner = false }, new Actor { Name = "Madonna", Age = 55, AcademyWinner = true }); var count = db.SaveChanges(); // Fetch data & write it out Console.WriteLine($"{count} records added"); foreach (var Actor in db.Actors) { Console.WriteLine($"Name - {Actor.Name},\t\t" + $"Age: {Actor.Age},\t\t" + $"Academy Winner: {Actor.AcademyWinner}"); } Console.ReadLine(); } }
public static void Main(string[] args) { using (var db = new ActorDbContext()) { // Seed db.Actors.AddRange(new Actor { Name = "Bruce Lee", Age = 77, AcademyWinner = false }, new Actor { Name = "Alec Baldwin", Age = 55, AcademyWinner = false }); var count = db.SaveChanges(); // Fetch & Write out data Console.WriteLine("{0} additional records saved to database", count); Console.WriteLine(); Console.WriteLine("All Actors now in database:"); foreach (var Actor in db.Actors) { Console.WriteLine($"Name - {Actor.Name},\t\t" + $"Age: {Actor.Age},\t\t" + $"Academy Winner: {Actor.AcademyWinner}"); } Console.ReadLine(); } }
static void Main(string[] args) { //Seed using (var db = new ActorDbContext()) { if (!db.Actors.Any()) { //DB has been seeded ??? db.AddRange(new Actor { Name = "Manoel Jr", Age = 49, AcademyWinner = false }, new Actor { Name = "Manoel Pedro", Age = 48, AcademyWinner = true }, new Actor { Name = "Carlos Augusto", Age = 50, AcademyWinner = false }); var count = db.SaveChanges(); Console.WriteLine($"{count} - Records added"); } foreach (var actor in db.Actors) { Console.WriteLine($"Name - {actor.Name},\t\t" + $"Age - {actor.Age},\t\t" + $"Academy winner - {actor.AcademyWinner}"); } } Console.ReadKey(); }
public static void Main(string[] args) { using (var db = new ActorDbContext()) { Console.WriteLine($"Type mapper in use: "); Console.WriteLine($"Mapping for bool: "); Console.WriteLine($"Mapping for string: "); Console.ReadLine(); } }
static void Main(string[] args) { using (var db = new ActorDbContext()) { db.Actors.AddRange( new Actor { Name = "Ewan McGregor", Age = 45, AcademyWinner = false }, new Actor { Name = "Kelly MacDonald", Age = 41, AcademyWinner = false }, new Actor { Name = "Ewan Bremmer", Age = 47, AcademyWinner = false }, new Actor { Name = "Johnny Lee Miller", Age = 44, AcademyWinner = false } ); var count = db.SaveChanges(); Console.WriteLine($"{ count } records were added"); foreach (var actor in db.Actors) { Console.WriteLine($"Name: { actor.Name }"); Console.WriteLine($"Age: { actor.Age }"); if (actor.AcademyWinner) { Console.WriteLine("Academy award winner"); } else { Console.WriteLine("Not an academy award winner"); } } Console.ReadLine(); } }
public static void Main(string[] args) { using (var db = new ActorDbContext()) { var sp = db.GetInfrastructure <IServiceProvider>(); var mapper = sp.GetService <IRelationalTypeMapper>(); Console.WriteLine($"Type mapper in use: {mapper.GetType().Name} "); Console.WriteLine($"Mapping for bool: { mapper.GetMapping(typeof(bool)).StoreType}"); Console.WriteLine($"Mapping for string:{ mapper.GetMapping(typeof(string)).StoreType}"); Console.ReadLine(); } }
static void Main(string[] args) { using (var context = new ActorDbContext()) { context.Database.EnsureDeleted(); context.Database.Migrate(); var movie = context.Movies.FirstOrDefault(m => m.Title.Contains("Fiction")); movie.Title = "Criminalnoe Chtivo"; var newAwardList = new Award[] { new Award { Title = AwardType.Oscar, DeliveryYear = 2017 }, new Award { Title = AwardType.Oscar, DeliveryYear = 2016 } }; var newActor = new Actor { Name = "Tom Cruz", Age = 44, Awards = newAwardList }; newActor.ActorMovies = new List <ActorMovie> { new ActorMovie { Actor = newActor, Movie = movie } }; context.Actors.Add(newActor); context.SaveChanges(); context.Actors.Remove(context.Actors.FirstOrDefault(a => a.Name == "Tom Cruz")); context.SaveChanges(); } }
internal static void SeedData(ActorDbContext db) { // Seed db.Actors.AddRange(new Actor { Name = "Bruce Lee", Age = 75, AcademyWinner = false }, new Actor { Name = "Madonna", Age = 55, AcademyWinner = true }); }
static void Main(string[] args) { using (var db = new ActorDbContext()) { if (!db.Actors.Where(c => c.Name.Equals("Bruce Lee", StringComparison.InvariantCultureIgnoreCase)).Any() && !db.Actors.Where(c => c.Name.Equals("Madonna", StringComparison.InvariantCultureIgnoreCase)).Any()) { Program.SeedData(db); } var count = db.SaveChanges(); // Fetch data & write it out Console.WriteLine($"{count} records added"); foreach (var Actor in db.Actors) { Console.WriteLine($"Name - {Actor.Name},\t" + $"Age: {Actor.Age},\t" + $"Academy Winner: {Actor.AcademyWinner}"); } Console.ReadLine(); } }
static void Main(string[] args) { Console.WriteLine("Hello World!"); // Seed the database (generate entries) using (var db = new ActorDbContext()) { // Seed db.Actors.AddRange( new Actor { Name = "Bruce Lee", Age = 75, AcademyWinner = false }, new Actor { Name = "Madonna", Age = 55, AcademyWinner = true }); // Apply changes to the database int count = db.SaveChanges(); // Fetch data & write it out Console.WriteLine($"{count} records added"); foreach (var Actor in db.Actors) { Console.WriteLine($"Id={Actor.Id}, Name={Actor.Name}, Age={Actor.Age}, " + $"AcademWinner={Actor.AcademyWinner}"); } } Console.ReadLine(); }
public ActorsController() { _context = ActorDbContextFactory.Create("Server=ZHENIA-LAPTOP;Database=Sakila;Trusted_Connection=True;"); }
public ActorController(ActorDbContext context) { this._context = context; }
public ActorRepository(ActorDbContext context) { _context = context; }
public ActorMovie(ActorDbContext context) { _context = context; }
public ActorsController(ActorDbContext context) { _context = context; }
public ActorController(ActorDbContext dbContext) { _dbContext = dbContext; }
public ActorsController(ActorDbContext context, ILogger <ActorsController> logger) { _context = context; _logger = logger; }
public ActorsController(ActorDbContext context) { // Provided by Dependency Injection _context = context; }