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