2
votes
3answers
408 views

DAL vs BLL functions' return types

Here is how I see the main differences between the DAL and the BLL: The DAL directly query the database. The DAL doesn't create new information. It may execute complex sql requests, joining several ...
0
votes
3answers
364 views

How do I create a simple yet complex business layer?

I'm working with a fairly complex web application. It's split up into the following layers: Presentation - HTML Service layer - A REST and SOAP API communicating with the business layer Business ...
22
votes
4answers
3k views

Do stored procedures violate three-tier separation?

Some colleagues of mine have told me that having business logic in stored procedures in the database violates the three-tier separation, since the database belongs to the data layer whereas stored ...
0
votes
6answers
2k views

When to use the 3 layers model?

I was recently exposed to the three layer model (DAL,BL,UI). Someone told me I should ALWAYS work with this model. I have a medium project that I'm starting and I have doubts whether I should build ...
3
votes
3answers
218 views

What are the pros and cons of implementing this requirement in different layers?

I have a CRUD app for <DomainObject>s. They are persisted in a database. There is a new requirement: keep track of the <DomainObject>s that have been created since the app was opened, ...