Appendix

A-1. Installing SQL Server 2016 Developer

Visual Studio comes with a basic version of SQL Server called SQL Server Express LocalDB. LocalDB is a great database to use for prototyping and basic development since it requires no configuration and does not require administrative rights on the computer to run. Unfortunately, LocalDB also has some limitations such as the following:

  • LocalDB runs under your user account. This limitation may make it difficult to test application deployment scenarios where the application and SQL Server are running under different service accounts.

  • LocalDB shuts down when not in use. LocalDB is a user process and not a Windows service. If you use LocalDB with the full version of Internet Information Services, ...

Get ASP.NET Core Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.