Go SQL Server connection string keyword aliases

Transferred from: http://stackoverflow.com/questions/3077412/ What-is-the-difference-between-trusted-connection-and-integrated-security-in-a-c

-----------------------------------------------

In. Net, there are a class called SqlConnectionStringBuilder that's very useful for dealing with SQL Server Conne ction strings using Type-safe properties to build up parts of the string. This class keeps a internal list of synonyms so it can map from one value to another:

+----------------------+-------------------------+| Value | Synonym |+----------------------+-------------------------+| App | Application Name | | Async | Asynchronous Processing | | Extended Properties | AttachDbFileName | | Initial file name | AttachDbFileName | | Connection Timeout | Connect Timeout | | Timeout | Connect Timeout | | language | Current language | | Addr | Data Source | | Address | Data Source | | Network Address | Data Source | | Server | Data Source | | Database | Initial Catalog | | Trusted_Connection | Integrated Security | | Connection Lifetime | Load Balance Timeout | | NET | Network Library | | Network | Network Library | | PWD | password || Persistsecurityinfo | Persist Security Info | | UID | User ID | | user | User ID | | Wsid | Workstation ID |+----------------------+-------------------------+

(Compiled with help from Reflector)

There is other similar classes for dealing with ODBC and OLE DB connection strings, but unfortunately nothing for other DA Tabase Vendors-i would assume the onus is on a vendor's library to provide such an implementation.

Go SQL Server connection string keyword aliases