Aiursoft.DbTools 7.0.9

DBTools

MIT licensed Pipeline stat Test Coverage NuGet version (Aiursoft.CSTools) ManHours

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);

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.

Showing the top 20 packages that depend on Aiursoft.DbTools.

Packages Downloads
Aiursoft.DbTools.SqlServer
A tool for database.
203
Aiursoft.DbTools.InMemory
A tool for database.
201
Aiursoft.DbTools.InMemory
A tool for database.
163
Aiursoft.DbTools.InMemory
A tool for database.
125
Aiursoft.DbTools.SqlServer
A tool for database.
124
Aiursoft.DbTools.MySql
A tool for database.
87
Aiursoft.DbTools.InMemory
A tool for database.
86
Aiursoft.DbTools.Sqlite
A tool for database.
85
Aiursoft.DbTools.MySql
A tool for database.
84
Aiursoft.DbTools.Sqlite
A tool for database.
82
Aiursoft.DbTools.InMemory
A tool for database.
77
Aiursoft.DbTools.Sqlite
A tool for database.
75
Aiursoft.DbTools.InMemory
A tool for database.
72
Aiursoft.DbTools.Sqlite
A tool for database.
67
Aiursoft.DbTools.Sqlite
A tool for database.
66
Aiursoft.DbTools.Sqlite
A tool for database.
65
Aiursoft.DbTools.InMemory
A tool for database.
65
Aiursoft.DbTools.Sqlite
A tool for database.
62
Aiursoft.DbTools.InMemory
A tool for database.
59
Aiursoft.DbTools.MySql
A tool for database.
59

Version Downloads Last updated
8.0.12 83 11/13/2024
8.0.11 317 10/09/2024
8.0.10 227 08/18/2024
8.0.9 135 07/10/2024
8.0.8 30 07/07/2024
8.0.7 65 06/29/2024
8.0.6 58 06/05/2024
8.0.5 60 05/16/2024
8.0.4 52 05/04/2024
8.0.3 154 03/26/2024
8.0.2 5 03/29/2024
8.0.1 5 03/30/2024
8.0.0 147 03/25/2024
7.0.19 10 04/29/2024
7.0.18 4 04/29/2024
7.0.17 7 04/28/2024
7.0.16 5 04/29/2024
7.0.15 5 04/29/2024
7.0.14 5 04/29/2024
7.0.13 6 04/29/2024
7.0.12 200 03/26/2024
7.0.11 5 04/29/2024
7.0.10 5 04/29/2024
7.0.9 4 04/29/2024
7.0.8 6 04/29/2024
7.0.7 6 04/29/2024
7.0.6 4 04/29/2024
7.0.5 5 04/29/2024
7.0.4 7 04/12/2024
7.0.3 4 04/29/2024
7.0.2 5 04/29/2024
7.0.1 5 04/29/2024
7.0.0 13 04/29/2024
6.0.32 10 04/29/2024
6.0.31 4 04/29/2024
6.0.30 3 06/20/2024
6.0.29 6 04/29/2024
6.0.28 5 04/29/2024
6.0.27 4 04/29/2024
6.0.26 5 04/29/2024
6.0.25 5 04/29/2024
6.0.24 4 04/29/2024
6.0.23 5 04/29/2024
6.0.22 7 04/29/2024
6.0.21 4 04/29/2024
6.0.20 6 04/29/2024
6.0.19 7 03/28/2024
6.0.18 6 04/29/2024
6.0.17 4 04/29/2024
6.0.16 5 04/29/2024
6.0.15 8 04/23/2024
6.0.14 9 04/29/2024
6.0.13 6 04/29/2024
6.0.12 6 04/07/2024
6.0.11 6 04/29/2024
6.0.10 6 04/29/2024
6.0.9 4 04/29/2024
6.0.8 5 04/29/2024
6.0.7 5 04/29/2024
6.0.6 7 04/29/2024
6.0.5 4 04/29/2024
6.0.0 5 04/29/2024
5.0.9 9 04/29/2024
5.0.8 6 04/29/2024
5.0.7 5 04/29/2024
5.0.6 5 04/04/2024
5.0.5 5 04/29/2024
5.0.4 4 04/29/2024
5.0.3 5 04/29/2024
5.0.2 5 04/29/2024
5.0.1 8 04/26/2024
5.0.0 4 04/29/2024
3.2.11 4 04/29/2024
3.2.10 5 04/29/2024
3.2.9 6 04/29/2024
3.2.8 4 04/29/2024
3.2.7 8 04/29/2024
3.2.6 7 04/29/2024
3.2.5 7 04/29/2024
3.2.4 5 04/29/2024
3.2.3 5 04/29/2024
3.2.2 4 04/29/2024
3.2.1 5 04/29/2024
3.2.0 5 04/29/2024
3.1.14 8 04/29/2024
3.1.13 5 04/29/2024
3.1.12 6 04/08/2024
3.1.11 5 04/29/2024
3.1.10 6 04/14/2024
3.1.9 4 04/29/2024
3.1.8 6 04/29/2024
3.1.7 7 04/29/2024
3.1.6 4 04/29/2024
3.1.5 4 04/29/2024
3.1.4 5 04/29/2024