public UnitTest1() { var options = new DbContextOptionsBuilder <MovieDataContext>().UseInMemoryDatabase(databaseName: "movie_tests").Options; //db = MovieRepository(); db = new MovieDataContext(options); db.Movies.AddRange( new Movie { Title = "The Dark Knight", DateSeen = new DateTime(2020, 5, 20), Genre = "Action", Rating = 9 }, new Movie { Title = "Dude Where's My Car", DateSeen = new DateTime(2005, 4, 16), Genre = "Comedy", Rating = 8 } ); db.SaveChanges(); }
public MovieRepository() { _dataContext = new MovieDataContext(); }
protected void Button1_Click(object sender, EventArgs e) { MovieDataContext db = new MovieDataContext(); Love love = new Love(); love.MovieId = TextBox1.Text; db.Love.InsertOnSubmit(love); db.SubmitChanges(); Response.Write("<script type='text/javascript'>alert('收藏成功!正在跳转到登陆页面');location.href='Mylove.aspx';</script> "); }
// Code to execute when the application is launching (eg, from Start) // This code will not execute when the application is reactivated private void Application_Launching(object sender, LaunchingEventArgs e) { using (var db = new MovieDataContext()) { if (!db.DatabaseExists()) { db.CreateDatabase(); } } }
public ActionResult Index() { var dataContext = new MovieDataContext(); var movies = from m in dataContext.Movies select m; return View(movies); }
protected void Button1_Click(object sender, EventArgs e) { MovieDataContext db = new MovieDataContext(); Ques ques = new Ques(); ques.username = txtName.Text; ques.password = txtPassword.Text; db.Ques.InsertOnSubmit(ques); db.SubmitChanges(); Response.Write("<script type='text/javascript'>alert('注册成功!正在跳转到登陆页面');location.href='Login.aspx';</script> "); }
public ActionResult Index() { var dataContext = new MovieDataContext(); int count = (from row in dataContext.Movies where row.IsEnquiry == true select row).Count(); ViewBag.ItemCount = count; return View(); }
protected void btnLogin_Click(object sender, EventArgs e) { MovieDataContext db = new MovieDataContext(); admin a = new admin(); string UserID = txtname.Text; string password = txtpassword.Text; var p = from c in db.admin where c.user == UserID && c.pwd == password select c; if (p.Count() != 0) { Session["user"] = UserID; Session["pwd"] = password; this.Response.Write(" <script language=javascript>alert('登录成功!');location.href='RoleUsers.aspx';</script> "); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new MovieDataContext( serviceProvider.GetRequiredService < DbContextOptions <MovieDataContext> >())) { // Look for any movies. if (context.Movie.Any()) { return; // DB has been seeded } context.Movie.AddRange( new Movie { Name = "When Harry Met Sally", ReleaseYear = 1989, Description = "Romantic Comedy" }, new Movie { Name = "Ghostbusters ", ReleaseYear = 1984, Description = "Comedy" }, new Movie { Name = "Ghostbusters 2", ReleaseYear = 1986, Description = "Comedy" }, new Movie { Name = "Rio Bravo", ReleaseYear = 1959, Description = "Western" } ); context.SaveChanges(); } }
protected void btnLogin_Click(object sender, EventArgs e) { MovieDataContext db = new MovieDataContext(); Ques Q = new Ques(); string UserID = txtName.Text; string password = txtPassword.Text; var p = from c in db.Ques where c.username == UserID && c.password == password select c; if (p.Count() != 0) { Session["username"] = UserID; Session["password"] = password; this.Response.Write(" <script language=javascript>alert('登录成功!');location.href='Home.aspx';</script> "); } else { Response.Write(" <script language=javascript>alert('您的账号或密码错误!');location.href='Login.aspx';</script> "); } }
protected void AddMovieInfo(int id) { int isExit = 0; for (int j = 0; j < Profile.Cart.movieName.Count; j++) { if (id == (int)Profile.Cart.movieId[j]) { isExit = 1; lblError.Text = "您已收藏本电影"; } } if (isExit == 0) { MovieDataContext db = new MovieDataContext(); var movie = (from m in db.MovieInfo where m.id == id select m).First(); Profile.Cart.movieId.Add(movie.id); Profile.Cart.movieName.Add(movie.name); Profile.Save(); } }
public DataService() { _db = new MovieDataContext(); }
public MovieController(MovieDataContext context) { _context = context; }
public MoviesController() { _dataContext = new MovieDataContext(); }