XT.FeSql 1.0.0

.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher. 
dotnet add package XT.FeSql --version 1.0.0                

                    
                

            
NuGet\Install-Package XT.FeSql -Version 1.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="XT.FeSql" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add XT.FeSql --version 1.0.0                

                    
                

            
#r "nuget: XT.FeSql, 1.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install XT.FeSql as a Cake Addin
#addin nuget:?package=XT.FeSql&version=1.0.0

// Install XT.FeSql as a Cake Tool
#tool nuget:?package=XT.FeSql&version=1.0.0

freesql封装库，包含雪花id创建器

初始化

  1. 使用前需要添加配置（appsettings），配置对象为 XTDbConfig （支持多库切换）
  2. 使用时要初始化
Services.AddSingleton(new AppSettings(builder.Environment.IsDevelopment()));
Services.AddXTDbSetup();

// 或者不读取配置文件，直接初始化
Services.ADDXTDbSetup(new XT.FeSql.Models.XTDbConfig())

使用方式

  1. 注入XTDbContext对象
  2. GetDb()获取FreeSql实例
  3. 支持最多3个主库，通过 GetSqlDb<OneFlag> GetSqlDb<TwoFlag> 切换

数据库连接串

  • Oracle:
DATA SOURCE=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(PORT=21)))(CONNECT_DATA=(SERVICE_NAME=XX)));USER ID=XX;Password=XX
  • PostgreSql:
Host=192.168.0.1 Port=20; Database=XX; Username=XX; Password=XX;
  • Sqlite
DataSource=./test.db
Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on XT.FeSql:

Package Downloads
XT.Task

扩展 FreeScheduler,便于使用

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.0.0 185 12/1/2023