在vs2015上使用asp.net core+ef core

官方的文档https://docs.asp.net/en/latest/tutorials/first-mvc-app/start-mvc.html

先来看一下实现的效果

 开始之前，确定本机已经有.NET Core环境。https://www.microsoft.com/net/core#windows

1.创建解决方案的文件结构如下图（模糊处理的过文件是自己后面加的和ef生成的）。

2.要使用ef core，先引用ef core相关的程序包。https://docs.efproject.net/en/latest/platforms/aspnetcore/existing-db.html

打开project.json，将“Microsoft.EntityFrameworkCore.SqlServer”、“Microsoft.EntityFrameworkCore.SqlServer.Design”和“Microsoft.EntityFrameworkCore.Design”添加到“dependencies”下；将“Microsoft.EntityFrameworkCore.Tools”添加到“tools”下。（注：当然这些都可以通过NuGet来安装，需要注意的是用nuget安装“Microsoft.EntityFrameworkCore.Tools”时，要将其移动到“tools”下）

3.打开连接到数据库，设置数据库连接字符串

4.打开程序包管理控制台，运行下面命令。-OutputDir Models指向生成文件存放文件的位置是Models

Scaffold-DbContext "Server=.;Database=CoreDemo;Trusted_Connection=True;User ID=你的连接数据库的用户;Password=你的连接数据库的密码;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

 

5.打开刚才用Scaffold-DbContext生成的CoreDemoContext.cs的文件，移除OnConfiguring方法

6.在CoreDemoContext.cs里面加入下面代码

public CoreDemoContext(DbContextOptions<CoreDemoContext> option)
      : base(option)
{ }

7.打开appsettings.json，加入下面的数据连接配置代码

"ConnectionStrings": {
    "CoreDemoDatabase": "Server=.;Database=CoreDemo;Trusted_Connection=True;User ID=你的连接数据库的用户;Password=你的连接数据库的密码;"
  }

8.打开Startup.cs，修改ConfigureServices方法，如下

public void ConfigureServices(IServiceCollection services)
{
      // Add framework services.
      services.AddMvc();
      services.AddDbContext<CoreDemoContext>(option => option.UseSqlServer(Configuration.GetConnectionString("CoreDemoDatabase"))); // 获取sql连接配置
}

9.添加一个新的Controller--UserController

    public class UserController : Controller
    {
        private CoreDemoContext _context;

        public UserController(CoreDemoContext context)
        {
            _context = context;
        }

        // GET: /<controller>/
        public IActionResult Index()
        {
            var users = (from u in _context.TUsers
                         select u).ToList();
            return View(users);
        }

        public IActionResult Create()
        {
            return View();
        }

        [HttpPost]
        [ValidateAntiForgeryToken]
        public async Task<IActionResult> Create(UserViewModel model)
        {
            if (!ModelState.IsValid)
            {
                return View(model);
            }

            TUsers user = new TUsers()
            {
                Name = model.Name
            };
            _context.TUsers.Add(user);
            int result = await _context.SaveChangesAsync();
            return RedirectToAction("Index");
        }
    }

10.创建Index视图和Create视图

@model IEnumerable<TUsers>

@{
    ViewBag.Title = "用户列表";
}

<h2>用户列表</h2>
<p>
    <a asp-action="Create">添加用户</a>
</p>

<table class="table table-bordered table-hover table-striped">
    <tr>
        <th>姓名</th>
        <th>创建日期</th>
    </tr>
    @foreach (var item in Model)
    {
        <tr>
            <td>
                @Html.DisplayFor(modelItem => item.Name)
            </td>
            <td>
                @(((DateTime)item.CreateDate).ToString("yyyy-MM-dd hh:mm:ss"))
            </td>
        </tr>
    }
</table>

@model WebDemo.Models.UserViewModel

@{
    ViewBag.Title = "新增用户";
}

<h2>创建一个新用户</h2>

<form asp-action="Create" method="post">
    <div class="form-horizontal">
        @*<div asp-validation-summary="All" class="text-danger"></div>*@
        <div class="form-group">
            <label asp-for="Name" class="col-md-2 control-label">姓名：</label>
            <div class="col-md-10">
                <input asp-for="Name" class="form-control" />
                <span asp-validation-for="Name" class="text-danger"></span>
            </div>
        </div>
        <div class="form-group">
            <div class="col-md-offset-2 col-md-10">
                <input type="submit" value="Create" class="btn btn-default" />
            </div>
        </div>
    </div>
</form>

@section scripts{
    @* 添加jquery验证库 *@
    <environment names="Development">
        <script src="~/lib/jquery-validation/dist/jquery.validate.js" asp-append-version="true"></script>
        <script src="~/lib/jquery-validation-unobtrusive/jquery.validate.unobtrusive.js" asp-append-version="true"></script>
    </environment>
    <environment names="Staging,Production">
        <script src="~/lib/jquery-validation/dist/jquery.validate.min.js" asp-append-version="true"></script>
        <script src="~/lib/jquery-validation-unobtrusive/jquery.validate.unobtrusive.min.js" asp-append-version="true"></script>
    </environment>
}

11.到这一步，运行项目可以直接用vs启动，也可以在cmd里面使用“dotnet run”

 

转载请标注原文地址：http://www.cnblogs.com/JasonLong/p/5653273.html