public bool Exists(int id)
{
using (DBBookServiceContext db = new DBBookServiceContext())
{
return(db.DBBooks.Count(a => a.Id == id) > 0);
}
}
public DBBook Get(int id)
{
using (DBBookServiceContext db = new DBBookServiceContext())
{
return(db.DBBooks.Include(x => x.Author).SingleOrDefault(a => a.Id == id));
}
}
public List <DBBook> Get()
{
using (DBBookServiceContext db = new DBBookServiceContext())
{
return(db.DBBooks.Include(x => x.Author).ToList());
}
}
public DBAuthor Get(int id)
{
using (DBBookServiceContext db = new DBBookServiceContext())
{
return(db.DBAuthors.SingleOrDefault(a => a.Id == id));
}
}
public List <DBAuthor> Get()
{
using (DBBookServiceContext db = new DBBookServiceContext())
{
return(db.DBAuthors.ToList());
}
}
public void Remove(DBBook dBBook)
{
using (DBBookServiceContext db = new DBBookServiceContext())
{
db.DBBooks.Remove(dBBook);
db.SaveChanges();
}
}
public void Update(DBBook dBBook)
{
using (DBBookServiceContext db = new DBBookServiceContext())
{
db.Entry(dBBook).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Remove(DBAuthor dBAuthor)
{
using (DBBookServiceContext db = new DBBookServiceContext())
{
db.DBAuthors.Remove(dBAuthor);
db.SaveChanges();
}
}
public DBAuthor Insert(DBAuthor dBAuthor)
{
using (DBBookServiceContext db = new DBBookServiceContext())
{
db.DBAuthors.Add(dBAuthor);
db.SaveChanges();
return(dBAuthor);
}
}
public DBBook Insert(DBBook dBBook)
{
using (DBBookServiceContext db = new DBBookServiceContext())
{
db.DBBooks.Add(dBBook);
db.SaveChanges();
db.Entry(dBBook).Reference(x => x.Author).Load();
return(dBBook);
}
}
