17
votes
3answers
979 views

Do stored procedures violate three-tier separation?

Some colleagues 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 procedures ...
0
votes
6answers
777 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
147 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, ...