1 / 16

Data Access Layer

Discover how to improve and modernize your enterprise web applications using EF Code-First Migrations in ASP.NET MVC. This guide covers essential concepts like models and mapping, DBContext configuration, connection strings, enabling migrations, and the complete workflow of updating the database through code. Learn how to streamline your development process with CI servers for effective database management, ensuring your application remains up-to-date with the latest changes. Access valuable resources for a deeper understanding and implementation of these technologies.

brie
Télécharger la présentation

Data Access Layer

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Access Layer Shahed Chowdhuri Using Code-First Migrations

  2. Thanks to our Sponsorsfor keeping the fires lit

  3. Introduction Enterprise Web Application • Looking for Ways to Improve & Modernize • Motivation behind this design? ASP.NET MVC • Our desire to do the following: DB

  4. Tech Check EF Code-First Migrations Are you familiar with…? Entity Framework EF Code-First Development ASP .NET MVC

  5. Options and Alternatives

  6. What are we trying to solve?

  7. DAL: Agenda

  8. 1. Models & Mapping DBContext .OnModelCreating()

  9. 2. Connection Strings

  10. 3. Enable Migrations

  11. 4. Update Database model code migration code dev DB migration code + seed (sql)

  12. 5. Push Code + Migrate Server DB code push code code pull code CI Server DB migrate.exe

  13. 6. Process Workflow communication DB DB architects dev team

  14. Code Walkthrough

  15. DAL: Conclusion

  16. Resources • EF Code First Migrations on MSDN: • http://msdn.microsoft.com/en-US/data/jj591621 • Web.config & configSource: • http://wakeupandcode.com/all-your-database-are-belong-to-us/ • PluralSight EF Migrations video tutorial: • http://pluralsight.com/training/Courses/TableOfContents/efmigrations

More Related