Robert Gray

Notes on switching from Cosmos DB with Entity Framework, to Sql Server as a database.

I'm not sure how many total weeks of my life I've spent on data import. Many. Maybe Hundreds. Also, every new project needs test data and usually we'll write INSERT INTO blah blah full scripts again and again. Here's a way to slightly reduce the amount of text that needs to be written/sent to the server AND make your scripts cleaner. Available Sql Server 2008 and up.

Cross join with filter equals inner join with filter. A little experiment to test what Sql Server with it's query optimisation and with how linq does it's magic.