Database First with EF7 in a Universal App

Question

I have a Sqlite database that I want to use in my UWP application With EF7, How can I create model from database with EF7?

Possible duplicate: http://stackoverflow.com/questions/29300777/is-there-an-entity-framework-7-database-first-poco-generator — Rowland Shaw, Mar 07 '16 at 14:36

score 3 · Accepted Answer · answered Mar 08 '16 at 11:23

3

You can install SQL Server Compact/SQLite Toolbox and create model from database SQL Server Compact/SQLite Toolbox DLL

answered Mar 08 '16 at 11:23

je30ca

score 0 · Answer 2 · edited May 23 '17 at 11:58

0

According to this question/answer you should be able to create poco classes from an existing database. However, I have not tried this myself.

To summarize ErikEJs answer:

Get nuget packages EntityFramework.Commands and EntityFramework.MicrosoftSqlServer.Design
Run from the package manager console: Scaffold-DbContext '<connectionString>' EntityFramework.MicrosoftSqlServer or *dnx ef dbcontext scaffold '<connectionString>' EntityFramework.MicrosoftSqlServer

edited May 23 '17 at 11:58

Community

answered Mar 07 '16 at 14:29

Indregaard

My databse is Sqlite not sqlserver – Maryam Mar 08 '16 at 10:36
Ok my bad. I have never used Sqllite ut could there be equivalent packages available? Have you tried fetching EntityFramework.Sqlite.Design and running the command with "xxxxxxxxxx EntityFramework.Sqllite" instead? – Indregaard Mar 08 '16 at 10:43
it doesn't install in uwp application – Maryam Mar 08 '16 at 11:19
=( Check out user2906881 answer, it looks promising – Indregaard Mar 08 '16 at 11:33

2 Answers2