Entity framework error as"New transaction is not allowed because there are other threads running in the session

Question

We are using entity framework codefirst approach I am new to entity framework and I am facing error while trying to do "New transaction is not allowed because there are other threads running in the session.

public class DatabaseBackup : IDataBackup
    {
        private readonly IMonarchDbContext m_db;
        public DatabaseBackup(IMonarchDbContext podb)
        {
            if (podb == null)
                throw new ArgumentNullException("podb");

            m_db = podb;
        }
    public DBBackupHistory GetLatestBackupHistory(DBBackupFrequency backupFrequency = DBBackupFrequency.Periodic)
        {
            DBBackupHistory result = null;
            // get the backup history of the given backuptype and populate the objects 

            var configId = m_db.DBBackupConfigurations.Where(c => c.ScheduleType == (int)backupFrequency && c.BackupStatus == 1).Distinct().Select(c => c.ConfigurationId).DefaultIfEmpty(-1).First();

            if (configId > 0)
            {
                result = m_db.DBBackupHistorys.Where(b => b.Status == 1 && b.ConfigurationId == configId).OrderByDescending(lb => lb.BackupDatetime).FirstOrDefault();
            }

            return result;
        }
public IEnumerable<DBBackupConfiguration> GetAllConfiguration()
        {
            var result = m_db.DBBackupConfigurations.Where(c => c.BackupStatus == 1).OrderByDescending(c => c.ConfigurationId);

            return result;
        }
            public void Backup(DBBackupConfiguration config, int fileIndex)
        {

        Console.WriteLine("Running DB Backup type {0} to device {1}", (DBBackupType)config.BackupType, fileIndex);

            m_db.StoredProc.SPBackup(config, fileIndex);

        }

I am calling the below methods in another class as follows

private readonly IDataBackup m_dataBackup;
public int PerformBackup(int defaultPollIntervalInMinutes = 15)
        {
            // polling interval in Minutes
            int pollInterval = defaultPollIntervalInMinutes;

            int fileIndex = getCurrentDumpFileIndex();

            // check for the backup configuration
            var configurations = m_dataBackup.GetAllConfiguration();

            foreach (var config in configurations)
            {
    var lastBackup = m_dataBackup.GetLatestBackupHistory(DBBackupFrequency.Weekly);
                    if (lastBackup == null)
                    {
                        m_dataBackup.Backup(config, fileIndex + 1);
                        break;
                    }

Here is the Db Context class is as below

 public class MonarchDbContext:DbContext,IMonarchDbContext
        { 
               private IStoredProcedure m_storedProc;

               private static object m_dbIntializerSet;

    public MonarchDbContext(string nameOrConnectionString)
                : base( nameOrConnectionString )
            {
                //-- Set the DB initializer only once.
                System.Threading.LazyInitializer.EnsureInitialized( ref m_dbIntializerSet,()=>{
                                        Database.SetInitializer<MonarchDbContext>(null);
                        //-- Give debug builds a chance to overwrite the above.
                        _SetInitializerForDebugBuilds();
                        return new object();
                    });

                Configuration.LazyLoadingEnabled = false;
                Configuration.ProxyCreationEnabled = false;

                var csb = new SqlConnectionStringBuilder( this.Database.Connection.ConnectionString );



                csb.MultipleActiveResultSets = true;
                this.Database.Connection.ConnectionString = csb.ToString();

                var objectContext = ( this as IObjectContextAdapter ).ObjectContext;
                objectContext.CommandTimeout = 3600;
            }

       #region Public "Tables"

            public IDbSet<DBBackupConfiguration> DBBackupConfigurations { get; set; }

            public IDbSet<DBBackupHistory> DBBackupHistorys { get; set; }

            public IStoredProcedure StoredProc
            {
                get
                {

                    return System.Threading.LazyInitializer.EnsureInitialized(ref m_storedProc, () => new BackupStoredProc(this.Database));
                }
            }
            #endregion

please let me know how can i solve the issue.

Answer 1

Just add the List to Ienumerbale types

Answer 2

I found the issue

I need to add toList() at the end of the Linq code and it just worked for me.

public IEnumerable<DBBackupConfiguration> GetAllConfiguration()
        {
        var result = m_db.DBBackupConfigurations.Where(c => c.BackupStatus == 1).OrderByDescending(c => c.ConfigurationId).ToList();
            return result;
        }