public IList<Movie> Search(string Filter) { var entities = new MoviesDbContext(); var query = (from c in entities.Movies where c.Title.Contains(Filter) select c).ToList(); return query; }
public Entities.Movie GetOne(int Id) { Entities.Movie result = null; var context = new MoviesDbContext(); result = (from c in context.Movies.Include("Reviews") where c.Id == Id select c).FirstOrDefault(); //using (var con = new SqlConnection(this.ConnectionString)) //{ // result = con.Query<Entities.Movie>("usp_movies_get_one", // new {Id = Id }, // commandType: System.Data.CommandType.StoredProcedure).FirstOrDefault(); //} return result; }
public void CreateReview(Entities.Review Model) { var context = new MoviesDbContext(); context.Reviews.Add(Model); context.SaveChanges(); }