Entity Framework MigrationSqlGenerator for SQLite(SQLite 的实体框架迁移SqlGenerator)
问题描述
是否有用于 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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!
本文标题为:SQLite 的实体框架迁移SqlGenerator


基础教程推荐
- SSE 浮点算术是否可重现? 2022-01-01
- 为什么Flurl.Http DownloadFileAsync/Http客户端GetAsync需要 2022-09-30
- c# Math.Sqrt 实现 2022-01-01
- 有没有办法忽略 2GB 文件上传的 maxRequestLength 限制? 2022-01-01
- 如何在 IDE 中获取 Xamarin Studio C# 输出? 2022-01-01
- MS Visual Studio .NET 的替代品 2022-01-01
- rabbitmq 的 REST API 2022-01-01
- 如何激活MC67中的红灯 2022-01-01
- 将 Office 安装到 Windows 容器 (servercore:ltsc2019) 失败,错误代码为 17002 2022-01-01
- 将 XML 转换为通用列表 2022-01-01