.NET5 ASP.NET CORE 使用 EF CORE MS SQL SERVER
2021/5/18 19:26:09
本文主要是介绍.NET5 ASP.NET CORE 使用 EF CORE MS SQL SERVER,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
开发工具:VS2019
1。修改appsettings.json,增加一项。
"ConnectionStrings": { "DefaultConnection": "Server=127.0.0.1;Database=db1; User=sa;Password=dd;" }
完整appsettings.json:
{ "Logging": { "LogLevel": { "Default": "Information", "Microsoft": "Warning", "Microsoft.Hosting.Lifetime": "Information" } }, "AllowedHosts": "*", "ConnectionStrings": { "DefaultConnection": "Server=127.0.0.1;Database=db1; User=sa;Password=dd;" } }
2。nuget 引用Microsoft.EntityFrameworkCore,Microsoft.EntityFrameworkCore.SqlServer
3.新建实体类
using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; namespace WebApp5.DbModels.db1 { //[Table("Table1")] public class Table1 { [Key] //主键 [DatabaseGenerated(DatabaseGeneratedOption.Identity)] //设置自增 public long aa { get; set; } public string bb { get; set; } public string cc { get; set; } } }
数据库表结构:
CREATE TABLE [dbo].[Table1]( [aa] [bigint] IDENTITY(1,1) NOT NULL, [bb] [nvarchar](50) NULL, [cc] [nvarchar](50) NULL, CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED ( [aa] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO
4。添加db1DbContext
using Microsoft.EntityFrameworkCore; using WebApp5.DbModels.db1; namespace WebApp5.MyDbContext { public class db1DbContext : DbContext { public db1DbContext(DbContextOptions options) : base(options) { } //添加表实体 public DbSet<Table1> Table1 { get; set; } } }
注意“Table1”这个属性名要和数据库表名一致,如果想不一致,在实体类上加[Table("Table1")]
5。修改Startup.cs,在ConfigureServices方法中增加:
services.AddDbContext<db1DbContext>(options => options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));
其中,DefaultConnection是appsettings.json里的数据库连接字符串。db1DbContext 是刚新加的DbContext。
6,在controller 中使用,部分代码:
private readonly ILogger<HomeController> _logger; public readonly db1DbContext _db1Context; public HomeController(ILogger<HomeController> logger, db1DbContext db1Context) { _logger = logger; _db1Context = db1Context; } public IActionResult Index() { try { WebApp5.DbModels.db1.Table1 mdl = new DbModels.db1.Table1(); mdl.bb = "bb-" + DateTime.Now.ToString(); mdl.cc = "cc-" + DateTime.Now.ToString(); _db1Context.Table1.Add(mdl); _db1Context.SaveChanges(); var myModel = _db1Context.Table1.FirstOrDefault(x => x.bb == "11"); if (myModel == null) { ViewBag.aa = "未找到"; } else { ViewBag.aa = "找到"; } } catch (Exception ex) { ViewBag.aa = ex.Message; } return View(); }
首先要声明一个“public readonly db1DbContext _db1Context;”,构造函数里加一个参数“db1DbContext db1Context”,赋值“_db1Context = db1Context;”,在action里就可以使用了。
这篇关于.NET5 ASP.NET CORE 使用 EF CORE MS SQL SERVER的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2022-03-01沐雪多租宝商城源码从.NetCore3.1升级到.Net6的步骤
- 2024-05-08首个适配Visual Studio平台的国产智能编程助手CodeGeeX正式上线!C#程序员必备效率神器!
- 2024-03-30C#设计模式之十六迭代器模式(Iterator Pattern)【行为型】
- 2024-03-29c# datetime tryparse
- 2024-02-21list find index c#
- 2024-01-24convert toint32 c#
- 2024-01-24Advanced .Net Debugging 1:你必须知道的调试工具
- 2024-01-24.NET集成IdGenerator生成分布式全局唯一ID
- 2024-01-23用CI/CD工具Vela部署Elasticsearch + C# 如何使用
- 2024-01-23.NET开源的简单、快速、强大的前后端分离后台权限管理系统