FileBaseContext 4.0.0

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

// Install FileBaseContext as a Cake Tool
#tool nuget:?package=FileBaseContext&version=4.0.0

FileBaseContext

FileBaseContext is a provider of Entity Framework Core 8 to store database information in files.

It was built for development purposes. All information is stored in files that can be added, updated, or deleted manually.

Benefits

  • you don't need a database
  • rapid modeling
  • version control supported
  • supports all serializable .NET types-
  • unit tests

Download

https://www.nuget.org/packages/FileBaseContext/

Configure Database Context

add database context to services

services.AddDbContext<ApplicationDbContext>(options => options.UseFileBaseContextDatabase("dbUser"));

or configure the database context itself

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
	optionsBuilder.UseFileStoreDatabase("my_local_db");
	base.OnConfiguring(optionsBuilder);
}

Configure Provider

Named database
optionsBuilder.UseFileBaseContextDatabase(databaseName: "my_local_db");
Custom location
optionsBuilder.UseFileBaseContextDatabase(location: "C:\Temp\userDb");

Unit testing

Since 2.1.0 the FileBaseContext injects access to the file system through System.IO.Abstractions library. It allows the use of the provider in unit tests.

If you need to use the provider in unit tests, you can change IFileSystem to MockFileSystem in OnConfiguring method in datacontext class.

private readonly MockFileSystem _fileSystem;
public DbTestContext(MockFileSystem fileSystem)
{
    _fileSystem = fileSystem;
}

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
    optionsBuilder.UseFileBaseContextDatabase(DatabaseName, null, services =>
    {
        services.AddMockFileSystem(_fileSystem);
    });
}

Please find example in the SimplePositiveTests class in the test project

New in 4.0.0

Since the 4.0.0 version the FileBaseContext supports storing data in the CSV files. The CSV files are stored in the directory with the database name. The CSV files are named by the entity name. The first row in the CSV file is the header with the column names.

! Braking changes in 3.0.0 !

In 3.0.0 version the provider was changed to support numeric values without quotation marks.

{
    "IntProp": 42,
    "LongProperty": 420,
    "DateTime": "2023-12-26T19:28:08"
}

The led to breaking changes in the provider. If you have used the provider before, you need to manualy update the database files. The changes also affect on DateTime and DateTimeOffset values. The values are stored as string in the database. First run of the application could be slow becasuse a lot of System.Text.Json.JsonException will be provided. Performance be fixed after provider saves a database to files. While that the data will be stored in new formats. If you still have performance issues you need to manualy update the database files.

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)
Additional computed target framework(s)
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
4.0.0 41 2/23/2024
3.0.0 136 1/17/2024
2.1.0 98 1/9/2024
2.0.0 267 12/4/2023
1.0.4 89 12/4/2023
1.0.3 116 11/25/2023
1.0.2 216 10/27/2023
1.0.1 2,234 1/20/2023
1.0.0-rc-1 141 1/11/2023