Menu
What is the main difference between Initial Catalog and Database Keyword in a connection string?
942
Initial Catalog is the name of the database to be used by the connection string, which is located on the server that was specified in the Data Source part of the connection string.
Database name is a value of SqlConnectionStringBuilder. InitialCatalog property.
A connection string provides the information that a provider needs to communicate with a particular database. The Connection String includes parameters such as the name of the driver, Server name and Database name , as well as security information such as user name and password.
They are synonymous - you can use either one. That is - as far as the framework is concerned, they are the same. I've been googlearching for the reason for the range of equivalent keywords in the connection strings.
The only difference is the name.
These can be used interchangeably.
See the documentation of SqlConnectionStringBuilder.InitialCatalog, under remarks:
This property corresponds to the "Initial Catalog" and "database" keys within the connection string.
(emphasis mine)
117
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
