Entity framework & Connection string at runtime | Issue in implemention Transaction

Hi All,

I have a problem with entity framework4.1. In which i need to define my connection string at runtime and my business logic call will travel to various sub class to perform insert operation(for insert we are using SP as function import)

Exception occurs only when i implemented transaction.

Exception Detail : The underlying provider failed on Open.

Inner Exception : {"Attempted to access an unloaded appdomain. (Exception from HRESULT: 0x80131014)"}

Can some one help me to solve this problem(implementing transaction separate).

class Person
{
 public string Name{ get; set; }
      // Other fields
      public List<Address> AllAddress { get; set; }
}
 
class Address
{
// Address fields
}
 
public class PersonBL
{
 public bool addPerson(Person person)
            {
                EntityConnection objEntityCon = new EntityConnection("my connection string");
                using (DBEntity dbContext = new DBEntity(objEntityCon))
                {
                    using (TransactionScope transaction = new TransactionScope())
                    {
                        ObjectParameter id = new ObjectParameter("personID", typeof(Int32));
                        // Calling my Function import to insert person(except address information)
  // record which return PersonID
                        dbContext.AddPerson(person.Name, id);
                        int personID = Convert.ToInt32(id.Value);
                        if (personID > 0 && AddAllAddress(person.AllAddress, personID))
                            transaction.Complete();
                    }
                }
            }
 
            public bool AddAllAddress(List<Address> addresses, int personID)
            {
                bool result = true;
                AddressBL addressBL = new AddressBL();
                foreach(Address address in addresses)
                {
                    if (!addressBL.addAddress(address)) // Error occurs at this place.
                    {
                        result = false;
                    }
                }
 
                return result;
            }
 }
 
public class AddressBL
{
            public bool addAddress(Address address)
            {
                bool result = true;
                EntityConnection objEntityCon = new EntityConnection("my connection string");
                using (DBEntity dbContext = new DBEntity(objEntityCon))
                {
                    // Call imported SP(function import)
                }
 
                return result = true;
            }
}

Re: Entity framework & Connection string at runtime | Issue in implemention Transaction

Hello

Suspecting that there's something wrong with your machine.configSo plz copy a new one from other's PC with the same version of VS to yours

Reguards

Re: Entity framework & Connection string at runtime | Issue in implemention Transaction

I tried this code in another machine still no change in error, So i think this error may not related to my machine.config.

Please any other idea or suggestion.

Re: Entity framework & Connection string at runtime | Issue in implemention Transaction

Hi Rakbul , If you are still facing this issue , I will recomend you open microsoft support Incident for this issue.

Re: Entity framework & Connection string at runtime | Issue in implemention Transaction

Try following code.

private CRMFMEntities _DBContext = null;

EntityConnection entityConnection = new EntityConnection();
                    //entityConnection.ConnectionString = dal.GetConnection().ConnectionString;
 
                    string connectionString = "Your SQL Connection String";
 
                    System.Data.SqlClient.SqlConnectionStringBuilder scsb = 
 new System.Data.SqlClient.SqlConnectionStringBuilder(connectionString);
 
                    EntityConnectionStringBuilder ecb = new EntityConnectionStringBuilder();

//Change the below line and add the Accutal name of the database.

ecb.Metadata = "res://*/App_Code.Database.csdl|res://*/App_Code.Database.ssdl|res://*/App_Code.Database.msl";
                    ecb.Provider = "System.Data.SqlClient";
                    ecb.ProviderConnectionString = scsb.ConnectionString;
                    _DBContext = new CRMFMEntities(ecb.ConnectionString);