Apq.Cfg/Apq.Cfg.Database

Apq.Cfg.Database

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

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

依赖

• Apq.Cfg
• SqlSugarCore 5.1.4.210

支持的数据库

• 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.Get("Database:ConnectionString");
var timeout = cfg.Get<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