Handle multiple database connection in one transaction scope
<p>I hv written following function <code>having two database context</code> in one <code>transaction scope</code>.  I am using <code>MySql</code> with <code>EF 5.0</code></p>

<pre><code> private static void SyncPremiumStores(JoyRydeWebPortalData.joyryde_WebPortalEntities contextWebPortal, JoyRydeMallStoreData.joyryde_MallStoreEntities contextMallStore)
    {
        using (TransactionScope scope = new TransactionScope())
        {
            foreach (var objWebPortalPremiumStore in contextWebPortal.tbl_premium_store.Where(x =&gt; x.INT_DATA_TRANS_STATUS == 0).ToList())
            {
                try
                {
                    var objMallStore = contextMallStore.tbl_store.Where(x =&gt; x.LNG_STORE_ID == objWebPortalPremiumStore.LNG_STORE_ID).FirstOrDefault();
                    if (objMallStore != null)
                    {
                        JoyRydeMallStoreData.tbl_premium_store objMallPremiumStore = new JoyRydeMallStoreData.tbl_premium_store()
                        {
                            DAT_CREATED = objWebPortalPremiumStore.DAT_CREATED,
                            DAT_PREMIUM_FROM = objWebPortalPremiumStore.DAT_PREMIUM_FROM,
                            DAT_PREMIUM_TO = objWebPortalPremiumStore.DAT_PREMIUM_TO,
                            LNG_PRIMARY_STORE_ID = objMallStore.LNG_PRIMARY_STORE_ID,
                            LNG_STORE_ID = objMallStore.LNG_STORE_ID,
                            TXT_PACK_NAME = ""
                        };
                        contextMallStore.tbl_premium_store.Add(objMallPremiumStore);
                        objWebPortalPremiumStore.INT_DATA_TRANS_STATUS = 1;
                    }

                    contextMallStore.SaveChanges();
                    contextWebPortal.SaveChanges();
                    scope.Complete();
                }
                catch (Exception ex)
                {
                    LogUtility.WriteErrorLog(ex);
                }
            }
        }
    }
</code></pre>

<p>On execution, it throws me error on </p>

<p><code>var objMallStore = contextMallStore.tbl_store.Where(x =&gt; x.LNG_STORE_ID == objWebPortalPremiumStore.LNG_STORE_ID).FirstOrDefault();</code> line with inner exception message </p>

<p><code>Multiple simultaneous connections or connections with different connection strings inside the same transaction are not currently supported.</code></p>

<p>I need to update two different databases in single transaction. 
How it can be done ??</p>