Rabbit.Common.Data.FreeSql 1.3.1

Rabbit.Common.Data.FreeSql

FreeSql ORM component supporting MySQL and SQL Server. Multi-database support via .NET Keyed Services. Inject IFreeSql for queries.

FreeSql 数据库访问组件，支持 SQL Server 和 MySQL。

安装

dotnet add package Rabbit.Common.Data.FreeSql

使用方式

Console 项目

using Microsoft.Extensions.DependencyInjection;
using Rabbit.Common.Data.FreeSql;
using FreeSql;

// 1. 创建 DI 容器
var services = new ServiceCollection();

// 2. 注册 FreeSql
services.AddFreeSqlOnlyConfigure(
    DataType.MySql,
    "Server=localhost;Database=mydb;User=root;Password=123456;",
    autoSyncDatabase: false
);

// 3. 构建服务提供者
var provider = services.BuildServiceProvider();

// 4. 获取服务并使用
var freeSql = provider.GetRequiredService<IFreeSql>();
var users = await freeSql.Select<User>().ToListAsync();

Web API 项目

using Rabbit.Common.Data.FreeSql;

// 注册
services.AddFreeSqlOnlyConfigure(
    DataType.MySql,
    "Server=localhost;Database=mydb;User=root;Password=123456;",
    autoSyncDatabase: false
);

多数据库配置

Console 项目

// 注册多个数据库
services.AddFreeSqlMapConfigure(
    "db1",
    DataType.MySql,
    "Server=localhost;Database=db1;User=root;Password=123456;"
);

services.AddFreeSqlMapConfigure(
    "db2",
    DataType.SqlServer,
    "Server=.;Database=db2;User=sa;Password=123456;"
);

var provider = services.BuildServiceProvider();

// 获取指定数据库
var db1 = provider.GetRequiredKeyedService<IFreeSql>("db1");
var db2 = provider.GetRequiredKeyedService<IFreeSql>("db2");

Web API 项目

services.AddFreeSqlMapConfigure(
    "db1",
    DataType.MySql,
    "Server=localhost;Database=db1;User=root;Password=123456;"
);

services.AddFreeSqlMapConfigure(
    "db2",
    DataType.SqlServer,
    "Server=.;Database=db2;User=sa;Password=123456;"
);

使用

单数据库

public class UserService
{
    private readonly IFreeSql _fsql;

    public UserService(IFreeSql fsql)
    {
        _fsql = fsql;
    }

    public async Task<List<User>> GetUsersAsync()
    {
        return await _fsql.Select<User>().ToListAsync();
    }
}

多数据库

public class UserService
{
    private readonly IFreeSql _db1;
    private readonly IFreeSql _db2;

    public UserService([FromKeyedServices("db1")] IFreeSql db1,
                       [FromKeyedServices("db2")] IFreeSql db2)
    {
        _db1 = db1;
        _db2 = db2;
    }
}

支持的数据库类型

• DataType.MySql - MySQL
• DataType.SqlServer - SQL Server

许可证

MIT