如何使用EF在SQLite中启用迁移 [英] How to enable migration in SQLite using EF

问题描述

我陷入了问题。我正在为Windows桌面应用程序编写代码，并且必须使用sqlite作为数据库。我已经从nuget包中成功安装了 system.data.sqlite 和实体框架。我还创建了DbContext类。现在的问题是，一旦我尝试运行代码，就会出现异常，其内部消息是

I have stuck in problem. I am writing a code for windows desktop application and I have to use sqlite as a database. I have successfully installed system.data.sqlite and entity framework from nuget package. I have also created my DbContext class. Now problem is that as soon as I tried to run my code an exception comes whose inner message is

{ SQLite错误1：'否这样的表：TimeSheet'}。

{"SQLite Error 1: 'no such table: TimeSheet'"}.

这意味着您的表TimeSheet在数据库中不存在。请告诉我如何使用实体框架在sqlite中创建表或如何启用迁移。

This means your table TimeSheet does not exist in database. Plz tell me how to create table in sqlite using entity framework or how to enable migrations.

推荐答案

SQLite。

https://github.com/bubibubi/db2ef6migrations 基于新的EF6迁移接口，但有一些限制。
您可以从Nuget下载它，搜索System.Data.SQLite.EF6.Migrations

https://github.com/bubibubi/db2ef6migrations is based on the new EF6 migration interface but it has some restrictions. You can download it from Nuget searching for System.Data.SQLite.EF6.Migrations

这篇关于如何使用EF在SQLite中启用迁移的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！