static void Find() { Console.WriteLine("Enter the name of the book to find in DB: "); string input = Console.ReadLine(); using (var db = new BookAppDBEntities()) { var newBook = new BookTable() { // var input = Console.ReadLine(); Id = Guid.NewGuid(), Name = input }; // var b = db.BookTables.Where(x => x.Name == input).FirstOrDefault(); //var b = db.BookTables // .Select(x => x.Name == input).FirstOrDefault(); //Console.WriteLine($"{b}"); // db.SaveChanges(); var book = db.BookTables.SingleOrDefault(p => p.Name == input); //Console.WriteLine("{0} was found.", book.Name); Console.WriteLine("{0} was found."); } }
static void Update() { //Console.WriteLine("Nothing"); Console.WriteLine("What book do you want to update: "); string oldName = Console.ReadLine(); using (var db = new BookAppDBEntities()) { var book = db.BookTables .Where(x => x.Name == oldName).FirstOrDefault(); db.BookTables.Remove(book); db.SaveChanges(); Console.WriteLine("Enter the new name: "); string newName = Console.ReadLine(); if (book != null) { var newBook = new BookTable() { // var input = Console.ReadLine(); Id = Guid.NewGuid(), Name = newName }; db.BookTables.Add(newBook); db.SaveChanges(); Console.WriteLine($"{newName} was being updated."); } // Console.WriteLine($"{newName} was being updated."); } }
static void Main(string[] args) { //Console.WriteLine("Enter a book name: "); using (var db = new BookAppDBEntities()) { var b1 = new BookTable() { Id = Guid.NewGuid(), Name = "Cplusplus" }; var b2 = new BookTable() { Id = Guid.NewGuid(), Name = "C Objective" }; var b3 = new BookTable() { Id = Guid.NewGuid(), Name = "F sharp" }; Guid id = Guid.Parse("00000000-0000-0000-0000-000000000000"); //var bk = db.BookTables.Where(x => x.Id == id).FirstOrDefault(); //bk.Name = "C sharp"; db.BookTables.Add(b1); db.BookTables.Add(b2); db.BookTables.Add(b3); db.SaveChanges(); } }
static void Display() { //Console.WriteLine("Nothing"); using (var db = new BookAppDBEntities()) { foreach (var books in db.BookTables) { Console.WriteLine(books.Name); } ; } }
static void Add() { //Console.WriteLine("Nothing"); Console.WriteLine("Enter a book name: "); string input = Console.ReadLine(); using (var db = new BookAppDBEntities()) { var book = new BookTable() { // var input = Console.ReadLine(); Id = Guid.NewGuid(), Name = input }; db.BookTables.Add(book); db.SaveChanges(); Console.WriteLine($"{input} was being added."); } }
static void Update() { //Console.WriteLine("Nothing"); Console.WriteLine("What book do you want to update: "); string oldName = Console.ReadLine(); using (var db = new BookAppDBEntities()) { var book = db.BookTables .Where(x => x.Name == oldName).FirstOrDefault(); Console.WriteLine("Enter the new name: "); string newName = Console.ReadLine(); if (book != null) { db.Entry(oldName).CurrentValues.SetValues(newName); db.SaveChanges(); } Console.WriteLine($"{newName} was being updated."); } }
static void Remove() { //Console.WriteLine("Nothing"); Console.WriteLine("What book do you want to remove: "); string input = Console.ReadLine(); using (var db = new BookAppDBEntities()) { //var book = new BookTable() //{ // Id = Guid.NewGuid(), // Name = Console.ReadLine() //}; //db.BookTables.Remove(book); //db.SaveChanges(); var book = db.BookTables .Where(x => x.Name == input).FirstOrDefault(); db.BookTables.Remove(book); db.SaveChanges(); Console.WriteLine($"{input} was being removed."); } }