- 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
- [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.