asp.net core connection string for all databases in detail.

SQLITE

To make an SQLite database connection string, we just need to know the databse filename, set using the paramenter Filename.

Steps :

---

SQL Server

To connect to an SQL Server database, we need to know all these pieces of informations given.

• Server name
• Database name
• Security informations such as username & password or if we pass the currently logged-on user's credentials automatically.
  We specify this information in a connection string

Steps :