public static void UpdateEntity <T>(T entity) where T : class { using (var ctx = new MediaContext()) { ctx.Entry(entity).State = EntityState.Modified; ctx.SaveChanges(); } }
public static void DeleteBookByID(int id) { using (var ctx = new MediaContext()) { var bookToRemove = from x in ctx.Books where x.BookID == id select x; ctx.Books.Remove(bookToRemove.FirstOrDefault()); } }
public static void Insert <T>(T entity) where T : class { using (var ctx = new MediaContext()) { ctx.Set <T>().Add(entity); ctx.SaveChanges(); } }
public static void QueryPapers(MediaContext context) { Console.WriteLine("_____________Papers_____________"); foreach (var paper in context.Papers) { Console.WriteLine($"'{paper.Name}' - {paper.Author} ({paper.Type})"); } Console.WriteLine("___________________"); }
public static void RemoveEntity <T>(T entity) where T : class { using (var ctx = new MediaContext()) { DbSet <T> dbSet = ctx.Set <T>(); dbSet.Remove(entity); ctx.SaveChanges(); } }
public static void QueryBooks(MediaContext context) { Console.WriteLine("_____________Books_____________"); foreach (var book in context.Books) { Console.WriteLine($"'{book.Name}' - {book.Author} ({book.Genre}, {book.Pages})"); } Console.WriteLine("___________________"); }
public static Book GetBookByName(string name) { using (var ctx = new MediaContext()) { var result = from b in ctx.Books where b.BookName == name select b; return(result.First()); } }
public static List <T> GetAll <T>(T entity) where T : class { List <T> result = new List <T>(); using (var ctx = new MediaContext()) { DbSet <T> dbSet = ctx.Set <T>(); var entities = from x in dbSet select x; result.AddRange(entities); } return(result); }
public static void QueryMovies(MediaContext context) { Console.WriteLine("_____________Movies_____________"); foreach (var movie in context.Movies) { Console.WriteLine($"'{movie.Name}' - {movie.Director} ({movie.LengthMinutes})"); //foreach (KeyValuePair<string,string> kvp in movie.Top3Actors) //{ // Console.WriteLine(kvp.Key+" "+kvp.Value); //} } Console.WriteLine("___________________"); }
public static void InsertPaper(string author, string name, PaperType type) { var paper = new Paper() { Author = author, Type = type, Name = name, }; MediaContext context = new MediaContext(); context.Papers.Add(paper); context.SaveChanges(); }
public static void InsertBook(string author, string genre, string name, int pages) { var book = new Book() { Author = author, Genre = genre, Name = name, Pages = pages, }; MediaContext context = new MediaContext(); context.Books.Add(book); context.SaveChanges(); }
private static void RemoveMovies(string moviename) { //will remove all movies that matche the parameter name MediaContext context = new MediaContext(); IEnumerable <Movie> moviesToRemove = context.Movies.Where(m => m.Name == moviename); if (moviesToRemove.Count() == 0) { Console.WriteLine("Movie " + moviename + " not present in database"); } else { context.Movies.RemoveRange(moviesToRemove); context.SaveChanges(); } }
private static void RemovePaper(string papername) { //will only remove first instance of paper found that matches the parameter name MediaContext context = new MediaContext(); Paper paperToRemove = context.Papers.Where(p => p.Name == papername).FirstOrDefault(); if (paperToRemove == null) { Console.WriteLine("Paper " + papername + " not present in database"); } else { context.Papers.Remove(paperToRemove); context.SaveChanges(); } }
public static void InsertMovie(string director, string genre, string name, int lengthMinutes) { var movie = new Movie() { Director = director, Genre = genre, Name = name, LengthMinutes = lengthMinutes, //top3actors dictionary not supported by EF }; MediaContext context = new MediaContext(); context.Movies.Add(movie); context.SaveChanges(); }
private static void RemoveBooks(string bookname) { //will remove all books that matche the parameter name MediaContext context = new MediaContext(); IEnumerable <Book> booksToRemove = context.Books.Where(b => b.Name == bookname); if (booksToRemove.Count() == 0) { Console.WriteLine("Book " + bookname + " not present in database"); } else { Console.WriteLine("Book(s) with name " + bookname + " successfully removed"); context.Books.RemoveRange(booksToRemove); context.SaveChanges(); } }
static void Main(string[] args) { MediaContext mc = new MediaContext(); mc.Books.Add(new Book() { Name = "I am Ivan", Author = "ivan prgomet", Genre = "Drama", Pages = 560 }); mc.Movies.Add(new Movie() { Name = "Don't Breathe", Top3Actors = new Dictionary <string, string> { { "Stephen Lang", "The Blind Man" }, { "Jane Levy", "Rocky" }, { "Dylan Minnette", "Alex" }, } }); mc.Papers.Add(new Paper() { Type = PaperType.Essay, Author = "Ralph Waldo Emerson", Name = "Fate" }); //mc.SaveChanges(); //CRUD //InsertBook("authordemo", "action", "title", 999); //InsertMovie("ivano prgometo", "action", "some cool title", 120); //InsertPaper("ivan emeroson", "life", PaperType.Essay); //RemoveBooks("title"); //RemoveMovies("some cool title"); //RemovePaper("life"); QueryBooks(mc); QueryMovies(mc); QueryPapers(mc); }