Re: Data Layer architecture

I would be very very thankful if someone with experience could comment on my design. My main goal was to move the sql out of business objects and isolate sql from actual translation of datasets or datareaders to business objects.

Before you introduce extra layers of complexity, read this:
http://grumpyoldprogrammer.myblogsite.com/blog/_archives/2005/5/13/851175.html

Looks like everyone (including me) has to learn that the hard way though. :)

Greetings,
Wessel
.

Relevant Pages

  • Re: Speed comparision between datatable and datareader
    ... I use DataReaders primarily ... in my ASP.NET designs, as DataSets are designed for more stateful ... I prefer to send business objects from the business layer ... This entry into the bonus structure was Quality of Work. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: creating Data Access Layer, how?
    ... I have used both, DataSet and DataReaders. ... About DataReader and custom business objects, ... use custom datasources and custom paging. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: creating Data Access Layer, how?
    ... Do you use the datareaders to populate business objects? ... how do you handle things like sorting/filter that comes with a ... Ideally you could use the Enterprise Library and datareaders for high ... I wonder how a Data Access Layer should be created using best practice! ...
    (microsoft.public.dotnet.framework.adonet)
  • Working with Connection object
    ... will use one or more business objects as well as datareaders (I cannot ... I created a VB class named DataAccess which maintained an ADO ... Connection object and facilitates the creation of recordsets. ...
    (microsoft.public.dotnet.framework.adonet)
  • Working with Connection object
    ... will use one or more business objects as well as datareaders (I cannot ... I created a VB class named DataAccess which maintained an ADO ... Connection object and facilitates the creation of recordsets. ...
    (microsoft.public.dotnet.framework.aspnet)
Loading