问题描述
有人知道如何使用最新的System.Data.SQLite构建从SQLite数据库生成实体框架模型吗?
使用旧版本进行此操作很容易，因为它们会自动与Visual Studio集成，但是它们的EF支持对我来说还是有点过时.这就是为什么我不使用他们的EF组件的原因.但是，我目前在Win Forms应用程序中只能使用SQLite数据库，而且数据结构非常复杂，以至于我要自己花时间编写所有读取/写入结构.
<添加:2012年5月21日 st >
我在带有VS 2010 Pro的Win XP SP3虚拟机上进行了其他实验，发现了以下内容.运行新的System.Data.SQLite安装程序后，我为放置在bin目录中的设计时组件运行了安装程序.
*第一次运行它时，出现一个弹出窗口，提示确认"选项未启用，因此失败.
*然后从命令行以如下方式运行它:Installer -Confirm True
**这一次它没有对失败进行任何说明，但是我确实在命令行中查找到最后，它表示未进行任何更改，因为启用了如果"选项.
*这次我运行:安装程序-确认True -WhatIf False
**在创建新的数据库连接时，这添加了System.Data.SQLite数据库文件作为我的DataSources的选项.但是，当我选择一个数据库或创建一个新数据库以输入数据库路径时，用于插入数据库连接的所有弹出窗口都会关闭.
**我尝试在创建新连接时手动插入路径来创建SQLite数据库，而在测试连接时VS冻结.
这就是我现在所处的位置.
Does anyone know how to get generate an entity framework model from a SQLite database using the latest System.Data.SQLite builds?
Doing this with the old builds is easy because they automatically integrate with Visual Studio, but their EF support was still a bit too buggy for me. That''s why I don''t use their EF components. Yet, I''m currently stuck using a SQLite database in a Win Forms application, and the data structure is complex enough to take forever for me to code up all reading/writing structures myself.
<Addition: May 21st, 2012>
I''ve done some additional experimentation on an Win XP SP3 virtual machine with VS 2010 Pro and found the following. After running the new System.Data.SQLite installer, I ran the installer for the design-time components that was placed in the bin directory.
* The first time I ran it, I got a pop-up telling that the Confirm option wasn''t enable so it failed.
* Then I ran it from the command line as: Installer -Confirm True
** This time it didn''t say anything about failing, but I did go over the command line to find that towards the end it said that no changes were made because the What If option enabled.
* This time I ran: Installer -Confirm True -WhatIf False
** This added System.Data.SQLite Database File as an option for my DataSources when creating a new database connection. Yet, when I select a database or created a new one to enter the Database Path, all pop-ups used for inserting the database connection close.
** I tried inserting the path do a SQLite database manually when creating a new connection, and VS froze when I tested connection.
That''s pretty much where I''m at with this right now.
推荐答案
这篇关于使用新的System.Data.SQLite获取实体框架模型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！