public static void deleteTitle(string isbn) { BooksDataContext dc = new BooksDataContext(); var matchedTitle = (from t in dc.GetTable<Title>() where t.ISBN == isbn select t).SingleOrDefault(); dc.Titles.DeleteOnSubmit(matchedTitle); dc.SubmitChanges(); }
public static void DeleteAuthor(int authorID) { BooksDataContext dc = new BooksDataContext(); var matchedAuthor = (from a in dc.GetTable<Author>() where a.AuthorID == authorID select a).SingleOrDefault(); dc.Authors.DeleteOnSubmit(matchedAuthor); dc.SubmitChanges(); }
public static void DeleteAuthorISBN(string isbn, int id) { BooksDataContext dc = new BooksDataContext(); var matchedAuthorISBN = (from authorisbn in dc.GetTable<AuthorISBN>() where authorisbn.ISBN == isbn && authorisbn.AuthorID == id select authorisbn).SingleOrDefault(); dc.AuthorISBNs.DeleteOnSubmit(matchedAuthorISBN); dc.SubmitChanges(); }
public static void insertOrUpdateTitle(string isbn, string title, int edition, string copyright) { BooksDataContext dc = new BooksDataContext(); Table<Title> titles = Accessor.getTitlesTable(); Title t = new Title(); t.ISBN = isbn; t.BookTitle = title; t.EditionNumber = edition; t.Copyright = copyright; titles.InsertOnSubmit(t); titles.Context.SubmitChanges(); dc.SubmitChanges(); }
public static void InsertOrUpdateAuthorISBN(string isbn, int id) { BooksDataContext dc = new BooksDataContext(); Table<AuthorISBN> authorISBNs = dc.GetTable<AuthorISBN>(); AuthorISBN a = new AuthorISBN(); a.AuthorID = id; a.ISBN = isbn; authorISBNs.InsertOnSubmit(a); authorISBNs.Context.SubmitChanges(); dc.SubmitChanges(); }
public static void InsertOrUpdateAuthor(string first, string last) { BooksDataContext dc = new BooksDataContext(); Table<Author> authors = Accessor.GetAuthorsTable(); Author au = new Author(); au.FirstName = first; au.LastName = last; authors.InsertOnSubmit(au); authors.Context.SubmitChanges(); dc.SubmitChanges(); }