How to build DAL

Last post 06-22-2009 12:36 AM by albarossa. 6 replies.

Sort Posts:

  • How to build DAL

    06-20-2009, 12:39 PM
    • Member
      497 point Member
    • ajaypathak
    • Member since 03-14-2007, 12:21 PM
    • Indore
    • Posts 181

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

     

    Ajay Pathak
    MVP
    All About ASP.net
  • Re: How to build DAL

    06-20-2009, 1:52 PM
    • Contributor
      7,249 point Contributor
    • whighfield
    • Member since 01-02-2006, 10:37 PM
    • Winterpeg, Manitoba
    • Posts 1,205
    Please mark the most helpful reply/replies as "Answer".

    - William
    http://thefrozencoder.ca
  • Re: How to build DAL

    06-20-2009, 2:45 PM
    • Member
      348 point Member
    • albarossa
    • Member since 04-03-2008, 2:39 PM
    • Posts 68

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

     

  • Re: How to build DAL

    06-20-2009, 9:17 PM
    • Star
      12,601 point Star
    • malcolms
    • Member since 06-12-2008, 4:38 AM
    • Melbourne, Australia
    • Posts 2,069

    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/
    Sincerely,
    Malcolm Sheridan

    Microsoft Certified Solution Developer
    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as
    Answer" if a marked post does not actually answer your question.
  • Re: How to build DAL

    06-21-2009, 10:57 PM
    • All-Star
      91,728 point All-Star
    • vinz
    • Member since 10-05-2007, 11:47 AM
    • Cebu, Philippines
    • Posts 13,769
    • TrustedFriends-MVPs

    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

    "Code,Beer and Music ~ my way of being a programmer"

  • Re: How to build DAL

    06-21-2009, 11:21 PM
    • Member
      497 point Member
    • ajaypathak
    • Member since 03-14-2007, 12:21 PM
    • Indore
    • Posts 181

     can u please send me some links or document links ?

    Ajay Pathak
    MVP
    All About ASP.net
  • Re: How to build DAL

    06-22-2009, 12:36 AM
    Answer
    • Member
      348 point Member
    • albarossa
    • Member since 04-03-2008, 2:39 PM
    • Posts 68

    http://aspalliance.com/914

     

Page 1 of 1 (7 items)