一、创建简单的minimai api ,命名为AidenAdminCore.Api ,整个项目结构如下:
二、连接数据库
添加引用
EF类库nuget添加: Microsoft.EntityFrameworkCore.SqlServer
API解决方案添加: Microsoft.EntityFrameworkCore.Tools
1、在.Core类库里加上一个Entity的文件夹存放表模型,并添加一个SysUser类
public class SysUser { /// <summary> /// /// </summary> public string Id { get; set; } /// <summary> /// /// </summary> public string Name { get; set; } /// <summary> /// /// </summary> public string Password { get; set; } }
2、在.EF的类库里面新增一个DBContext的文件夹存放数据库上下文,新建一个类
public class AidenDbContext:DbContext { /// <summary> /// /// </summary> /// <param name="options"></param> public AidenDbContext(DbContextOptions<AidenDbContext> options) : base(options) { } /// <summary> /// /// </summary> public DbSet<SysUser> SysUsers { get; set; } }
3、在.api中的appsetting.json里加上连接字符串
{ "ConnectionStrings": { "adminConn": "Data Source=localhost;Initial Catalog=AidenAdmin; User Id=sa;Password=621811" }, "Logging": { "LogLevel": { "Default": "Information", "Microsoft.AspNetCore": "Warning" } }, "AllowedHosts": "*" }
4、在.api中的Program.cs加上数据库配置
builder.Services.AddSqlServer<AidenDbContext>(builder.Configuration.GetConnectionString("adminConn"));
5、 在数据库创建连接中的数据库,然后在vs 默认项目选中EF项目,执行如下命令
Add-Migration
Update-Database
三、引入swagger
1、添加引用
Swashbuckle.AspNetCore
2、在.api中的Program.cs加上swagger配置
builder.Services.AddEndpointsApiExplorer(); builder.Services.AddSwaggerGen(c => { c.SwaggerDoc("v1", new OpenApiInfo { Title = "My API", Version = "v1" }); });
if (app.Environment.IsDevelopment()) { app.UseSwagger(); app.UseSwaggerUI(c => { c.SwaggerEndpoint("/swagger/v1/swagger.json", "My API V1"); }); }
3、运行 程序,在地址栏访问