Error using Entity Framework Core with SQL Server on UWP app

entity-framework-core uwp


I have a data project (.net standard 2.0) with Entity FrameWork Core 2.0.2 and SQL Server, Sqlite and PostgreSql providers.

I have more three projects for presentation in Windows Forms, WPF and UWP.

When I run the Windows Forms and WPF, Entity Framework Core works fine for all providers, but when I try to run the SQL Server provider on UWP, it throw this

enter image description here

The error occurred in the method EnsureCreatedAsync:

public async Task InitDataBaseAsync(DataBaseConfig config)
   using (var db = GetDataContext(config))
      // Postgresql and Sqlite do not throw exception in UWP.
      await db.Database.EnsureCreatedAsync();

I checked the three platforms connection string, the connection are the same.

Has anyone experienced this problem?

4/18/2018 8:33:36 AM

Accepted Answer

I changed the connection string to use TCP/IP


Data Source=xpt/SqlServerExpress;Initial Catalog=gestao_eficaz;User ID=sa;Password=somePassword


Data Source=,1433;Initial Catalog=gestao_eficaz;User ID=sa;Password=somePassword

It is also necessary to enable the TCP / IP connection in the sql server

Now works !!!

5/6/2018 6:00:54 PM

Popular Answer

Enabling and starting the SQL Browser service fixed the problem for me. That avoids messing around with IP addresses and TCP ports.

Integrated security would not work, however, I had to revert to SQL User ID and password.

Related Questions


Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow