TransientDb 1.5.0

.NET 6.0 
dotnet add package TransientDb --version 1.5.0
NuGet\Install-Package TransientDb -Version 1.5.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="TransientDb" Version="1.5.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add TransientDb --version 1.5.0
#r "nuget: TransientDb, 1.5.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 TransientDb as a Cake Addin
#addin nuget:?package=TransientDb&version=1.5.0

// Install TransientDb as a Cake Tool
#tool nuget:?package=TransientDb&version=1.5.0

TransientDb

TransientDb is a lightweight, dynamic, runtime, code-only database which comes in handy whenever you need quick setup and teardown of an ephemeral database with a controlled starting state specified by SQL scripts. It is based on MS SQL Local DB.

Installing

Usage

TransientDb can be used to create and destroy local databases on the fly via SQL scripts. This is a very powerful concept when you want to create fully integration tested code (all the way down the DB level) without having to share databases (which is un-controlled and un-scientific) or create convoluted infrastructure to emulate an in-memory database.

It is ORM agnostic because its an actual database!

The following code shows an example:


	using(var transientDbConnection = TransientDb.Create(new FileInfo("CreateCompanyDatabase.sql")))
	{	
		// Transient database starts existing here
		
		// Dapper integration is seamless
		var dapperPerson = transientDbConnection.Connection.Query<Person>("select * from dbo.Persons where Id = 3").FirstOrDefault()
		
		// Create and point your EF DB context to your transient db
		var myEfDbContext = new CompanyContext(transientDbConnection.Connection.ConnectionString);
		var efPerson = myEfDbContext.Persons.Where(p => p.Id == 3).FirstOrDefault();
		
	}
	
	// Transient database ceases to exist here (cleaned up along with the connection)
Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  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

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.5.0 149 8/8/2023
1.4.0 116 8/8/2023
1.3.0 129 8/8/2023
1.2.0 128 8/7/2023
1.1.0 155 8/6/2023
1.0.0 167 7/23/2023

Added method to clean up all transient dbs