Mastering ASP.NET Web API

Connection strings and IProductRepository in startup

A connection string is a must when working with database; it contains the location of the database server, database name, credentials to access the database, and other information.

ASP.NET Core stores all configuration/connection data in JSON files known as appsettings.json. Copy the following connection string in the appsettings.json file:

    { 
      //Others removed for brevity 
      "connectionStrings": { 
        "AdvWorksDbConnection": "Server=.\\sqlexpress;initial         catalog=AdventureWorks2014;Trusted_Connection=True;        MultipleActiveResultSets=true" 
      } 
    } 

Now that we have provided the connection string (AdvWorksDbConnection) and wrote IProductRepository to access the database, we will need to configure (participate ...