The peculiar problem when your entity framework query returns the same row for every record
This one had me confused for a long time, several hours in fact. There were over 8,000 rows in the table, and the for some reason the query was returning the same row 8,000 times. After much rending of garments and gnashing of teeth, I discovered that the table in question (in a sql server […]
Connecting Entity Framework to Sql Server 2000
A lesson learned – when trying to map Entity Framework to Sql Server 2000 (if you must) – make sure that there are no nullable dates – if so, work around them. I just spent hours looking into that.
How to create a Sql Azure database with Entity Framework codefirst
I’ve lately begun to use Windows Azure, and I thought I would start blogging about it as well. Sql Azure database with entity framework codefirst – the song remains the same As I am deeply committed to using ASP.net MVC 3 with Entity Framework CodeFirst, I thought at first moving to Azure might be a problem, as Sql Azure […]
How to fix the “Could not read metadata, possibly due to insufficient access rights” error in Sql Server 2008
The Problem You are doing the responsible thing and make a backup before you make any crazy changes to your Sql Server 2008 database. You choose the option that gives you the most flexibility and decide to script your backup. Who knows where this backup will eventually go? You go through the Tasks>Script Database, and […]