ASP.NET Core在启动过程中使用数据库实例的几种方式

  ASP.NET Core项目启动过程中若要调用SqlSugarClient实例操作数据库数据（假设操作函数如下），特此记录以下几种方式：

public class PublicDataBuffer
{public static List<EnvironmentRecord> DataBuffer = new List<EnvironmentRecord>();public static void InitDataBuffer(ISqlSugarClient dbClient){DataBuffer.AddRange(dbClient.Queryable<EnvironmentRecord>().Select(r => new EnvironmentRecord()).ToPageList(1, 100).ToList());}
}

  1）如果是在SqlSugar数据库实例首次创建时调用操作函数，则在Program.cs文件的注册数据库服务的代码中调用即可。此时操作函数并未直接在启动过程中调用，而是在项目第一次操作数据库时调用。

builder.Services.AddSingleton<ISqlSugarClient>(s =>
{SqlSugarScope sqlSugar = new SqlSugarScope(new ConnectionConfig(){DbType = SqlSugar.DbType.SqlServer,ConnectionString = builder.Configuration.GetValue<string>("dbContext"),IsAutoCloseConnection = false,});PublicDataBuffer.InitDataBuffer(sqlSugar);return sqlSugar;
});

  2）直接在Program.cs中创建数据库实例，既用于注册单例服务，又用于操作函数调用。

SqlSugarScope sqlSugar = new SqlSugarScope(new ConnectionConfig()
{DbType = SqlSugar.DbType.SqlServer,ConnectionString = builder.Configuration.GetValue<string>("dbContext"),IsAutoCloseConnection = false,
});uilder.Services.AddSingleton<ISqlSugarClient>(sqlSugar);
PublicDataBuffer.InitDataBuffer(sqlSugar);

  3）Program.cs中调用WebApplication的Services.GetService函数获取服务实例。

...
...
var app = builder.Build();
...
PublicDataBuffer.InitDataBuffer(app.Services.GetService<ISqlSugarClient>());
...
...

参考文献：
[1]https://blog.csdn.net/fromfire2/article/details/87348154
[2]https://blog.csdn.net/qq_41942413/article/details/134319869
[3]https://cloud.tencent.com/developer/article/2347045