ASP.NET Core中使用SQL Server数据库的简便方法

1. 安装工具：

SQL Server Express:
https://www.microsoft.com/en-ca/download/details.aspx?id=55994

SQL Server Management Studio (SSMS)

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Visual Studio Community
https://visualstudio.microsoft.com/downloads/

2. 创建一个目标数据库，设定访问用户和密码。

3. 创建一个数据库工程

这种方法的好处是简易的数据库升级管理。

CREATE TABLE [dbo].[Board]
(
[Id] BIGINT IDENTITY(1,1) NOT NULL,
[Name] NVARCHAR(256) NOT NULL,
[CreateTime] BIGINT,
[UpdateTime] BIGINT,
CONSTRAINT [PK_Board] PRIMARY KEY CLUSTERED ([Id] ASC)

)

4. 定义一个Entity

namespace HWBoard.Controllers.Entity
{
[Table("Board")]
public class Board
{
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public long Id { get; set; }
public string Name { get; set; }
public long CreateTime { get; set; }
public long UpdateTime { get; set; }
}
}