Architecture help
-
This is the New Development for our product. our requirement is, DAL -- can be Ms Acccess or sql server [later may be cloud(azue db)] How can i swich between this db based on web.config so please suggest best method , I can check in BLL , Is this a right method? Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com
-
This is the New Development for our product. our requirement is, DAL -- can be Ms Acccess or sql server [later may be cloud(azue db)] How can i swich between this db based on web.config so please suggest best method , I can check in BLL , Is this a right method? Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com
Having multiple connections in your configuration file is easy -
A SERVER1 True A SERVER1 TrueYou can make the choice of connections in the DAL or the BAL layer. I would think DAL is better because then the BAL is completely free from the decision of which database to connect to - which is the way it should be. A pattern called the Enterprise Library supports multiple types of databases via some patterns.
-
This is the New Development for our product. our requirement is, DAL -- can be Ms Acccess or sql server [later may be cloud(azue db)] How can i swich between this db based on web.config so please suggest best method , I can check in BLL , Is this a right method? Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com
You can do it by using n-tier architecture with interface and abstract class.
Farogh Haider Web developer