How do I set the connection string at installation :specific data provider?
Well this is quite tricky and interesting. Connection strings are database dependent and different database servers allow connection strings in different formats.
If you are using the database specific provider classes (like those from System.Data.SqlClient or System.Data.OracleClient) then you can generate the connection string easily by taking the specific inputs from the user. For example, if you are using SQL Server and the classes from the System.Data.SqlClient namespace then we can ask user the SQL Server instance name, the user name, password of if he/she is using the Windows Authentication to log in and the database name.
Back
