Community discussion forum

Enterprise Applications in ADO.NET

• • Reply

  4 years ago

  by gayan

  Gayan Perera

  -, United States

  Joined 4 years ago

  i'm developing a 3 tier Application using C#.NET.my PL and BLL will be hosted in cleint hosts where as the DAL will be hosted in a server.
  

  
  can you please tell me wether to use Dataset or Custome Entites classes as the return values from my Data Access Layer to the upper layer. and please tell me whay is the best thing to use as the Data transfer objects between tiers in .NET.
  

  
  thank you.

  Report abuse
• • Reply

  4 years ago

  by jmcilhinney

  John McIlhinney

  Sydney, Australia

  Joined 4 years ago

  DataSets are the standard way of storing data retrieved form data sources in .NET, and in fact if you want to deal with Web Services then you must use DataSets.  There is a lot of functionality built into .NET to handle DataSets so they are probably your best bet, unless you have a compelling reason to do otherwise.  I'm not sure whether they will help at all or not, but you may like to read the following articles:
  

  
  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/bdadotnetarch001.asp
  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/designnetapp.asp

  Report abuse
• • Reply

  4 years ago

  by gayan

  Gayan Perera

  -, United States

  Joined 4 years ago

  thanks guru but i heard that Dataset take more processing and memory when serializing into XML than custom entities.
            another prob is dataset represent the data in a relational fashion. but if u use custom entities we can represent the data in an object oriented fashion.
  

  
  can please comment on those issues
  

  
  thank  you.
  

  Report abuse