Entity Framework with VS 2010 -

Posted on 2011-04-27
Last Modified: 2013-11-26
I am looking at putting together the pro's and cons between utilizing the Entity Framework - LINQ - or just writing the way common to previous versions of Visual Studio prior to VS 2008.  It seems that LINQ is not a viable solution as my understanding is it is going away or not supported.

I would really like to gain two things from this question in order to provide points.

1:  Web Samples
2)  Pro's and Cons - Success Stories.

Please keep in mind that am just putting together a demo for now - a mock website that just demonstrates the capabilities.

I build websites with the concept of a FrontEnd - BAL - DAL and SQL 2005 on the backend for now.

Once I have a working sample in this type of architecture - I will assign points and close the question.

Question by:Robb Hill
    LVL 96

    Accepted Solution

    1) LINQ-to-XSD will be going away, but I still use it for small utility applications, as it is easier to implement than Entity Framework.

    2) LINQ will not be going away for quite a while, because it is totally awesome!!

    3) I had nothing but problems with the Entity Framework 4 that came with 2010, but with Entity Framework 4.1 (additional install), I believe that it is now becoming a viable solution, since it now supports the code-first approach for data modeling.

    4) I am a bigger fan of NHibernate 3 with fluent interface

    5) I am not exactly sure what kind of samples that you are looking for, so it would be difficult to pick out just the right needle in the proverbial haystack.
    LVL 11

    Author Comment

    by:Robb Hill
    I found this link that using the Contoso University as a sample.  This utilizes the data-first model.

    Why do you prefer the code first approach....I would think the choice of doing one or the other would be based on the application rather which is better.  
    LVL 11

    Author Comment

    by:Robb Hill
    LVL 11

    Author Comment

    by:Robb Hill
    Is your main issue with Entity due to complexity?  If so maybe you could elaborate....Im finding that just wiring it up to a database and putting a basic frontend that it takes just minutes ....but I havent done much except for examples so not sure where the headache would be.
    LVL 96

    Assisted Solution

    by:Bob Learned
    My main issues with Entity Framework were the exceptions, the model validation errors, the bizarre behavior when working with foreign keys.  

    Let's peer into the mind of Scott Guthrie:

    Code-First Development with Entity Framework 4

    In addition to supporting a designer-based development workflow, EF4 also enables a more code-centric option which we call “code first development”.  Code-First Development enables a pretty sweet development workflow.  It enables you to:

        • Develop without ever having to open a designer or define an XML mapping file
        • Define your model objects by simply writing “plain old classes” with no base classes required
        • Use a “convention over configuration” approach that enables database persistence without explicitly configuring anything
        • Optionally override the convention-based persistence and use a fluent code API to fully customize the persistence mapping
    LVL 11

    Author Closing Comment

    by:Robb Hill
    Thanks for your advice.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
    A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now