public BookAuthorConnector Getbooks(int id) { BookAuthorConnector model = new BookAuthorConnector(); model.Books = db.books.Select(x => new SelectListItem() { Text = x.title, Value = x.id.ToString() }); model.Authors = db.authors_books.Where(x => x.book_id == id && x.author.id != x.author_id).Select(x => new SelectListItem() { Text = x.author.name, Value = x.author.id.ToString() }); return(model); }
public ActionResult BookAuthorConnect() { BookAuthorConnector model = new BookAuthorConnector(); model.Books = db.books.Select(x => new SelectListItem() { Text = x.title, Value = x.id.ToString() }); model.Authors = db.authors.Select(x => new SelectListItem() { Text = x.name, Value = x.id.ToString() }); return(View("BookAuthorConnect", model)); }