Error using Entity Framework Core with SQL Server on UWP app

Question

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

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?

Is the server running on the same machine as the app? UWP has some restrictions regarding this... — thezapper
– thezapper, Commented Apr 17, 2018 at 12:23
Have you checked the Enterprise Authentication option In the Capabilities tab? — Nico Zhu
– Nico Zhu, Commented Apr 18, 2018 at 8:32
I had not checked, but after checking the error persist When I use data project on windows forms work normally — Marks
– Marks, Commented Apr 19, 2018 at 1:58
The inner exception show : The operation completed successfully and stacktrace >> at System.Data.SqlClient.SNI.SSRP.GetPortByInstanceName(String browserHostName, String instanceName) at System.Data.SqlClient.SNI.SNIProxy.CreateTcpHandle(DataSource details, Int64 timerExpire, Object callbackObject, Boolean parallel) — Marks
– Marks, Commented Apr 19, 2018 at 2:00

PatriceBG · Accepted Answer · 2019-01-06 08:29:27Z

3

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.

answered Jan 6, 2019 at 8:29

PatriceBG

474 bronze badges

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

Comments

Marks · Accepted Answer · 2018-05-06 18:00:54Z

2

I changed the connection string to use TCP/IP

Before

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

After

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

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

https://stackoverflow.com/questions/2388042/connect-to-sql-server-2008-with-tcp-ip

Now works !!!

answered May 6, 2018 at 18:00

Marks

415 bronze badges

Collectives™ on Stack Overflow

Error using Entity Framework Core with SQL Server on UWP app

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related