WPF实战学习笔记08-创建数据库-Toy模板网

这篇具有很好参考价值的文章主要介绍了WPF实战学习笔记08-创建数据库。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

创建数据库

创建文件夹

./Context

创建文件

./Context/BaseEnity.cs

./Context/Memo.cs

./Context/MyTodoContext.cs

./Context/Todo.cs

./Context/User.cs

创建数据对象

./Context/BaseEnity.cs

namespace MyToDo.Api.Context
{
    public class BaseEnity
    {
        public int Id { get; set; }
        public DateTime CreateDate { get; set; }
        public DateTime UpdateDate { get; set; }
    }
}

./Context/Memo.cs

namespace MyToDo.Api.Context
{
    public class Memo:BaseEnity
    {
        public string Title { get; set; }

        public string Content { get; set; }

    }
}

./Context/MyTodoContext.cs

创建数据库DbSet

using Microsoft.EntityFrameworkCore;

namespace MyToDo.Api.Context
{
    public class MyTodoContext:DbContext
    {
        public MyTodoContext(DbContextOptions<MyTodoContext> options) : base(options) { }

        public DbSet<Todo> TodoSet { get; set; }
        public DbSet<User> UserSet { get; set; }
        public DbSet<Memo> MemoSet { get; set; }
    }
}

./Context/Todo.cs

namespace MyToDo.Api.Context
{
    public class Todo:BaseEnity
    {
        public string Title { get; set; }

        public string Content { get; set; }

        public int Status { get; set; }
    }
}

./Context/User.cs

namespace MyToDo.Api.Context
{
    public class User:BaseEnity
    {
        public string Account { get; set; } 

        public string UserName { get; set; }

        public string Password { get; set; }
    }
}

添加nuget包

Microsoft.EntityFrameworkCore.Design

Shared design-time components for Entity Framework Core tools.
Microsoft.EntityFrameworkCore.Sqlite

SQLite database provider for Entity Framework Core.
Microsoft.EntityFrameworkCore.Tools

Entity Framework Core Tools for the NuGet Package Manager Console in Visual Studio.

Enables these commonly used commands:
Add-Migration
Bundle-Migration
Drop-Database
Get-DbContext
Get-Migration
Optimize-DbContext
Remove-Migration
Scaffold-DbContext
Script-Migration
Update-Database

配置连接字符串

appsettings.json

{
  "ConnectionStrings": {
    "TodoConnection": "Data Source=todo.db"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*"
}

配置数据库连接选项

program.cs

builder.Services.AddDbContext<MyTodoContext>(option =>
{
    var constr = builder.Configuration.GetSection("ConnectionStrings")["TodoConnection"];
    option.UseSqlite(constr);
});
var app = builder.Build();