Chd.Library.Migrations 8.0.9

Migration library for .Net Core

Chd (cleverly handle difficulty) library helps you cleverly handle difficulty, writing code fastly and do your application stable.

📝 Table of Contents

• About
• Getting Started
• Running the tests for PostgreSQL datatabase
• Running the tests for Oracle datatabase
• Running the tests for Mssql datatabase
• Running the tests for SqlLite datatabase
• Usage
• Authors
• Acknowledgments

🧐 About

Migrations are a structured way to alter your database schema and are an alternative to creating lots of sql scripts that have to be run manually by every developer involved.

🏁 Getting Started

This migrations using a table called VersionInfo. Each record in this table contains a unique VersionId.

Prerequisites

You must use .net core 8.0 or higher

🔧 Running the tests for PostgreSQL datatabase

    [TestClass]
    public  class MigrationTestForPostgreSQL
    {
        [Logged]
        [TestMethod]
        public void Test()
        {
            // ==> builder.Services.UseMigration<Program>(Library.Migrations.Enums.DatabaseType.PostgreSQL,"PostgreSQLTest"); //In project usings
            MigrationDependencyInjectionExtensions.AddMigration<MigrationForPostgreSQL>(null, Library.Migrations.Enums.DatabaseType.PostgreSQL, "PostgreSQLTest");
            Thread.Sleep(30000);
        }
    }

    [Migration(12,"mehmet")]
    public class MigrationForPostgreSQL : Migration
    {
        public override void Down()
        {
        }
        public override void Up()
        {
            Create.Table("deneme").WithIdColumn().WithColumn("name").AsString();
        }
    }

🔧 Running the tests for Oracle datatabase

   [TestClass]
    public  class MigrationTestForOracle
    {
        [Logged]
        [TestMethod]
        public void Test()
        {
            //==> builder.Services.UseMigration<Program>(Library.Migrations.Enums.DatabaseType.SQLite,"OracleTest"); //In project usings
            MigrationDependencyInjectionExtensions.AddMigration<MigrationForOracle>(null, Library.Migrations.Enums.DatabaseType.SQLite, "OracleTest");
            Thread.Sleep(30000);
        }
    }

    [Migration(12,"mehmet")]
    public class MigrationForOracle : Migration
    {
        public override void Down()
        {
        }
        public override void Up()
        {
            Create.Table("deneme").WithIdColumn().WithColumn("name").AsString();
        }
    }

🔧 Running the tests for MsSQL datatabase

    [TestClass]
    public  class MigrationTestForMsSQL
    {
        [Logged]
        [TestMethod]
        public void Test()
        {
            // ==> builder.Services.UseMigration<Program>(Library.Migrations.Enums.DatabaseType.MsSQL,"MsSQLTest"); //In project usings
            MigrationDependencyInjectionExtensions.AddMigration<MigrationForMsSQL>(null, Library.Migrations.Enums.DatabaseType.MsSQL, "MsSQLTest");
            Thread.Sleep(30000);
        }
    }

    [Migration(12,"mehmet")]
    public class MigrationForMsSQL : Migration
    {
        public override void Down()
        {
        }
        public override void Up()
        {
            Create.Table("deneme").WithIdColumn().WithColumn("name").AsString();
        }
    }

🔧 Running the tests for SQLite datatabase

    [TestClass]
    public  class MigrationTestForSQLite
    {
        [Logged]
        [TestMethod]
        public void Test()
        {
            // ==> builder.Services.UseMigration<Program>(Library.Migrations.Enums.DatabaseType.SQLite,"SQLiteTest"); //In project usings
            MigrationDependencyInjectionExtensions.AddMigration<MigrationForSQLite>(null, Library.Migrations.Enums.DatabaseType.SQLite, "SQLiteTest");
            Thread.Sleep(30000);
        }
    }

    [Migration(12,"mehmet")]
    public class MigrationForSQLite : Migration
    {
        public override void Down()
        {
        }
        public override void Up()
        {
            Create.Table("deneme").WithIdColumn().WithColumn("name").AsString();
        }
    }

Apsettings Configurations

You must add code below in appsettings.json

  "ConnectionStrings": {
    "SQLiteTest": "Data Source=mydb.db;",
    "OracleTest":"Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;",
    "MsSQLTest": "Data Source=mydb.db;",
    "PostgreSQLTest": "IncludeErrorDetails = true;User ID=postgres;Password=library_postgres_admin;Server=localhost;Port=5432;Database=KUSYS_db;Integrated Security=true;Pooling=true;",
  }

Test Result

After running test, you can see sample table on database.

🎈 Usage

Just run the application to get the migrations work done.

✍️ Authors

• Mehmet Yoldaş - Linkedin

See also the list of contributors who participated in this project.

🎉 Acknowledgements

Thank you for using my library.