How to connect to existing database? .NET Core API and SQL Server 2012

Question

I am struggling on how to connect existing database with existing data to my API project. And also how do I know if I'm already connected? I am using .NET Core 1.1 and my database is SQL Server 2012.

appsettings.json :

{
  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Default": "Debug",
      "System": "Information",
      "Microsoft": "Information"
    }
  },
    "ConnectionStrings": {
      "DefaultConnection": "Server=.\\SQLEXPRESS;Database=;User Id=sa;Password=Passw0rd;MultipleActiveResultSets=True"
    }
  }
}

Startup.cs - ConfigureServices

public void ConfigureServices(IServiceCollection services)
{
    // Add framework services.
    services.AddMvc();
    
    services.AddDbContext<DefaultConnection>(
    options => options.UseSqlServer(
    Configuration.GetConnectionString("DefaultConnection")));
}

I am following this tutorial but it seems that this creates new database. http://www.mithunvp.com/aspnet-core-web-api-entity-framework-core/

Would highly appreciate all your comments/solutions/suggestions.

Using a '.' is the same as using localhost - not sure if that is causing you issues? Is SQL installed on the machine you are trying to connect with? Either way, I would specify the server name instead of '.' — Keith
– Keith, Commented Sep 5, 2017 at 9:05
Change Server=.\\SQLEXPRESS to Server=COGSOL-LAP13... Read How to Ask, explain very explicitly what is and isn't working ("I am struggling" is not a proper problem description), and show what you have tried. — CodeCaster
– CodeCaster, Commented Sep 5, 2017 at 9:07
If you're not sure about your connection string format, check out connectionstrings.com. That site will be a huge help with ensuring that all the parameters are set properly. — code4life
– code4life, Commented Sep 6, 2017 at 0:19

Community · Accepted Answer · 2024-11-27 12:46:40Z

3

You need to add the name of the database into that line :

 "DefaultConnection": "Server=COGSOL-LAP13;Database=DATABASENAME;UserId=sa;Password=Passw0rd;MultipleActiveResultSets=True"

And as CodeCaster comment says, you should use the name of the server too.

edited Nov 27, 2024 at 12:46

CommunityBot

11 silver badge

answered Sep 6, 2017 at 0:02

Theo

4738 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

How to connect to existing database? .NET Core API and SQL Server 2012

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related