Data Access and ObjectDataSource Control

Re: How to build DAL

albarossa — Mon, 22 Jun 2009 04:36:58 GMT

http://aspalliance.com/914

Re: How to build DAL

ajaypathak — Mon, 22 Jun 2009 03:21:04 GMT

can u please send me some links or document links ?

Re: How to build DAL

vinz — Mon, 22 Jun 2009 02:57:11 GMT

ajaypathak:
now i want to build a DAL layer that can be used in my application.

Try to look at this simple example:

Creating a Simple Data Access Framework in ASP.NET

Re: How to build DAL

malcolms — Sun, 21 Jun 2009 01:17:18 GMT

Yes! I used datasets in ASP.NET 2.0 but when LINQ to SQL came out, I moved to that. Since then I have started using the Entity Framework, which does have some limitations, but overall it is a good product.

Here's a link to the EF website:

http://msdn.microsoft.com/en-us/library/aa697427(VS.80).aspx

There's also NHibernate which is an open source mature product:

https://www.hibernate.org/343.html

And another good option is LLBLgen:

http://www.llblgen.com/

Re: How to build DAL

albarossa — Sat, 20 Jun 2009 18:45:44 GMT

I use TableAdapters and DataTables, there is plenty of information on the Web for how to implement.

Re: How to build DAL

whighfield — Sat, 20 Jun 2009 17:52:51 GMT

There are lots to choose from http://sharptoolbox.com/categories/object-relational-mappers

How to build DAL

ajaypathak — Sat, 20 Jun 2009 16:39:01 GMT

i am using visual studio 2005 and sql server 2005. now i want to build a DAL layer that can be used in my application.

is there any free open source tools available for gerating data classes from sql server 2005. ?