how to make my database layer connect to multiple SQL db

Bhanu Pratap Singh

I am using ADO.Net to connect with SQL server, i use my DBLayer to get data from Database and which returns DataTable and Dataset.

In Web API i desealize Datatable to JSOn which i got by calling BAL, and bal calls DAL.

Now the requirement is my WEb Api request will contain a Code in header, this header value will decide which database connect to.

I have a xml file which contains connectionstrings in format

this is the code which lives in HTTPREquest header.

SO the question is am i doing it in right way. or what is the best way to accomplish this task and optimize my code.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.