13 reputation
3
bio website
location Belgium
age 26
visits member for 2 years, 3 months
seen Jan 24 at 23:12

Jan
19
answered DAL vs BLL functions' return types
Jan
19
comment DAL vs BLL functions' return types
Kevin: no. So you would vote for doing the mapping in the DAL...
Jan
4
comment DAL vs BLL functions' return types
I mean: so the mapping is done in the BLL, but the BLL functions that really apply a complex business logic can use those "more consumable objects"...
Jan
4
comment DAL vs BLL functions' return types
Jon Raynor: and what about having for example a function DataTable DAL.getPortfolio(int portfolioId), then a BLL.Portfolio BLL.getPortfolio(int portfolioId) calling the DAL function, and then other functions BLL.applySomeLogic(BLL.Portfolio parameter)?
Jan
3
awarded  Scholar
Jan
3
accepted DAL vs BLL functions' return types
Jan
3
comment DAL vs BLL functions' return types
Well, I saw some solution having DAL and BLL projects, with all the same structure, but simply replacing the SQL queries of the DAL project with Linq. So you would say it's not a DAL anymore? About the stored procedures, yes, you mean using Transact-SQL... I thought about it. I'm used to Oracle PL/SQL and thought I didn't have time right now to explore the difference between the two. I must admit having long strings with parameters as queries is not very nice, but it does the job for the moment.
Jan
3
comment DAL vs BLL functions' return types
Ok, I was a bit confused due to the general usage of Linq2sql, which automatically maps a class for each table in the database, and allow a direct mapping of the result from Linq queries into some personalized class. As a result, it seems to me that projects using this technology have a DAL whose functions all return "personalized" classes instead of DataTable/DataSet. I'm not using Linq2sql for several reasons. In contrast, my DAL creates SqlCommand objects with pure old SQL queries, and only return DataTable objects, which are not mapped into any other class before reaching the BLL...
Jan
3
awarded  Student
Jan
3
awarded  Editor
Jan
3
revised DAL vs BLL functions' return types
added 33 characters in body
Jan
3
asked DAL vs BLL functions' return types