public static List <Entities.Editorial> GetEditorials() { using (Data.LibraryEntitiesContext _context = new Data.LibraryEntitiesContext()) { return(_context.Editorials.ToList()); } }
public static List <Entities.AuthorsView> GetAuthors() { using (Data.LibraryEntitiesContext _context = new Data.LibraryEntitiesContext()) { return(_context.AuthorsView.ToList()); } }
public static List <Entities.AuthorsByEditorialView> GetAuthorsByEditorial(int editorialId) { using (Data.LibraryEntitiesContext _context = new Data.LibraryEntitiesContext()) { return(_context.AuthorsByEditorialView .Where(x => x.EditorialId == editorialId).ToList()); } }
public static Entities.Editorial PostEditorial(Entities.Editorial editorial) { using (Data.LibraryEntitiesContext _context = new Data.LibraryEntitiesContext()) { Entities.Editorial result = _context.Editorials.Add(editorial); _context.SaveChanges(); return(result); } }