Error using Entity Framework Core with SQL Server on UWP app

entity-framework-core uwp

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

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?

1
1
4/18/2018 8:33:36 AM

Accepted Answer

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 !!!

2
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





Related

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