Author
Released
9/6/2018- Setting up your project
- Connecting to a legacy database
- Scaffolding an initial model and context
- Improving the model
- Adding concurrency tokens and timestamps
- Modeling complex relationships
- Working with non-Microsoft databases such as SQLite and PostgreSQL
Skill Level Intermediate
Duration
Views
- [Rich] Hi, I'm Rich Goforth. I'm a software architect and consultant. Since 2006, I've been coding on the Microsoft stack, from databases to the web to mobile devices. Often, we want to rewrite existing applications to make them more maintainable and create new functionality against existing data. Coding against existing databases provides a different set of challenges than working with a new data set. Most demos and examples focus on new databases. So here, we're gonna spend some time specifically in the world of an existing database.
Have you ever had a table filled with ambiguous field names, or every field pre-fixed with a type? There are a lot of things about older databases that we'd like to hide from new code. We want our new work to be legible and easy to maintain, and dealing with the trappings of legacy databases can really inhibit that goal. In this course, we'll be working with a database from a fictitious sports nutrition company called HPlusSport, and any framework core is going to allow us to write clean code against this less than desirable database. As a bonus, it will function on a wide variety of platforms.
So let's get started.
Related Courses
-
Introduction
-
What you need to know1m 23s
-
Using the exercise files1m 45s
-
1. Get Started with Entity Framework Core (on Your Legacy Database)
-
Setting up your project3m 35s
-
Connecting to the database1m 40s
-
Choose your approach2m 34s
-
-
2. Improve the Model
-
Changing names1m 49s
-
Using shadow properties2m 23s
-
Using backing fields3m 35s
-
Adding and altering indexes3m 38s
-
3. Model Complex Relationships
-
Navigation properties3m 34s
-
Accessing computed columns3m 19s
-
4. Work with Non-Microsoft Databases
-
Create a SQLite database5m 20s
-
PostgreSQL on a Mac5m 33s
-
Other options1m 31s
-
Conclusion
-
Next Steps39s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome to Entity Framework Core