static void Main(string[] args)
{
var dbContext = new sakilaContext();
/*
* var records = dbContext.Film.Include(f => f.FilmActor).ThenInclude(r => r.Actor).ToList();
* foreach (var record in records)
* {
* Console.WriteLine($"Film: {record.Title}");
* var counter = 1;
* foreach (var fa in record.FilmActor)
* {
* Console.WriteLine($"\tActor {counter++}: {fa.Actor.FirstName} {fa.Actor.LastName}");
* }
* }
*
* var city = new City()
* {
* CityId = 1001, Name = "Redmond", CountryId = 103
* };
* dbContext.Add(city);
* dbContext.SaveChanges();
*/
var uTarget = dbContext.City.SingleOrDefault(c => c.CityId == 1001);
if (uTarget != null)
{
// uTarget.Name = "Kirkland";
// dbContext.Update(uTarget);
dbContext.Remove(uTarget);
dbContext.SaveChanges();
}
}
private void deleteCity()
{
using (var dbContext = new sakilaContext())
{
var city = dbContext.City.SingleOrDefault(x => x.CityId == 1001);
if (city != null)
{
dbContext.Remove(city);
dbContext.SaveChanges();
}
}
}
static void Main(string[] args)
{
// var dbContext = new sakilaContext();
// var actors = dbContext.Actor.ToList();
// foreach (var a in actors) {
// System.Console.WriteLine($"ID:{a.ActorId} Name:{a.FirstName} {a.LastName}");
// }
//reading joined tables
// var dbContext = new sakilaContext();
// var records = dbContext.Film.Include(f => f.FilmActor).ThenInclude(r => r.Actor).ToList();
// foreach (var record in records) {
// System.Console.WriteLine($"Film: {record.Title}");
// var counter = 1;
// foreach (var fa in record.FilmActor) {
// System.Console.WriteLine($"\tActor {counter++}: {fa.Actor.FirstName} {fa.Actor.LastName}");
// }
// }
//add a new city into the database
// var dbContext = new sakilaContext();
// var city = new City() { CityId = 1001, City1 = "Redmond", CountryId = 103 };
// dbContext.Add(city);
// dbContext.SaveChanges();
//update an existing record
// var dbContext = new sakilaContext();
// var uTarget = dbContext.City.SingleOrDefault(c => c.CityId == 1001);
// if (uTarget != null) {
// uTarget.City1 = "Kirkland"; // change Name to City1 if you did not update the City class file
// dbContext.Update(uTarget);
// dbContext.SaveChanges();
// }
//delete an existing record
var dbContext = new sakilaContext();
var dTarget = dbContext.City.SingleOrDefault(c => c.CityId == 1001);
if (dTarget != null)
{
dbContext.Remove(dTarget);
dbContext.SaveChanges();
}
}
static void Main(string[] args)
{
var dbContext = new sakilaContext();
// var actors = dbContext.Actor.ToList();
// foreach (var a in actors)
// {
// Console.WriteLine($"ID:{a.ActorId} First Name:{a.FirstName} Last Name: {a.LastName} Created on: {a.LastUpdate}");
// }
// var records = dbContext.Film.Include(f => f.FilmActor).ThenInclude(r => r.Actor).ToList();
// foreach (var record in records)
// {
// Console.WriteLine($"Film: {record.Title}");
// var counter = 1;
// foreach (var fa in record.FilmActor)
// {
// Console.WriteLine($"\tActor {counter++}: {fa.Actor.FirstName} {fa.Actor.LastName}");
// }
// }
// var city = new City() { CityId = 601, Name = "Redmond", CountryId = 103 };
// dbContext.Add(city);
// dbContext.SaveChanges();
// var uTarget = dbContext.City.SingleOrDefault(c => c.CityId == 601);
// if (uTarget != null)
// {
// uTarget.Name = "Kirkland"; // change Name to City1 if you did not update the City class file
// dbContext.Update(uTarget);
// dbContext.SaveChanges();
// }
var dTarget = dbContext.City.SingleOrDefault(c => c.CityId == 601);
if (dTarget != null)
{
dbContext.Remove(dTarget);
dbContext.SaveChanges();
}
}
public static void Main(string[] args)
{
CreateWebHostBuilder(args).Build().Run();
var dbContext = new sakilaContext();
// var records = dbContext.Film.Include(f => f.FilmActor).ThenInclude(r => r.Actor).ToList();
// foreach (var record in records)
// {
// System.Console.WriteLine($"Film: {record.Title}");
// var counter = 1;
// foreach (var fa in record.FilmActor)
// {
// System.Console.WriteLine($"\tActor {counter++}: {fa.Actor.FirstName} {fa.Actor.LastName}");
// }
// }
// var city = new City() { City1 = "Redmond", CountryId = 103 };
// dbContext.Add(city);
// dbContext.SaveChanges();
// var uTarget = dbContext.City.SingleOrDefault(c => c.CityId == 1001);
// if (uTarget != null)
// {
// uTarget.City1 = "Kirkland";
// dbContext.Update(uTarget);
// dbContext.SaveChanges();
// }
var dTarget = dbContext.City.SingleOrDefault(c => c.CityId == 1001);
if (dTarget != null)
{
dbContext.Remove(dTarget);
dbContext.SaveChanges();
}
}
