private static void RemoveMultipleRecords(BookPublisherEntities bp) { bp.Books.RemoveRange(from b in bp.Books where b.Title == "sdfd" select b); bp.SaveChanges(); }
private static void RemoveBookWhereIdIs1(BookPublisherEntities bp) { bp.Books.RemoveRange(from b in bp.Books where b.BookId == 1 select b); bp.SaveChanges(); }
private static void DeletePublisher() { using (BookPublisherEntities bp = new BookPublisherEntities()) { bp.Publishers.RemoveRange(from b in bp.Publishers where b.Name.Contains("Mihai") select b); bp.SaveChanges(); } }
private static void AllBooksWhereYearIs2017(BookPublisherEntities bp) { var booksWhereYearIs2017 = (from b in bp.Books //select * books where year = 2017 where b.Year == 2017 select b).ToList(); foreach (var elem in booksWhereYearIs2017) { Console.WriteLine($"{elem.BookId}, {elem.Title}, {elem.Price}"); } }
private static void SelectAllPublishers() { using (BookPublisherEntities bp = new BookPublisherEntities()) { var pun = from b in bp.Publishers select b; foreach (var elem in pun) { Console.WriteLine($"{elem.PublisherId}, {elem.Name}"); } } }
private static void AddPublisher() { using (BookPublisherEntities bp = new BookPublisherEntities()) { Publisher p1 = new Publisher() { PublisherId = 22, Name = "Samsung" }; bp.Publishers.Add(p1); bp.SaveChanges(); } }
private static void SelectPublisherWhereNameIsSamsung() { using (BookPublisherEntities bp = new BookPublisherEntities()) { var pub = (from p in bp.Publishers where p.Name.Contains("Sams") select p).ToList(); foreach (var elem in pub) { Console.WriteLine($"{elem.PublisherId},{elem.Name}"); } } }
private static void AddBook(BookPublisherEntities bp) { Book book1 = new Book() { Title = "Nemuritorul", PublisherId = 2, Year = 2015, Price = 10 }; bp.Books.Add(book1); bp.SaveChanges(); }
private static void Update() { using (BookPublisherEntities bp = new BookPublisherEntities()) { var update = bp.Books.SingleOrDefault(b => b.Title == "Fluturi"); if (update != null) { update.Price = 5; bp.SaveChanges(); } } }
public static void InsertBook(string title, Publisher publisherId, int year, decimal price) { Book book = new Book() { Title = title, PublisherId = publisherId.PublisherId, Year = year, Price = price, }; if (book != null) { using (BookPublisherEntities bp = new BookPublisherEntities()) { bp.Books.Add(book); bp.SaveChanges(); } } Console.WriteLine("Book has been added"); }
static void Main(string[] args) { BookPublisherEntities bp = new BookPublisherEntities(); bp.Books.Add(new Book() { BookId = 1, Title = "ds", PublisherId = 2, Year = 1991, Price = 12, }); bp.SaveChanges(); //AllBooksWhereYearIs2017(bp); //AddBook(bp); //RemoveMultipleRecords(bp); //RemoveBookWhereIdIs1(bp); //Update(); //SelectAllPublishers(); //DeletePublisher(); //AddPublisher(); //SelectPublisherWhereNameIsSamsung(); //Book.InsertBook("Cartea mea", new Publisher(2), 2001, 2); Console.ReadKey(); }