Selected Provider - Choose the database provider from the dropdown menu. In this case, it's going to be SqlServer.
Server Location: This functionality enables you to select the hosting location for your server, either locally on your machine or on a Networked server. Currently, these are the only available options. We will be adding options for the cloud in the future.
Refresh Servers - Update the list of available servers in the selected server location.
SQL Server - Indicate the use of SQL Server as the selected provider with the connection to (localdb)\MSSQLLocalDB.
SQL Server Authentication: This feature allows users to input their credentials to connect to a server.
Username: Enables the user to enter their server username. This is enabled when the SQL Server Authentication is checked.
Password: Enables the user to enter their server password. This is enabled when the SQL Server Authentication is checked.
Use Trusted Server Certificate - This option is used to bypass the full verification process of the server's SSL/TLS certificate, allowing for an easier but potentially less secure connection to the SQL server.
Enumerate Database(s) - This fetches and displays a list of databases.
Database - Specify the name of the target database.
Connection String - Provide the connection string to establish a link to the database.
Test Connection/Connected - Verify or establish a connection by testing it.
Tables/Views - Explore the tables within the connected SQL Server database. The views provide a way to look at data from one or more tables.
Operation Strings - This option is used to check for the Scaffold String and Connection String. The image below shows what you will see when you click that button. This becomes helpful when you are trying to debug database import issues.
