CODEWITHSUNDEEP
uwpentity-framework-core
Marks
Marks

Reputation: 41

Error using Entity Framework Core with SQL Server on UWP app

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?

Upvotes: 1

Views: 1296

Answers (2)

PatriceBG
PatriceBG

Reputation: 47

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.

Upvotes: 3

Marks
Marks

Reputation: 41

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

Upvotes: 2

Related Questions