Maintaining and Changing the ConnectionString across the Application and Business Components. RRS feed

  • Question

  • In our application , the database transactions are carried out by the Business Component (BO) which use the  Microsoft Enterprise libraries.


    In general, the BO reads the connection string from the calling application's Web.Config file. But in our case, we intend to change the connection string and modify the code to create the Database Object (i.e. Database objData = DatabaseFactory.CreateDatabase("ConnectionString")  ) with the modified connection string.


    For solving this purpose, an encrypted token (combination of Username, Password and DataBase Name) will be created by the BO when the user first logs on to our application. This token will be maintained in the user session. While making calls to the BO, the calling application will pass this token. The BO will know how to decrypt this token and create the Database Object.


    We are looking for a better solutions/approach to achieve our objective.Your opinion's and suggestion's are welcome.



    Friday, November 2, 2007 2:03 PM