Code-first vs Model/Database-first

I think the differences are:

Code first

  • Very popular because hardcore programmers don’t like any kind of designers and defining mapping in EDMX xml is too complex.
  • Full control over the code (no autogenerated code which is hard to modify).
  • General expectation is that you do not bother with DB. DB is just a storage with no logic. EF will handle creation and you don’t want to know how it does the job.
  • Manual changes to database will be most probably lost because your code defines the database.

Database first

  • Very popular if you have DB designed by DBAs, developed separately or if you have existing DB.
  • You will let EF create entities for you and after modification of mapping you will generate POCO entities.
  • If you want additional features in POCO entities you must either T4 modify template or use partial classes.
  • Manual changes to the database are possible because the database defines your domain model. You can always update model from database (this feature works quite well).
  • I often use this together VS Database projects (only Premium and Ultimate version).

Model first

  • IMHO popular if you are designer fan (= you don’t like writing code or SQL).
  • You will “draw” your model and let workflow generate your database script and T4 template generate your POCO entities. You will lose part of the control on both your entities and database but for small easy projects you will be very productive.
  • If you want additional features in POCO entities you must either T4 modify template or use partial classes.
  • Manual changes to database will be most probably lost because your model defines the database. This works better if you have Database generation power pack installed. It will allow you updating database schema (instead of recreating) or updating database projects in VS.

I expect that in case of EF 4.1 there are several other features related to Code First vs. Model/Database first. Fluent API used in Code first doesn’t offer all features of EDMX. I expect that features like stored procedures mapping, query views, defining views etc. works when using Model/Database first and DbContext (I haven’t tried it yet) but they don’t in Code first.

Related Posts:

  1. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details
  2. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details
  3. The entity type is not part of the model for the current context
  4. EF CodeFirst: Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong
  5. Unable to determine the principal end of an association between the types
  6. How can I convert MP3 file to a Base64 encoded string? [closed]
  7. What is a sanity test/check
  8. What is an instance variable in Java?
  9. Discord music bot not working
  10. Python Math – TypeError: ‘NoneType’ object is not subscriptable
  11. TCP vs UDP – What is a TCP connection? [duplicate]
  12. ssh : Permission denied (publickey,gssapi-with-mic)
  13. Error in “MLSD” command While Connecting FTP to Server [closed]
  14. Java default constructor
  15. How do I make a delay in Java?
  16. did you specify the right host or port? error on Kubernetes
  17. How does Java’s PriorityQueue differ from a min-heap?
  18. What is a Memory Heap?
  19. What does ERR_SPDY_PROTOCOL_ERROR mean in nginx?
  20. What is a bitmask and a mask?
  21. C++ code file extension? What is the difference between .cc and .cpp
  22. How to remove origin from git repository
  23. XPath contains(text(),’some string’) doesn’t work when used with node with more than one Text subnode
  24. Transport endpoint is not connected
  25. How to convert .crt to .pem [duplicate]
  26. pagebreak in markdown while creating pdf
  27. Ping – Request timed out
  28. How do I remove version tracking from a project cloned from git?
  29. How do I correctly clean up a Python object?
  30. How do I split a string on a delimiter in Bash?
  31. ToList().ForEach in Linq
  32. Why does Wi-Fi have so much more bandwidth than Bluetooth?
  33. How do I get a list of built-in data sets in R?
  34. java.text.ParseException: Unparseable date
  35. Difference between .o and .ko file
  36. R error: all arguments must have the same length
  37. spring @sqlgroup with multiple datasource
  38. What is the definition of a “disparity map”?
  39. Reason for the exception java.lang.VerifyError: Bad type on operand stack
  40. How do I get monitor resolution in Python?
  41. git: fatal unable to auto-detect email address
  42. pandoc document conversion failed with error 43 : pdflatex: The memory dump file could not be found
  43. ERROR: transport error 202: bind failed when starting Tomcat 7 in debug mode
  44. How to check whether a Button is clicked by using JavaScript
  45. jQuery onclick not firing on dynamically inserted HTML elements?
  46. What is correct media query for IPad Pro?
  47. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  48. entity object cannot be referenced by multiple instances of IEntityChangeTracker. while adding related objects to entity in Entity Framework 4.1
  49. simple IPython example raises exception on sys.exit()
  50. How to get a minecarft session ID?
  51. Factory Pattern. When to use factory methods?
  52. How to send a PUT/DELETE request in jQuery?
  53. Arithmetic Overflow in mips
  54. How to change angular port from 4200 to any other
  55. Render HTML string as real HTML in a React component
  56. How to draw lines in Java
  57. Styling Select Drop down box
  58. NoClassDefFoundError in Java: com/google/common/base/Function
  59. Where are the ampersand and vertical bar characters used in Python?
  60. Which font is used in MS-DOS?
  61. Google Gmail – “The conversation that you requested could not be loaded”
  62. apt-get for Cygwin?
  63. Python: What OS am I running on?
  64. ER-Diagram: Ternary Relationship – How to read properly?
  65. How can I diff 2 files while ignoring leading white space
  66. Converting time stamps in excel to dates
  67. What is “pass-by-name” and how does it work exactly?
  68. is it possible to get the MAC address for machine using nmap
  69. Import error No module named skimage
  70. The provider did not return a ProviderManifestToken string Entity Framework
  71. Why define PI = 4*ATAN(1.d0)
  72. Java: Not a statement
  73. mport win32ui in python 3.6
  74. Empty functions in Javascript
  75. Solr: how to delete a collection?
  76. How to print a int64_t type in C
  77. How to store data in the flash memory of a Arduino Uno (ATmega328p)
  78. What is a blob URL and why it is used?
  79. Call to undefined function `get_plugin_data()`
  80. Contact Form 7 – Execute code AFTER mail send [closed]
  81. How to apply a patch?
  82. TwentyTwentyTwo – How to add PHP logic to Post templates?
  83. How can I trash multiple posts at once from the front end?
  84. Maintenance holding page while migrating website
  85. Multiple og:image for Facebook
  86. How to get a current post’s blog id
  87. Rendering javascript in render_callback php Code
  88. Will has_category be true is used on index and one of queried posts has the category?
  89. How to get a value from wp_dropdown_user?
  90. Exclude categories with only sticky posts OR count sticky post of specific category
  91. How to Unban an IP properly with Fail2Ban
  92. How to see stdout of ansible commands?
  93. Difference between KVM and QEMU
  94. Top level domain/domain suffix for private network?
  95. Are SSD drives as reliable as mechanical drives (2013)?
  96. The Joel Test for system administrator jobs
  97. How do I rename a task in Task Scheduled on Windows Server 2008 R2
  98. How do I get the history of “apt-get install” on Ubuntu?
  99. Why does x86 represent 32bit when x64 represents 64bit? [closed]
  100. How to reload screenrc without restarting screen?

Leave a Comment