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;
}
