CODEWITHSUNDEEP
asp.netsql-serverdockerlocaldb
Franco Tiveron
Franco Tiveron

Reputation: 2896

Cannot debug locally in Visual Studio with Docker support and Visual Studio provided SQL Server

I have a ASP.NET 5.0 Web API using Entity Framework to access SQL Server. Running (F5) from Visual Studio works fine. The connection string is Server=(localDB)\\MSSQLLocalDB;Database=***;Integrated Security=true

I then add docker support. Now if I debug the app with the Docker profile I get a System.PlatformNotSupportedException: LocalDB is not supported on this platform.

What should I do to make it work?

Upvotes: 2

Views: 646

Answers (1)

ErikEJ
ErikEJ

Reputation: 41799

LocalDB requires named pipes, which is not available in your docker (Linux) environment. Use SQL Server Express instead, and remember to enable TCP/IP protocol for remote connections.

Upvotes: 3

Related Questions