Question

Datasets, DAO's or DTO?

Asked by: chrisV

Hi Experts,

Can someone please justify to me why you would use a Data Access Object (DAO) or a Data Transfer Object (DTO) instead of a DataTable or a DataSet to transfer objects through different layers/domains or for use as data sources to controls?

i.e. why would you create a class called Customer with a bunch of properties representing the columns in your Customer table of your database and fill it up instead or just sticking the results in a DataTable or Dataset for example?

And I mean if you don't want any special functionality like the dataset has or the ability of having custom functions inside your DAO for example

Thanks a lot, this has been bothering me for ages

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2007-05-28 at 22:42:49ID22598952
Tags

dto

,

dao

,

dataset

Topics

Programming for ASP.NET

,

.NET

,

Programming Languages

Participating Experts
2
Points
125
Comments
5

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. using 'Locate' method on a filtered DAO dataset
    When I use 'Locate' method on a dataset that is not filtered, correct record is returned. However, if I apply a filter to the dataset, 'Locate' returns incorrect record or raises exception 'Record not found'. I use Delphi 5, Recordset is returned by TDAOStoredProc linked to A...
  2. dataTable vs dataset
    What situaltions would you use a datatable over a dataset. Would populating datatables use less memory and resources than a dataset?
  3. DAO in VB.net
    I am trying to use DAO in vb.net.. I know I should use ado but after a days worth of work I am going to stick to DAO. I am having problems making the connection in vb.net can someone help me fix this code to connect to an access database in vb.net using dao. thanks Dim ...
  4. dataset and datatable in vb.net
    can someone clarify the difference between Dataset and DataTable? thanks
  5. DELPHI using DAO
    I have a DELPHI application coded using ADO. i have to change it so that all the database access to be done via DAO. I need a code for the same. The application uses MSAccess database.

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: bele04Posted on 2007-05-28 at 23:07:12ID: 19170354

One advantage, or in my case, the only time I use DAOs is when I need to transfer data among different tiers.  Like for example, I have a client and a server application.  With DAO, I can return only the data that the client requested in a manner that it can understand.  Like when requesting customer data, I can pass a Customer object containing the said data.  It's also easier to maintain both applications this way.  Other than that I just use datatables or datasets.

 

by: AGBrownPosted on 2007-05-29 at 03:49:53ID: 19171240

In general DTOs are just a lot lighter-weight than datasets.If you have a DTO that exposes properties, then you can pass around a single "row" with very little overhead, and you can still databind a List<T> of your DTOs if you want to.

However, if you are looking for true RAD and don't have on ORM tool, then datasets are a lot faster, that is, unless you use the enterprise library data access app block, and a macro to create your DTOs in seconds. So there is a design-time vs run-time efficiency argument.

A third point is that if you are looking for true interopability on your web servies, data sets are generally a bad plan, only .NET clients can understand and use them. Mind you, arguably if you are doing this you might want to do it as XSD-first, and then xsd.exe -> DTOs.

 

by: chrisVPosted on 2007-05-29 at 22:24:08ID: 19177569

Thanks for the answers, very good points. AGBrown can I ask you another?

1. You say In general DTOs are just a lot lighter-weight than datasets.
So is loading a dataReaders content into a DTO "lighter-weight" then loading a dataReaders content into a Dataset or DataTable?
And is one "lighter" then the other to actually travel through Tiers and to databind with?

2. What is "the enterprise library data access app block"? Can I get my hands on it?

Thanks a million to both

 

by: bele04Posted on 2007-05-29 at 23:26:44ID: 19177749

Yes, loading datareaders into a DTo is lighter compared to loading it into a dataset and it is also recommended when you pass data across tiers since there is less data to be passed across different layers in your application which can significantly improve performance.  

The Enterprise Library DAAP is basically a set of classes that helps developers easily use the features in ADO .NET across several types of database like oracle and sql.  In a few words, you code less and have more functionalities.  You can get it here: http://msdn2.microsoft.com/en-us/library/aa480458.aspx

 

by: AGBrownPosted on 2007-05-30 at 07:27:47ID: 19180289

Importantly the DAAP from Ent Lib takes away a lot of the effort in writing the boiler-plate code to use data access storage layers. It also abstracts you away from knowing exactly which database you are using which means you can get closer to being independent of the actual storage mechanism. The original design target was to do all of this without slowing the performance by more than 5% compared to boilerplate code. It takes a minimum of effort to setup, though from the documentation you might think otherwise. The whole enterprise library works really well together to help you do all sorts of common tasks and is well worth a look, not just at the DAAP, though each block basically works on its own without the others (apart from the core blocks).

The DAAP is good for a plug-n-play library which you can use to quickly churn out your DAL code, filling either datasets or other objects in the process. As with all generalised methods it lacks some functionality, such as dealing silently with broken connections etc., but as it comes with the source code you can improve this to suit your needs if necessary.

Even a DataSet is loaded using a DataReader, that isn't necessarily the "heavy" bit. I would recommend getting hold of a copy of Lutz Roeder's Reflector and opening up the DataAdapter's Fill methods, and the SqlCommand objects ExecuteReader, ExecuteNonQuery, ExecuteScalar methods; they all use a datareader. I'm willing to bet that the slow part of filling a dataset or table with a dataadapter is initialising, and the fact that it also contains a lot of logic such as constraint checking. This in itself is something you can turn off by wrapping the dataAdapter.Fill() method with dataTable.BeginLoadData() and EndLoadData.

Serialisation is heavy for a dataset as well, both in performance and bulk. You can easily implement compression on your web services if clients accept it, and write clients to accept compression from web services, so even this might not matter to you.

You may not be serialising though, in which case there will be little difference in passing a DTO and a Dataset/table across tiers. As for databinding, I have never performed performance tests, so I don't know which is faster.

Personally I think what it comes down to is where you think your time constraints are going to be; programming or performance. In a properly layered enterprise application it will take time, but you shouldn't have a major problem, changing from datatables to DTOs. What you are essentially doing is choosing between two Enterprise Patterns for data handling (see Martin Fowlers book). In performance terms, you need to ask if it even matters. If you are only passing around a few datasets over a web service in a day, and your only clients are smart clients you write, then datasets are probably fine. If you are worried about performance, write tests that are specific to your environment and decide that way.

If you do go down the DTO route, I suggest writing a VS macro to help you create them. This is a really good starting point:
http://pluralsight.com/blogs/keith/archive/2006/01/08/17911.aspx

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...