Get Entity Framework Model with new System.Data.SQLite

Question

0.00/5 (No votes)

See more:

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.

Posted 18-May-12 15:31pm

Francisco T. Chavez

Updated 21-May-12 13:59pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

rasel · Answer 1 · 2012-06-06T20:11:00

Solution 2

Just install the X86 bundle. Then mark the installer as 32 bit with this command:

corflags /32BIT+ /Force Installer.exe
(use vs command prompt)

After that use this command:
installer -confirm true -whatif false -install true

Posted 6-Jun-12 20:11pm

rasel

Ganesan Senthilvel · Answer 2 · 2012-05-18T15:41:00

SQLite provider should be available in VS(Visual Studio). you can run the "Design-Time Configuration" tool from the SQLite.NET menu (in Windows Start menu) to register the provider with VS.

Note that if you're using an Express version of VS, you can't add third-party ADO.NET providers. Nice CodeProject article is available at Using SQLite Embedded Database with Entity Framework and Linq-to-SQL[^]