.net SqlClient and .NET CORE Web API connection string

Question

Is it me or tis there a different way that sqlclient and .net core uses the connection string.

example old client:

var connectionString = "Data Source=SQLSERV1\\SQLSERV1;Initial Catalog=mydb;User ID=myuser; Password=mypass;";
using (SqlConnection conn = new SqlConnection(connectionString))
{
    ....etc

Code works fine, results come back from this sql client query.

Now in .NET CORE web API :

appsettings.json

"Data": {
    "DefaultConnection": {
        "ConnectionString": "Data Source=SQLSERV1\\SQLSERV1;Initial Catalog=mydb;User ID=myuser; Password=mypass;"
    }
}

Startup.cs

public void ConfigureServices(IServiceCollection services)
{
    services.AddApplicationInsightsTelemetry(Configuration);

    services.AddMvc()
        .AddJsonOptions(config =>
        {
            config.SerializerSettings.ContractResolver = new CamelCasePropertyNamesContractResolver();
        });
    services.AddDbContext<MW_MereSysContext>(options => options.UseSqlServer(Configuration["Data:DefaultConnection:ConnectionString"]));

when i try to nav to the url in my browser i get:

An unhandled exception occurred while processing the request.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

So how is it that sqlclient sees the server fine, but .net core cannot? is it the way it process the string i.e the fact its on a domain?

you mean the sql services in services? looks fine. Im running both a the moment to test. — lemunk
– lemunk, Commented Dec 21, 2016 at 12:27
I used this in my project and it worked. Server=servername; initial catalog=db;user id=dbuser;password=password;MultipleActiveResultSets=True;App=EntityFramework — Ahmar
– Ahmar, Commented Dec 21, 2016 at 12:54
I wouldn't think you need to escape the backslash (\\) in the appsettings.json file. — Crowcoder
– Crowcoder, Commented Dec 21, 2016 at 12:55

Todd Palmer · Accepted Answer · 2018-05-17 18:53:34Z

0

Maybe it's a syntax problem:

Data Source=Server\\Instance

If you have a default instance, then, only use:

Data Source=Server

edited May 17, 2018 at 18:53

Todd Palmer

1,10210 silver badges20 bronze badges

answered May 17, 2018 at 18:05

German Impa Mendia

11 bronze badge

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

1 Comment

Matt Over a year ago

Yes remove the two ‘\\’ and only use one ‘\’

Collectives™ on Stack Overflow

.net SqlClient and .NET CORE Web API connection string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related