I have a similar issue.
Code: Select all
using ( AfmContext afmContext = GetDataContext() )
{
using ( TransactionScope transactionScope = new TransactionScope() )
{
// CODE REMOVED HERE
try
{
foreach (var spIdOrPremId in spIdsOrPremIds.Where( id => id != null ) )
{
afmContext.CmGisSpidPremidListVws.Add(new CmGisSpidPremidListVw(spIdOrPremId));
}
afmContext.DbContext.SaveChanges();
// CODE REMOVED HERE that calls views in other database that
// depend on the temp table being populated
}
finally
{
// This causes a commit. Without the transaction logic the Save Changes call will
// send commit. A commit clears the temp table, which we don't want above, but we
// need this here to clear the temp table for the next call.
transactionScope.Complete();
}
return customerInfos.ToList();
}
All this worked fine until the oracle encryption change. Any idea what I need to modify to get this working?
Thanks!