Apq.Cfg/Apq.Cfg.Database

# Apq.Cfg.Database

数据库配置源扩展包，支持多种数据库。

仓库地址：https://gitee.com/apq/Apq.Cfg

📖 在线文档：https://apq-cfg.vercel.app/

依赖

• Apq.Cfg
• SqlSugarCore 5.1.4.210

默认层级

该配置源的默认层级为 CfgSourceLevels.Database (100)。

如果不指定 level 参数，将使用默认层级：

// 使用默认层级 100
.AddDatabase(options => { ... })

// 指定自定义层级
.AddDatabase(options => { ... }, level: 150)

支持的数据库

• SQL Server
• MySQL
• PostgreSQL
• Oracle
• SQLite

用法

using Apq.Cfg;
using Apq.Cfg.Database;

var cfg = new CfgBuilder()
    .AddDatabase(options =>
    {
        options.Provider = "SqlServer";
        options.ConnectionString = "Server=localhost;Database=ConfigDb;...";
        options.Table = "AppConfig";
        options.KeyColumn = "ConfigKey";
        options.ValueColumn = "ConfigValue";
    }, level: 1, isPrimaryWriter: true)
    .Build();

// 使用索引器访问
var connStr = cfg["Database:ConnectionString"];
var timeout = cfg.GetValue<int>("Database:Timeout");

方法签名

public static CfgBuilder AddDatabase(
    this CfgBuilder builder,
    Action<DatabaseOptions> configure,
    int level,
    bool isPrimaryWriter = false)

DatabaseOptions

属性	类型	默认值	说明
Provider	string?	-	数据库提供程序名称
ConnectionString	string?	-	数据库连接字符串
Table	string?	-	配置表名
KeyColumn	string?	-	键列名
ValueColumn	string?	-	值列名
CommandTimeoutMs	int	5000	命令超时（毫秒）

Provider 值

值	数据库
SqlServer	Microsoft SQL Server
MySql	MySQL
PostgreSQL 或 Postgres	PostgreSQL
Oracle	Oracle
SQLite	SQLite

数据表结构

CREATE TABLE AppConfig (
    ConfigKey NVARCHAR(256) PRIMARY KEY,
    ConfigValue NVARCHAR(MAX)
);

示例

SQL Server

.AddDatabase(options =>
{
    options.Provider = "SqlServer";
    options.ConnectionString = "Server=.;Database=MyDb;Trusted_Connection=True;";
    options.Table = "AppConfig";
    options.KeyColumn = "Key";
    options.ValueColumn = "Value";
}, level: 1)

MySQL

.AddDatabase(options =>
{
    options.Provider = "MySql";
    options.ConnectionString = "Server=localhost;Database=mydb;User=root;Password=...;";
    options.Table = "app_config";
    options.KeyColumn = "config_key";
    options.ValueColumn = "config_value";
}, level: 1)

SQLite

.AddDatabase(options =>
{
    options.Provider = "SQLite";
    options.ConnectionString = "Data Source=config.db";
    options.Table = "Config";
    options.KeyColumn = "Key";
    options.ValueColumn = "Value";
}, level: 1)

许可证

MIT License

作者

• 邮箱：[email protected]

仓库

• Gitee：https://gitee.com/apq/Apq.Cfg