Best practice for n-tier data access in .NET 2.0

16 Mar 2006 10:42 PM

Paul Aspinall

Hi
I've previously constucted my .NET 1.1 data access, via a Data Access Layer
(DAL), that was all in code.

Now that I have access to the DataSet control in .NET 2.0, I'm looking for
opinions or pointers into how to implement a DAL under .NET 2.0. Is it best
to use controls or code?? Are there any best practice code samples around?

Thanks

Paul

17 Mar 2006 6:20 AM

Michael Nemtsev

Hello Paul,

You need to find differences between ADO 1.1 and ADO 2.0 that allow to impove
you DAL
see http://www.dotnetbips.com/articles/displayarticle.aspx?id=47 and http://msdn.microsoft.com/msdnmag/issues/05/04/ADONET/default.aspx

BTW, there are no changes in building DAL components with .net 2.0, all changes
are specific to language (for example using generic to create type-safe collection,
dataset binary seriliazation and etc)

PA> Hi
PA> I've previously constucted my .NET 1.1 data access, via a Data
PA> Access Layer
PA> (DAL), that was all in code.
PA> Now that I have access to the DataSet control in .NET 2.0, I'm
PA> looking for opinions or pointers into how to implement a DAL under
PA> .NET 2.0. Is it best to use controls or code?? Are there any best
PA> practice code samples around?
PA>
PA> Thanks
PA>
PA> Paul
PA>
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

17 Mar 2006 10:05 AM

Cor Ligthert [MVP]

Paul,

In fact there is in mainlines nothing changed. If you had used in 1.1 the
component to create your DAL with a strongly typed dataset, than you would
have had almost the same effect as is now with 2.0, which does that
automaticly for you.

A pity was that all documentation in 1.1 was showing to do it direct on the
form instead on that so nice component in 1.1.

Just my thought,

Cor

19 Mar 2006 3:17 PM

luxspes

I think you should also try object relational mapping, with something
like NHibernate (http://www.hibernate.org/343.html)

Paul Aspinall wrote:
Show quoteHide quote

> Hi
> I've previously constucted my .NET 1.1 data access, via a Data Access Layer
> (DAL), that was all in code.
>
> Now that I have access to the DataSet control in .NET 2.0, I'm looking for
> opinions or pointers into how to implement a DAL under .NET 2.0. Is it best
> to use controls or code?? Are there any best practice code samples around?
>
> Thanks
>
>
> Paul
>
>

19 Mar 2006 6:48 PM

Triax

Or EasyObjects, if you are using the Enterprise Library...

--
EasyObjects.NET: The O/RM for the Enterprise Library
http://www.easyobjects.net

Show quoteHide quote

"luxspes" <m*@me.com> wrote in message
news:%23N7DMh2SGHA.4976@TK2MSFTNGP11.phx.gbl...
>I think you should also try object relational mapping, with something like
>NHibernate (http://www.hibernate.org/343.html)
>
>
>
> Paul Aspinall wrote:
>> Hi
>> I've previously constucted my .NET 1.1 data access, via a Data Access
>> Layer (DAL), that was all in code.
>>
>> Now that I have access to the DataSet control in .NET 2.0, I'm looking
>> for opinions or pointers into how to implement a DAL under .NET 2.0. Is
>> it best to use controls or code?? Are there any best practice code
>> samples around?
>>
>> Thanks
>>
>>
>> Paul

Thread options