Where should I exclude and select information BL or DL?

Posted by MRFerocius on Stack Overflow See other posts from Stack Overflow or by MRFerocius
Published on 2010-04-03T01:10:49Z Indexed on 2010/04/03 1:13 UTC
Read the original article Hit count: 320

Filed under:

business-logic

|

dal

|

c#

|

best-practices

|

code-review

Hi guys;

I have another conceptual question. Suppose I have a Data Layer and a Bussines Layer. I have on my data base for example Customers and those customers has an assigned Vendor:

Customers(customerID, customerName, customerAddress, vendorID)
Vendors(vendorID, vendorName, vendorAddress)

Now suppose my Vendor logs into my web application and wants to see all his customers:

a) Should I use my Datalayer method and there find his customers on the query?

b) Should the data layer return all the customers and on the Buissnes Layer filter that vendor ones?

Is B even a good approach because is the one I want to use.... Is it correct?

Thanks in advance!!!

© Stack Overflow or respective owner

Related posts about business-logic

Project structure: where to put business logic

as seen on Programmers - Search for 'Programmers'
First of all, I'm not asking where does business logic belong. This has been asked before and most answers I've read agree in that it belongs in the model: Where to put business logic in MVC design? How much business logic should be allowed to exist in the controller layer? How accurate is "Business… >>> More
Business Logic Layer Pattern on Rails? MVCL

as seen on Stack Overflow - Search for 'Stack Overflow'
That is a broad question, and I appreciate no short/dumb asnwers like: "Oh that is the model job, this quest is retarded (period)" PROBLEM Where I work at people created a system over 2 years for managing the manufacture process over demand in the most simplified still broad as possible, involving… >>> More
Does business logic belong in the service layer?

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a set of classes, namely, a data transfer object, a service implementation object, and a data access object. I currently have business logic in the service implementation object; it uses the dao to get data to populate the dto that is shipped back to the client/gui code. The issue is that… >>> More
Transforming Business Logic into Web Services Using DB2 9.5 and IBM Data Studio

as seen on Internet.com - Search for 'Internet.com'
Learn how to take business logic such as stored procedures, functions, or SQL statements and turn them into a Web service. >>> More
SQL Server 2008: CASE vs IF-ELSE-IF vs GOTO

as seen on Stack Overflow - Search for 'Stack Overflow'
I have some rules in my application and I have written the business logic of that rules in my procedure. At the time of creation of procedure I came to know that CASE statement won't work in my scenario. So I have tried two ways to perform same operations (using IF-ELSE-IF or GOTO) shown as below… >>> More

Related posts about dal

How should I provide access to this custom DAL?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm writing a custom DAL (VB.NET) for an ordering system project. I'd like to explain how it is coded now, and receive some alternate ideas to make coding against the DAL easier/more readable. The DAL is part of an n-tier (not n-layer) application, where each tier is in it's own assembly/DLL. The… >>> More
DAL without web2py

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using web2py to power my web site. I decided to use the web2py DAL for a long running program that runs behind the site. This program does not seem to update its data or the database (sometimes). from gluon.sql import * from gluon.sql import SQLDB from locdb import * # contains # db = SQLDB("mysql://user/pw@localhost/mydb"… >>> More
How to use bll, dal and model?

as seen on Stack Overflow - Search for 'Stack Overflow'
Dear all, In my company I must use a Bll, Dal and model layer for creating applications with a database. I've learned at school that every databasetable should be an object in my model. so I create the whole model of my database. Also I've learned that for every table (or model object) there should… >>> More
Empty data problem - data layer or DAL?

as seen on Stack Overflow - Search for 'Stack Overflow'
I designing the new App now and giving the following question a lot of thought. I consume a lot of data from the warehouse, and the entities have a lot of dictionary based values (currency, country, tax-whatever data) - dimensions. I cannot be assured though that there won't be nulls. So I am thinking: create… >>> More
MVC + 3 tier; where ViewModels come into play?

as seen on Programmers - Search for 'Programmers'
I'm designing a 3-tiered application using ASP.NET MVC 4. I used the following resources as a reference. CodeProject: MVC + N-tier + Entity Framework Separating data access in ASP.NET MVC I have the following desingn so far. Presentation Layer (PL) (main MVC project, where M of MVC was moved… >>> More