Use EF Core to transition from SQL Server to Azure Cosmos DB

on YouTube ↗14m

" summary

Migrates an EF Core app from SQL Server to Azure Cosmos DB by switching the provider and EF Core with Cosmos DB provider, changing the model to collocate data so each API’s data lives in a single document. Builds embedded subdocuments (e.g. embedded creator and topWriters, episode summaries like episodeCount and firstAirDate), updates addEpisode to load episodes/writer and populate duplicates, and runs the demo: same JSON returned but with simple Cosmos reads. Notes slower writes and potential consistency tradeoffs.

AI-written summary · about

" chapters (12)

1. 0:00Introduction
2. 0:30API
3. 1:02Traditional relational model
4. 1:46EF Core with SQL
5. 2:48Plan
6. 3:04Document Databases
7. 3:30Cosmos Provider
8. 3:57Model Change
9. 5:14Entity Types
10. 11:01Recap
11. 11:25Summary
12. 12:25Thanks

" related talks

• 56mGetting Started with Cosmos DB + EF CoreThiago Passos · NDC Oslo 2019
• 01h 01mGetting Started with Cosmos DB + EF CoreThiago Passos · NDC Sydney 2019
• 45mGetting Started with Cosmos DB + EF CoreThiago Passos · NDC Minnesota 2019
• 56mGetting Started with Cosmos DB + EF CoreThiago Passos · NDC London 2019
• 01h 01mFrom SQL to Azure Cosmos DBJimmy Bogard · NDC Minnesota 2018
• 01h 02mFrom SQL to Azure Cosmos DBJimmy Bogard · NDC Oslo 2018
• 01h 01mServerless & Schemaless with Azure Functions and CosmosDBSantosh Hari · TechBash 2018
• 54mSharing a story of cosmic journey with Cosmos DBElkhan Yusubov · Global Summer 2020 Azure Data Fest 2020