SqlException from Entity Framework – New transaction is not allowed because there are other threads running in the session

by

After much pulling out of hair I discovered that the foreach loops were the culprits. What needs to happen is to call EF but return it into an IList<T> of that target type then loop on the IList<T>.

Example:

IList<Client> clientList = from a in _dbFeed.Client.Include("Auto") select a;
foreach (RivWorks.Model.NegotiationAutos.Client client in clientList)
{
   var companyFeedDetailList = from a in _dbRiv.AutoNegotiationDetails where a.ClientID == client.ClientID select a;
    // ...
}

More Related Contents:

  1. Using Transactions or SaveChanges(false) and AcceptAllChanges()?
  2. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  3. Using Simple Injector with Unit Of Work & Repository Pattern in Windows Form
  4. Entity Framework 6 transaction rollback
  5. summing values of a column based on id [closed]
  6. MSSQL Error ‘The underlying provider failed on Open’
  7. Why does the EF 6 tutorial use asynchronous calls?
  8. how to use MVVMLight SimpleIoc? [closed]
  9. Many-to-many mapping table
  10. How do you reconcile IDisposable and IoC?
  11. Entity Framework error: Cannot insert explicit value for identity column in table
  12. Dynamic MySQL database connection for Entity Framework 6
  13. How do I clear tracked entities in entity framework
  14. How to disable cascade delete for link tables in EF code-first?
  15. Entity framework, problems updating related objects
  16. How to use TransactionScope in C#?
  17. Navigation Property without Declaring Foreign Key
  18. Entity Framework Specification Pattern Implementation
  19. MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid
  20. How to I apply filter while paginating in Asp.net MVC and entity Framework?
  21. Global setting for AsNoTracking()?
  22. EF5 Getting this error message: Model compatibility cannot be checked because the database does not contain model metadata
  23. Asp.Net MVC3: Set custom IServiceProvider in ValidationContext so validators can resolve services
  24. Json.Net adding $id to EF objects despite setting PreserveReferencesHandling to “None”
  25. Remove item from list based on condition
  26. EF models. Navigation properties can only participate in a single relationship
  27. Seed Entities AND Users, Roles?
  28. The entity type ‘IdentityUserLogin’ requires a primary key to be defined [duplicate]
  29. Should Entity Framework Context be Put into Using Statement?
  30. How to use String property as primary key in Entity Framework

Leave a Comment