Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 04, 2012 05:10 PM by sh_asp.net
Dec 04, 2012 04:28 PM|LINK
So I have a design issue.... I am currently working on and app that has 2 differente data sources... one from SQLServer and another one is SAP...
The main issue im havin is that some objects charge their data from the 2 different data sources so what I did is create 2 separate DALProjects (one with EF and another one that connects to SAP) and then created a different proyect for the BL, in this proyect
I created a class that handles both DAL and then manipulate them accordingly. Finally I just call the BLL reference in my UI and use the methods I created there....
Is this a good way of doing it or should I try something different?
Dec 04, 2012 05:10 PM|LINK
Use different connection strings
Create a function with Parameter Collection as input
so the function input is connctionstring (here 2 different data sources) and parameter collection (parameter array based on your proc or query)
Only one function is common to all data sources :)