ADO.NET Entity Framework vs Dataset desinger

Last post 11-24-2009 8:43 PM by malcolms. 4 replies.

Sort Posts:

  • ADO.NET Entity Framework vs Dataset desinger

    11-24-2009, 2:19 PM
    • Member
      153 point Member
    • polynaux
    • Member since 03-13-2007, 7:12 PM
    • Posts 702





    Hi Guys,
    I am having trouble grasping the differences
    between the ADO.NET Entity Framework and
    the Dataset designer.

    According to microsoft:
    The Dataset Designer is a set of visual tools for creating and editing typed datasets and the individual items that make up datasets.
    The Dataset Designer provides visual representations of the objects contained in typed datasets. You create and modify TableAdapters, TableAdapter Queries, DataTables, DataColumns, and DataRelations with the Dataset Designer.

    Well, does the same thing not happen when
    I use the ADO.NET Entity Framework to "mirror" my
    database structures?



    Microsoft Entity Framework

    http://www.asp.net/learn/mvc/tutorial-21-vb.aspx

  • Re: ADO.NET Entity Framework vs Dataset desinger

    11-24-2009, 2:25 PM
    Answer
    • All-Star
      40,289 point All-Star
    • rtpHarry
    • Member since 10-01-2006, 12:51 PM
    • Lincoln, England
    • Posts 6,554

    Dataset designer is an older technology.


    The Entity Framework is microsoft's officially recommended data access technology. It is going to be using it in several of its major products moving forward and intends to invest heavily in it.

  • Re: ADO.NET Entity Framework vs Dataset desinger

    11-24-2009, 5:31 PM
    Answer
    • Member
      62 point Member
    • AndyB123
    • Member since 10-03-2009, 6:25 PM
    • Posts 11

    One thing to add... ADO.NET Entity Framework will allow you to do more than just "mirror" your database structure.  One of the advantages it has is to allow you to map your database to your business objects in something other than in a strict one-to-one fashion

  • Re: ADO.NET Entity Framework vs Dataset desinger

    11-24-2009, 5:49 PM
    Answer
    • Star
      12,683 point Star
    • docluv
    • Member since 06-29-2002, 11:16 PM
    • Willow Spring NC
    • Posts 2,004
    • ASPInsiders
      TrustedFriends-MVPs

    The other two answers are good. I wanted to add that besides Datasets being an older way of doing things, they are resource hogs compared to using entities and generic lists. I switched about 5 years ago and have not looked back since. EF solves a lot of relationship problems or at least makes things much easier, especially when you throw LINQ in the mix. 

  • Re: ADO.NET Entity Framework vs Dataset desinger

    11-24-2009, 8:43 PM
    Answer
    • All-Star
      15,769 point All-Star
    • malcolms
    • Member since 06-12-2008, 12:38 AM
    • Melbourne, Australia
    • Posts 2,688

    Like everyone else mentioned EF is the new way of doings database interaction.  DataSets were great in .Net 2.0, but with the addition of EF and LINQ to SQL, DataSets are IMO obsolete.

    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.
Page 1 of 1 (5 items)