RE: creating Data Access Layer, how?

Tech-Archive recommends: Fix windows errors by optimizing your registry



Braulio,

Do you use the datareaders to populate business objects? If you go with this
approach, how do you handle things like sorting/filter that comes with a
dataset or don't you worry about that?

I'm just curious. I"m on the fence about datasets vs business objects and
this is one of the things that I wonder how others deal with this issue.

Thanks, Dave.

"Braulio Diez" wrote:

Hello,

Ideally you could use the Enterprise Library and datareaders for high
performance.

But if you application is going to hold less than 200 users, and you don't
have quite much time develop boiler plate code, you can base your datalayer
in typed datasets (VS 2005 has a wizard to automate the creation of this
datasets and dataadapters):

http://www.theserverside.net/discussions/thread.tss?thread_id=37108
http://www.15seconds.com/issue/030401.htm

Good luck
Braulio



/// ------------------------------
/// Braulio Díez
///
/// http://www.tipsdotnet.com
/// ------------------------------




"Jeff" wrote:

..NET 2.0

I wonder how a Data Access Layer should be created using best practice!

So if you have a link to an article about this subject then please post it
here

I've heard Microsoft has a special pattern for this, but I have forgotten
it's name, I think the name is something like Data Object Block?? I'm not
sure about that.

Any suggestions?



.



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)
  • 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)
  • 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)
  • Re: Best Practices Question
    ... A separation of business objects from data access layer is highly desired. ... This way, you can focus on pure busiess in BO, without having to worry about ... Dim userObject = New UserClass ...
    (microsoft.public.dotnet.framework.aspnet)