Use Entity Framework with SQL Server in UWP

Question

I am starting to learn UWP platform. In first steps I want to do simple application (bookshop). Unfortunately, I got stuck on steps: how to use Entity Framework with SQL Server in UWP?

First I was using

Install-Package Microsoft.EntityFrameworkCore.SqlServer

but I got lots of conflicts (ex. System.Threading.Thread 4.3.0 error, or One or more packages are incompatible with UAP,Version=v10.0 (win10-x86).).

After that, I was trying add a classic dll to project (and install ef), but... classic library are incompatible with UWP...

Do you have any idea how to use EF with SQL Server in UWP ? I don't want to use sqlite...

Someone maged to connect using TCP/IP stackoverflow.com/questions/49869499/… — exaulo
– exaulo, Commented Jul 18, 2019 at 0:13

Ken Tucker · Accepted Answer · 2016-12-18 20:27:54Z

5

Sorry you can only use the entity framework SQLite provider with UWP.

answered Dec 18, 2016 at 20:27

Ken Tucker

4,1561 gold badge20 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Junius Over a year ago

I have tried to install Install-Package Microsoft.EntityFrameworkCore.SqlServer in my UWP application but encountered the same issues. I guess it's still in infancy stage to use EF Core.SqlServer, but Microsoft.EntityFrameworkCore.SqlLite works.

Sapan Ghafuri · Accepted Answer · 2017-12-16 13:04:39Z

0

The latest version of Windows SDK (Falls Creators Update) will support direct SQL Server connection. Have a look at it here: https://learn.microsoft.com/en-us/windows/uwp/data-access/sql-server-databases

answered Dec 16, 2017 at 13:04

Sapan Ghafuri

5553 silver badges13 bronze badges

1 Comment

Sam Hobbs Over a year ago

The question asks about EF and the article says nothing about EF. If I posted a short answer like that then I would get voted down.

Trevy Burgess · Accepted Answer · 2018-08-13 21:59:03Z

0

To use SQLite in your UWP app, you need to target Windows 10 Fall Creators Update (10.0; Build 16299)

The NuGet packages are:

Microsoft.EntityFrameworkCore.Sqlite
Microsoft.EntityFrameworkCore

answered Aug 13, 2018 at 21:59

Trevy Burgess

4995 silver badges13 bronze badges

Comments

Кирилл Фазлыев · Accepted Answer · 2022-05-31 12:32:09Z

0

I successfully connected ms sql, entity framework to uwp. They work together.

To connect, I used an additional project "csproj" with the standard .NetStandard 2.0 in the same solution. I also used "Microsoft.EntityFrameworkCore.SqlServer" in this project, not in the UWP project. It was just class library

edited May 31, 2022 at 12:32

answered May 31, 2022 at 12:29

Кирилл Фазлыев

33 bronze badges

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Use Entity Framework with SQL Server in UWP

4 Answers 4

1 Comment

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related