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                
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="Aiursoft.DbTools.Sqlite" Version="8.0.28" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Aiursoft.DbTools.Sqlite --version 8.0.28                
#r "nuget: Aiursoft.DbTools.Sqlite, 8.0.28"                
#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 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

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

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