SNIReadSyncOverAsync and WaitForSingleObject blocking EF performance?
I am doing some profiling on a WCF service that uses EF (System.Data.Entities) to read from a SQL DB. When I spin up … Read more
entity-framework-4
The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
Basically I got a table in my EF database with the following properties: public int Id { get; set; } public string Title … Read more
What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
I know some differences of LINQ to Entities and LINQ to Objects which the first implements IQueryable and the second implements IEnumerable and … Read more
How to update only one field using Entity Framework?
Here’s the table Users UserId UserName Password EmailAddress and the code.. public void ChangePassword(int userId, string password){ //code to update the password.. } … Read more
What effect(s) can the virtual keyword have in Entity Framework 4.1 POCO Code First?
Does the virtual keyword has an effect when used on the properties in EF Code First?. Can someone describe all of its ramifications … Read more
The model backing the context has changed since the database was created
The error message : “The model backing the ‘AddressBook’ context has changed since the database was created. Either manually delete/update the database, or … Read more
Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths – why?
I’ve been wrestling with this for a while and can’t quite figure out what’s happening. I have a Card entity which contains Sides … Read more
Entity Framework Timeouts
I am getting timeouts using the Entity Framework (EF) when using a function import that takes over 30 seconds to complete. I tried … Read more
EF Migrations: Rollback last applied migration?
This looks like a really common task, but I can’t find an easy way to do it. I want to undo the last … Read more
There is already an open DataReader associated with this Command which must be closed first
I have this query and I get the error in this function: var accounts = from account in context.Accounts from guranteer in account.Gurantors … Read more