Databases in Razor websites

At the end of this topic, you should be able to:

• Describe what is meant by a "connection string"
• Identify the parts of a typical connection string value for connecting to an MS-SQL database
• Describe the purpose of the name, connectionString, and providerName attributes of the <add /> tag in a web.config file's <connectionStrings> section
• Create connection string entries in the web.config file
• Access SQL Server databases in Razor pages to execute SQL statements for Create/Read/Update/Delete operations
• Develop a single-page Razor form to manage Create/Read/Update/Delete operations