首页 > 代码库 > 探索Aspnetcore+mysql+efcore
探索Aspnetcore+mysql+efcore
摘要
之前尝试了,新建asp.net core站点,那么如何和mysql建立连接,如果操作mysql?本篇将尝试使用EntityFrameworkCore进行mysql的操作。
一个例子
首先新建一个空的Asp.net core站点,如图
安装MySql.Data.EntityFrameworkCore
http://www.nuget.org/packages/MySql.Data.EntityFrameworkCore/7.0.5-IR21
安装成功
这时你可以在project.json中看到MySql.Data.EntityFrameworkCore依赖的配置
新建一个User类
public class User { public int Id { set; get; } public string Name { set; get; } public DateTime Dt { set; get; } = DateTime.Now; }
这里使用 db first方式进行数据库的操作,添加一个test的数据库,然后新建一个user表
添加数据库上下文类。
using Microsoft.EntityFrameworkCore;using MySQL.Data.EntityFrameworkCore.Extensions;using System;using System.Collections.Generic;using System.Linq;using System.Threading.Tasks;using Wolfy.EfMySql.Models;namespace Wolfy.EfMySql.Data{ public class TestContext : DbContext { public DbSet<User> User { set; get; } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) => optionsBuilder.UseMySQL(@"Server=localhost;database=test;uid=root;pwd=123456"); }}
添加控制器
using System;using System.Collections.Generic;using System.Linq;using System.Threading.Tasks;using Microsoft.AspNetCore.Mvc;using Wolfy.EfMySql.Data;using Wolfy.EfMySql.Models;// For more information on enabling MVC for empty projects, visit http://go.microsoft.com/fwlink/?LinkID=397860namespace Wolfy.EfMySql.Controllers{ public class HomeController : Controller { // GET: /<controller>/ public IActionResult Index() { var db = new TestContext(); db.Add(new User { Name = "Hello world" }); db.SaveChanges(); var lst = db.Set<User>().ToList(); return View(lst); } }}
添加路由
using System;using System.Collections.Generic;using System.Linq;using System.Threading.Tasks;using Microsoft.AspNetCore.Builder;using Microsoft.AspNetCore.Hosting;using Microsoft.AspNetCore.Http;using Microsoft.Extensions.DependencyInjection;using Microsoft.Extensions.Logging;namespace Wolfy.EfMySql{ public class Startup { // This method gets called by the runtime. Use this method to add services to the container. // For more information on how to configure your application, visit http://go.microsoft.com/fwlink/?LinkID=398940 public void ConfigureServices(IServiceCollection services) { } // This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory) { loggerFactory.AddConsole(); if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } app.UseMvc(routes => { routes.MapRoute(name: "default", template: "{controller=Home}/{action=index}"); }); } }}
浏览Index
通过上面,可以看出,是没有添加mvc服务,引起的,修改如下:
public void ConfigureServices(IServiceCollection services) { services.AddMvc(); }
视图
@* For more information on enabling MVC for empty projects, visit http://go.microsoft.com/fwlink/?LinkID=397860*@@model List<Wolfy.EfMySql.Models.User><ul style="list-style-type:none;"> @foreach (var item in Model) { <li>@item.Id @item.Name @item.Dt.ToString("yyyy-MM-dd HH:mm:ss")</li> }</ul>
刷新页面
结语
这里算是尝尝鲜。关于asp.net core的更多内容,需要参考https://www.asp.net/core
探索Aspnetcore+mysql+efcore
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。