DataProviderEnterprise uses the Microsoft TransactionScope class which requires the "Distrubuted Transaction Coordinator" (MSDTC) and allows you to have true distributed transactions involving many databases, servers, MSMQ and more. Our esTransactionScope has the same API but uses ADO.NET transactions which are not distributed (and therefore faster). I'm not sure what you mean by Save being on a differenent connection. Your ADO.NET dataprovider will use connection pooling, every time EntitySpaces hits the databases it uses a new connection, this connection may or may not have come from the connection pool.
Also, there is no need to ever use transactions unless you are save two different unrelated EntitySpaces objects.
EntitySpaces |
Twitter |
BLOG | Please honor our Software License