MVC3 and Entity Framework

by

my answer is pretty simple, do not mess up presentation layer (Whole MVC application) with data access logic and data modeling.

Have at minimum 4 projects in your Visual Studio Solution, from bottom to the top:

1 – ProjectName.Interfaces (Class library, entities’s interfaces);

2 – ProjectName.DAL (Class library, the only one allowed to even know the EF is used, the POCO entities implement the interfaces of project 1 using another file where you redeclare same objects using partial classes…);

3 – ProjectName.BL (Class library, Business logic, references the two projects above 1 and 2);

4 – ProjectName.Web (ASP.NET MVC application, Presentation Layer, references two projects 1 and 3 but NOT 2);

this to simplify things of course, based on my experience this is a solid design, a bit overkilling for very small projects but pays off in the long term.

in my view, the M of MVC, Model, is NOT the data model, is not the EF, is not there to do ORM bound to the specific database engine.

this answer is subjective of course and is based on my personal experience 😉

More Related Contents:

  1. How to warm up an ASP.NET MVC application on IIS 7.5?
  2. How do I import a namespace in Razor View Page?
  3. Server.UrlEncode vs. HttpUtility.UrlEncode
  4. How to set correct file permissions for ASP.NET on IIS
  5. Hidden Features of ASP.NET [closed]
  6. How to “warm-up” Entity Framework? When does it get “cold”?
  7. How to render a DateTime in a specific format in ASP.NET MVC 3?
  8. How and where to call Database.EnsureCreated and Database.Migrate?
  9. Unable to start debugging on the web server. Could not start ASP.NET debugging VS 2010, II7, Win 7 x64
  10. ASP.NET MVC Url Route supporting (dot)
  11. mvc uppercase Model vs lowercase model
  12. I’m lost. What happened to ASP.NET MVC 5?
  13. You must add a reference to assembly ‘netstandard, Version=2.0.0.0
  14. MemoryCache Empty : Returns null after being set
  15. Entity Framework: how to solve “FOREIGN KEY constraint may cause cycles or multiple cascade paths”?
  16. It has a DefiningQuery but no InsertFunction element… err
  17. How to deploy ASP.NET MVC 4 application using localDB to local IIS on Windows 7?
  18. “Parser Error Message: Could not load type” in Global.asax
  19. Adding sub-directory to “View/Shared” folder in ASP.Net MVC and calling the view
  20. Entity framework context as static
  21. Unable to Retrieve Metadata
  22. Unit-testing .ToListAsync() using an in-memory
  23. v11.0\WebApplications\Microsoft.WebApplication.targets was not found when file actually references v10
  24. How to get the current view name in asp.net MVC 3?
  25. Unable to find the requested .Net Framework Data Provider. It may not be installed
  26. Entity Framework v2 doesn’t support sql 2000?
  27. All requests to ASP.NET Web API return 404 error
  28. .NET “code nugget blocks”?
  29. ASP.NET MVC alongside Web Forms in the same web app?
  30. How do I make a “generic error” page in my ASP.NET application so that it handles errors triggered when serving that page itself?

Leave a Comment