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 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 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 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