Aiursoft.DbTools.Sqlite
8.0.28
dotnet add package Aiursoft.DbTools.Sqlite --version 8.0.28
NuGet\Install-Package Aiursoft.DbTools.Sqlite -Version 8.0.28
<PackageReference Include="Aiursoft.DbTools.Sqlite" Version="8.0.28" />
paket add Aiursoft.DbTools.Sqlite --version 8.0.28
#r "nuget: Aiursoft.DbTools.Sqlite, 8.0.28"
// Install Aiursoft.DbTools.Sqlite as a Cake Addin #addin nuget:?package=Aiursoft.DbTools.Sqlite&version=8.0.28 // Install Aiursoft.DbTools.Sqlite as a Cake Tool #tool nuget:?package=Aiursoft.DbTools.Sqlite&version=8.0.28
DBTools
DbTools are Aiursoft's common database tools. It contains a lot of useful database tools for developers.
Installation
To install Aiursoft.DbTools
to your project from nuget.org:
dotnet add package Aiursoft.DbTools
Usage
Easier to register DbContext:
SQLite
var services = new ServiceCollection();
services.AddAiurSqliteWithCache<MyDbContext>("Data Source=app.db");
var built = services.BuildServiceProvider();
var context = built.GetRequiredService<MyDbContext>();
SQL Server
var services = new ServiceCollection();
services.AddAiurSqlServerWithCache<MyDbContext>("Server=(localdb)\\mssqllocaldb;Database=DebugTrusted_Connection=True;MultipleActiveResultSets=true");
var built = services.BuildServiceProvider();
var context = built.GetRequiredService<MyDbContext>();
Easier to update database:
var hostBuilder = Host.CreateDefaultBuilder();
hostBuilder.ConfigureServices(services =>
services.AddAiurSqliteWithCache<MyDbContext>(@"DataSource=app.db;Cache=Shared")
);
var host = hostBuilder.Build();
// Now update:
await host.UpdateDbAsync<MyDbContext>(UpdateMode.CreateThenUse);
Switchable database
Supports:
- Sqlite
- MySql
- InMemory
First, install the package:
dotnet add package Aiursoft.DbTools.Switchable
In your appsettings.json
:
{
// Database.
"ConnectionStrings": {
"AllowCache": "True",
"DbType": "Sqlite",
"DefaultConnection": "DataSource=app.db;Cache=Shared"
},
}
In your startup.cs
:
var connectionString = configuration.GetConnectionString("DefaultConnection");
var dbType = configuration.GetSection("ConnectionStrings:DbType").Get<DbType>();
var allowCache = configuration.GetSection("ConnectionStrings:AllowCache").Get<bool>();
services.AddDatabase<MyDbContext>(connectionString, dbType, allowCache);
Tips
If your database project is different with your web project, you may need the following command to generate migrations:
cd ./DatabaseProject
dotnet ef migrations add MigrationName --context YourContext --output-dir Migrations --startup-project ../WebProject
dotnet ef database update --context YourContext
How to contribute
There are many ways to contribute to the project: logging bugs, submitting pull requests, reporting issues, and creating suggestions.
Even if you with push rights on the repository, you should create a personal fork and create feature branches there when you need them. This keeps the main repository clean and your workflow cruft out of sight.
We're also interested in your feedback on the future of this project. You can submit a suggestion or feature request through the issue tracker. To make this process more effective, we're asking that these include more information to help define them more clearly.
Product | Versions 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. |
-
net8.0
- Aiursoft.DbTools (>= 8.0.12)
- EFCoreSecondLevelCacheInterceptor (>= 4.9.0)
- Microsoft.EntityFrameworkCore.Sqlite (>= 8.0.11)
NuGet packages (1)
Showing the top 1 NuGet packages that depend on Aiursoft.DbTools.Sqlite:
Package | Downloads |
---|---|
Aiursoft.DbTools.Switchable
Nuget package of 'Switchable' provided by Aiursoft |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
8.0.28 | 111 | 12/11/2024 |
8.0.27 | 130 | 11/14/2024 |
8.0.26 | 94 | 11/13/2024 |
8.0.24 | 99 | 11/9/2024 |
8.0.23 | 108 | 10/26/2024 |
8.0.22 | 124 | 10/14/2024 |
8.0.21 | 101 | 10/9/2024 |
8.0.20 | 122 | 9/29/2024 |
8.0.19 | 97 | 9/28/2024 |
8.0.18 | 113 | 9/22/2024 |
8.0.17 | 142 | 8/22/2024 |
8.0.16 | 130 | 8/18/2024 |
8.0.15 | 116 | 7/23/2024 |
8.0.14 | 211 | 7/10/2024 |
8.0.13 | 113 | 7/7/2024 |
8.0.12 | 116 | 6/29/2024 |
8.0.11 | 129 | 6/5/2024 |
8.0.10 | 118 | 5/28/2024 |
8.0.9 | 125 | 5/16/2024 |
8.0.8 | 144 | 5/4/2024 |
8.0.7 | 143 | 4/6/2024 |
8.0.6 | 131 | 3/31/2024 |
8.0.5 | 105 | 3/31/2024 |
8.0.4 | 160 | 3/17/2024 |
8.0.3 | 114 | 3/17/2024 |
8.0.2 | 120 | 3/3/2024 |
8.0.1 | 117 | 2/25/2024 |
8.0.0 | 210 | 2/19/2024 |
7.0.25 | 152 | 2/14/2024 |
7.0.24 | 113 | 2/4/2024 |
7.0.23 | 110 | 2/2/2024 |
7.0.22 | 113 | 2/2/2024 |
7.0.21 | 117 | 1/30/2024 |
7.0.20 | 113 | 1/27/2024 |
7.0.19 | 127 | 1/21/2024 |
7.0.18 | 132 | 1/10/2024 |
7.0.17 | 127 | 1/4/2024 |
7.0.16 | 150 | 12/30/2023 |
7.0.15 | 135 | 12/24/2023 |
7.0.14 | 145 | 12/12/2023 |
7.0.13 | 121 | 12/12/2023 |
7.0.12 | 143 | 12/1/2023 |
7.0.11 | 137 | 11/26/2023 |
7.0.10 | 141 | 11/18/2023 |
7.0.9 | 129 | 11/12/2023 |
7.0.8 | 137 | 11/2/2023 |
7.0.7 | 129 | 11/2/2023 |
7.0.6 | 131 | 11/1/2023 |
7.0.5 | 119 | 10/31/2023 |
7.0.4 | 136 | 10/27/2023 |
7.0.3 | 145 | 10/18/2023 |
7.0.2 | 132 | 10/11/2023 |
7.0.1 | 141 | 9/13/2023 |
7.0.0 | 136 | 9/5/2023 |
6.0.32 | 151 | 8/4/2023 |
6.0.31 | 164 | 8/3/2023 |
6.0.30 | 164 | 7/11/2023 |
6.0.29 | 158 | 6/30/2023 |