We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now


Database Mapping as Data Access Layer for Business logic

virdasardar asked
Medium Priority
Last Modified: 2006-11-18

AS we know that during mapping of database to business

logic, We mapped table to class with columns to Properties.

 but if we have complex queries with multiple joins

and "Group By" clause then what is the mapping of this

query to business ligic side plus how we display data

retrieved by query to the user.

How we handle other issues,

Keeping all aboive question in mind how we formed a Data Access Layer at Business Logic side , or what will be design look like.

How many Interfaces or abstract functionality it have.

Will you suggest a design or any good link that further

elobarate this design logic.

Thinks in advance!

Thanks in advance!
Watch Question

Solution Architect
Do not map one table to one class: While a simple approach it is very problematic and I think causes major issues for the design.

Classes model domain abstractions and tables are part of a a relational design - they are different things doing different jobs.

Spend some time modelling the data in a relational database and separate time modellnig domain classes without binding one to the other on a one-to-one basis.

You can then create procedures and views on the database that let you serialise and/or deserialise the objects efficiently.

As a test you have to ask yourself if you are able to search for serialised objects efficiently and if you can't then you have a problem.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.