Generic Data Access Layer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TarTar - 01 Aug 2007 21:49 GMT

Hello,

I need to feed UI controls (DataList, GridView etc) using XML or SQL Server.
What would be a "good practice" to access these two types of data sources?
Is ObjectDataSource a good choice?

I would appreciate any links to websites describing a Data Access Layer
suitable for various types of data sources.

Thanks,
Leszek

Reply to this Message

dotnet_coder - 03 Aug 2007 02:22 GMT

> Hello,
>
[quoted text clipped - 7 lines]
> Thanks,
> Leszek

Try Microsoft's Enterprise Library: http://msdn2.microsoft.com/en-us/library/aa480453.aspx

Reply to this Message

Cubaman - 03 Aug 2007 14:09 GMT

> Hello,
>
[quoted text clipped - 7 lines]
> Thanks,
> Leszek

You should do all that operations on a diferent layer, and pass arrays
of bussines objects to UI. In your dal layer, you make the proper
decitions about the datasource.
Enterprise library is a good starting point ;)
Best regards

Reply to this Message

TarTar - 03 Aug 2007 16:16 GMT

Thanks a lot!
The Microsoft's Enterprise Library looks good.

In the meantime I have found the following sample application:
"Small Business Web Site - Starter Kit"
http://www.asp.net/downloads/starter-kits/small-business

They use both SQL and XML data sources using custom providers that follow
the Provider pattern. Then they feed ObjectDataSource controls with the
collections generated by the providers.

Is this starter kit good? Did anyone try to use it in practice?

Thanks,
Leszek

>> Hello,
>>
[quoted text clipped - 15 lines]
> Enterprise library is a good starting point ;)
> Best regards

Reply to this Message

Generic Data Access Layer

Free Magazines