Netmvc学习计划.Net/ASP开发工程师
Enable-Migrations -ContextTypeName _721._1.Models.movieDBContext
---类
public int ID { get; set; }
[Required, StringLength(60, MinimumLength = 3)]
public string Title { get; set; }
public DateTime Releasedate { get; set; }
[Required]
public string Genre { get; set; }
[Range(1, 100), DataType(DataType.Currency)]
public decimal Price { get; set; }
//public int Num { get; set; }
[Required, StringLength(5)]
public string Rating { get; set; }
}
public class movieDBContext : DbContext
{
public DbSet<movie> movies { set; get; }
}
------------------------
<add name="MovieDBContextion" connectionString="Data Source=(LocalDB)/MSSQLLocalDB;AttachDbFilename=|DataDirectory|Movies.mdf;Integrated Security=True" providerName="System.Data.SqlClient" />
Movies Index 视图更改
@using (Html.BeginForm("Index", "Movies", FormMethod.Get))
{
<p>
Genre: @Html.DropDownList("movieGenre", "All")
Title: @Html.TextBox("SearchString")
<input type="submit" value="Filter" />
</p>
}
MOvies 控制器更改
public ActionResult Index(string movieGenre, string searchString)
{
var GenreLst = new List<string>();
var GenreQry = from d in db.movies
orderby d.Genre
select d.Genre;
GenreLst.AddRange(GenreQry.Distinct());
ViewBag.movieGenre = new SelectList(GenreLst);
var movies = from m in db.movies
select m;
if (!String.IsNullOrEmpty(searchString))
{
movies = movies.Where(s => s.Title.Contains(searchString));
}
if (!string.IsNullOrEmpty(movieGenre))
{
movies = movies.Where(x => x.Genre == movieGenre);
}
return View(movies);
}
--------------------添加
context.movies.AddOrUpdate(i => i.Title,
new movie
{
Title = "When Harry Met Sally",
Releasedate = DateTime.Parse("1989-1-11"),
Genre = "Romantic Comedy",
Price = 7.99M
},
new movie
{
Title = "Ghostbusters ",
Releasedate = DateTime.Parse("1984-3-13"),
Genre = "Comedy",
Price = 8.99M
},
new movie
{
Title = "Ghostbusters 2",
Releasedate = DateTime.Parse("1986-2-23"),
Genre = "Comedy",
Price = 9.99M
},
new movie
{
Title = "Rio Bravo",
Releasedate = DateTime.Parse("1959-4-15"),
Genre = "Western",
Price = 3.99M
}
);
删除后更新数据成员
1如上所示的Enable-Migrations 命令，会在
Migrations 文件夹下创建一个
Configuration.cs 文件
Enable-Migration 添加 || add-migration Initial update-databas || 加属性 控制器和视图 2添加属性值 update add-migration Rating add-migration DataAnnotations update-database
明日计划：
1.找一份项目实战的MVC教程开始探索
722-723总结：具体懂得了mvc创建一个movie的增删改查和数据库属性的更新（需删除数据库后更新），及其搜索功能
1914篇文章
