Switching to SQL Server

Although localDB proved itself to be a great development choice, it's not a good idea to use it in production as well. That's why we'll replace it with SQL Server. As for the chosen edition, we can either go for Express, Web, Standard, or Enterprise, depending on what we need and/or can afford.

For the sake of simplicity, we'll use SQL Server 2017 Express Edition, which can be downloaded for free from https://www.microsoft.com/en-us/sql-server/sql-server-editions-express.

Needless to say, we need to install it on a machine that is reachable from our web server via a Local Area Network (LAN) or within the web server itself, although this is definitely not a recommended choice; both IIS and SQL Server are resource-intensive; ...

Get ASP.NET Core 2 and Angular 5 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.