FluentMigrator.Runner.SQLite 6.2.0

Prefix Reserved

Requires NuGet 3.5 or higher.

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

// Install FluentMigrator.Runner.SQLite as a Cake Tool
#tool nuget:?package=FluentMigrator.Runner.SQLite&version=6.2.0                

FluentMigrator

FluentMigrator is a an open-source .NET library that allows you to manage and version database schema changes using a code-first approach. With FluentMigrator, you can define database migrations as code rather than maintaining SQL scripts or using other tools.

Some key features of FluentMigrator include:

  • Code-based Migrations: You define database migrations as C# or VB.NET classes, making it easier to version control and maintain your schema changes.
  • Fluent Interface: FluentMigrator provides a fluent interface for defining database objects like tables, columns, indexes, and constraints, making the code more readable and expressive.
  • Cross-platform: FluentMigrator supports multiple databases, including SQL Server, PostgreSQL, MySQL, Oracle, and SQLite.
  • Rollback Support: FluentMigrator allows you to roll back migrations, making it easier to undo changes or revert to a previous database state.
  • Extensibility: You can create your own custom migrations, conventions, and processors to extend FluentMigrator's functionality.

Getting Started

For a brief overview on getting started with FluentMigrator, please see the documentation links here:

Installation

You can install FluentMigrator via NuGet:

Install-Package FluentMigrator

Usage

FluentMigrator example migration and usage:

[Migration(202401011200)]
public class CreatePersonTable : Migration
{
    public override void Up()
    {
        Create.Table("People")
            .WithColumn("Id").AsGuid().PrimaryKey()
            .WithColumn("Name").AsString(100).NotNullable()
            .WithColumn("Email").AsString(200).Nullable();
    }

    public override void Down()
    {
        Delete.Table("People");
    }
}

For more detailed documentation and examples, please refer to [link to your comprehensive documentation].

Feedback and Contributing

We welcome your feedback, bug reports, and contributions to FluentMigrator.

  • To report a bug or request a feature, please open an issue on our GitHub repository.

If you'd like to contribute to the project, please follow our contributing guidelines.

License

FluentMigrator is released under the Apache license. See the LICENSE file for more details.

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  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. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 is compatible.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (9)

Showing the top 5 NuGet packages that depend on FluentMigrator.Runner.SQLite:

Package Downloads
FluentMigrator.Runner

FluentMigrator is a database migration framework for .NET written in C#. The basic idea is that you can create migrations which are simply classes that derive from the Migration base class and have a Migration attribute with a unique version number attached to them. Upon executing FluentMigrator, you tell it which version to migrate to and it will run all necessary migrations in order to bring your database up to that version. In addition to forward migration support, FluentMigrator also supports different ways to execute the migrations along with selective migrations called profiles and executing arbitrary SQL.

WorkflowEngine.NETCore-ProviderForSQLite

Contains dlls for SQLite Server Persistence Provider: DbPersistenceProvider which implements interface IPersistenceProvider, DbSchemePersistenceProvider which implements interface ISchemePersistenceProvider, DbXmlWorkflowGenerator which implements interface IWorkflowGenerator. Steps for workflow runtime configuration with SQLiteProvider: https://workflowengine.io/documentation/workflow-server/how-to-launch/#customdb in Create WorkflowRuntime section.

FluentCMS

CRUD (Create, Read, Update, Delete) for any entities

DS.Foundation.Data

Package Description

CleanCodeTemplate

Almost clean code

GitHub repositories (2)

Showing the top 2 popular GitHub repositories that depend on FluentMigrator.Runner.SQLite:

Repository Stars
BrighterCommand/Brighter
A framework for building messaging apps with .NET and C#.
optimajet/WorkflowEngine.NET
WorkflowEngine.NET - component that adds workflow in your application. It can be fully integrated into your application, or be in the form of a specific service (such as a web service).
Version Downloads Last updated
6.2.0 502 10/4/2024
6.1.4 594 10/2/2024
6.1.1 818 10/2/2024
6.1.0 161 10/2/2024
6.0.0 8,392 9/25/2024
5.2.0 873,151 3/28/2024
5.1.0 212,659 2/19/2024
5.0.0 492,982 12/10/2023
3.3.2 6,878,200 1/14/2022
3.3.1 1,496,016 9/21/2021
3.3.0 366,339 8/26/2021
3.2.17 898,600 6/17/2021
3.2.16 384,260 5/19/2021
3.2.15 1,206,614 2/19/2021
3.2.14 1,550 2/19/2021
3.2.11 365,774 1/9/2021
3.2.10 71,416 12/19/2020
3.2.9 1,776,810 8/25/2020
3.2.8 199,107 7/22/2020
3.2.7 645,507 6/8/2020
3.2.6 700,069 4/11/2020
3.2.1 3,390,213 4/16/2019
3.2.0 5,328 4/15/2019
3.1.3 1,231,835 6/25/2018
3.1.2 4,472 6/21/2018
3.1.1 19,126 6/11/2018
3.1.0 3,960 6/1/2018
3.0.0 62,305 5/7/2018
2.0.7 334,778 4/27/2018
2.0.6 14,554 4/24/2018
2.0.5 4,129 4/23/2018
2.0.4 2,125 4/23/2018
2.0.3 2,419 4/22/2018
2.0.2 104,924 4/17/2018
2.0.1 3,670 4/16/2018
2.0.0 8,290 4/15/2018

Use of standard dependency injection, configuration and logging libraries.
Simplification of in-process runner configuration and instantiation.
Minimum .NET Framework version is 4.8, see https://aka.ms/msbuild/developerpacks for more information.

Details: https://github.com/fluentmigrator/fluentmigrator/releases