How to return data from the DataLayer to Business layer?

Question

0.00/5 (No votes)

See more:

Hi,
In my project which is in layered architecture , the selected data from database is passed from the datalayer to business layer through list type of business object class. I have two table in the DataBase student and staff. Two classes in the bussiness object layer also, student and staff.The DataLayer is returning List of custom class type like

C#

List <student>  and List<staff>

to bussiness layer after querying and selecting the data from the database. In a scenario i need to join and get the data from the two tables form the database and pass the data from datalayer to business layer. How can i pass a list of data from the datalayer? Which is the best method?

Thanks,
Amrutha Nair.

Posted 31-Jul-14 0:33am

AmruthaNair

Updated 31-Jul-14 0:43am

_Amy

v3

Add a Solution

Comments

Ziee-M 31-Jul-14 9:20am

Hi, i think you have an issue in your model since you have student and stuff class in both DataLayer and buisness layer !
I think your real issue is how to do it best rather then how.
First, there is no "best solution" here ! it really depends on your needs. using an ORM or classic sql also have an impact on your global architecture.
You may read this article, althought its not exactly your need because the writer is using dataTable to pase Data beetwen layers, but, you will learn a lot and it will help you make your choice.

http://www.codeproject.com/Articles/493389/Four-ways-of-passing-data-between-layers

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Answer 1 · 2014-07-31T00:42:00

First of all, that should probably be out, not ref.

Second, you can declare and return a type containing the two lists.

Third, you can declare a generic Tuple and return an instance of that:

See What is the best way to return two lists in C#?[^]

OR

You could put them all in a static Dictionary. See Return multiple list[^].

--Amy