gkumardd

 Profile Answers by gkumardd 

• May 20th, 2009

 

The MS Data Access Block is the component in DAL which can be used to derive all data communication code with in your application. The connection string, and the end database need to be specified in the app.config file under the Data Layer. You have the Enterprise Design tool to code your app.config file accordingly.
Example: Suppose your system is designed to use SQL server 2005, and at later point of time, the database may migrate to Oracle. If this is the given condition, and you plan to code yourself, then you must code all data communications twice each for SQL and Oracle. BUt by using DAL, you can avoid all this stuffs and the DAL can do all such coding stuffs for you depending on the value in the app.config file.