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?
AlonQ
Member
21 Points
61 Posts
Questions about BLL and having 2 DAL
Dec 04, 2012 04:28 PM|LINK
Hey everyone...
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?
sh_asp.net
Member
59 Points
20 Posts
Re: Questions about BLL and having 2 DAL
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 :)
Sheik.