The Situation: You have a long running Entity Framework query that often creates a "System.Data.SqlClient.SqlException" with the message "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." A Solution: As near as I can find, the default timeout for EF queries using the SQL Server 2008 … Continue reading How To Extend the Timeout Period on an Entity Framework Query
How to Add a New Table to an Existing Database via EF Code-First Migrations
The Situation: You have been using Entity Framework code-first migrations with an existing database. Making changes to an existing table, such as adding a new field, go smoothly, and the database is updated correctly when you run an "Update-database" command. However, when you create an entirely new entity in your model and run "Update-database", the … Continue reading How to Add a New Table to an Existing Database via EF Code-First Migrations
How to Enable and Use EF Code-First Migrations for Multiple Contexts
The Situation You want to use Entity Frameworks code-first migrations to push model changes to the database, but you have multiple databases and contexts in your model. When you try to run Enable-Migrations for the second context, you get an error that looks like this: Migrations have already been enabled in project 'Project1'. To overwrite the … Continue reading How to Enable and Use EF Code-First Migrations for Multiple Contexts
Entity Framework: Repository or Not Repository?
On the heels of the demise of the commercial version of EntitySpaces, I am delving into Microsoft's Entity Framework. I need to implement it in a big project to replace a much more manual Data Access Layer. So I've done a ton of reading on it (and played with it some, too), and the common … Continue reading Entity Framework: Repository or Not Repository?