SQLite 的实体框架迁移SqlGenerator [英] Entity Framework MigrationSqlGenerator for SQLite

问题描述

是否有用于 SQLite 的 MigrationSqlGenerator 与实体框架一起使用?我只从 devart 找到了一个是商业的.

is there a MigrationSqlGenerator for SQLite to use with entity framework? I only found one from devart which is commercial.

找不到提供程序System.Data.SQLite"的 MigrationSqlGenerator.利用目标迁移配置中的 SetSqlGenerator 方法类来注册额外的 SQL 生成器.

No MigrationSqlGenerator found for provider 'System.Data.SQLite'. Use the SetSqlGenerator method in the target migrations configuration class to register additional SQL generators.

这就是我所做的:http://msdn.microsoft.com/en-gb/data/jj591621

推荐答案

对于正在寻找处理迁移的生成器的任何人，我在 https://sqliteef6migrations.codeplex.com 称为System.Data.SQLite.EF6.Migrations".

For anyone who is looking for a generator that handles migrations as well I found a nuget package at https://sqliteef6migrations.codeplex.com called "System.Data.SQLite.EF6.Migrations".

安装软件包后，您需要对迁移配置方法进行以下更改.

After you have installed the package you will need to make the following changes to the Migrations Configuration Method.

 public Configuration()
 {
    AutomaticMigrationsEnabled = false;
    SetSqlGenerator("System.Data.SQLite", new SQLiteMigrationSqlGenerator());
 }

完整的类应该是这样的.

The complete class should look something like this.

namespace YourNamespace
{
    using System.Data.Entity.Migrations;
    using System.Data.SQLite.EF6.Migrations;

    internal sealed class Configuration : DbMigrationsConfiguration<YourContext>
    {
        public Configuration()
        {
            AutomaticMigrationsEnabled = false;
            SetSqlGenerator("System.Data.SQLite", new SQLiteMigrationSqlGenerator());
        }

        protected override void Seed(YourContext context)
        {
            //  This method will be called after migrating to the latest version.
        }
    }
}

这篇关于SQLite 的实体框架迁移SqlGenerator的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！