Control hosted in Winforms Application:
Control in Editmode - new Form ShowDialog
Transactions with MSAccess mdb File
If you use Distributed Transactions within your Application and an Access .mdb a DataContainer then you maybe did get this:
System.InvalidOperationException: The ITransactionLocal interface is not supported by the 'Microsoft.Jet.OLEDB.4.0' provider. Local transactions are unavailable with the current provider.
SOLUTION:
Don't let Access participate in this Distributed Transaction
System.Transactions.TransactionScopeOption.Suppress
Msdn Link: Supporting Transactions in OLE DB
Entreprise Library: Exception Handling Policies
wir sind gerade bei der migration von Microsoft Oracle Client nach Oracle Data Provider.
WICHTIG in app.config
wenn man bei 2 exceptionTypes einfügt, greifen diese Regeln nicht!
weiss nicht wieso.
aber mit nur einer funzts.
wenn beide exceptionTypes drin sind, werden diese nicht abgehandlet.
KOMISCH
<exceptionHandling> <exceptionPolicies> <add name="Global Policy"> <exceptionTypes> <add type="System.Exception, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" postHandlingAction="NotifyRethrow" name="Exception" /> </exceptionTypes> </add> <add name="DataAccess"> <exceptionTypes> <add type="Oracle.DataAccess.Client.OracleException, Oracle.DataAccess, Version=1.102.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" postHandlingAction="ThrowNewException" name="OracleException"> <exceptionHandlers> <add type="Siag.DataAccess.ExceptionHandler.OracleODPExceptionHandler, Siag.DataAccess" name="Custom Handler" /> </exceptionHandlers> </add> <!-- <add type="System.Data.OracleClient.OracleException, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" postHandlingAction="ThrowNewException" name="OracleException"> <exceptionHandlers> <add type="Siag.DataAccess.ExceptionHandler.OracleExceptionHandler, Siag.DataAccess, Version=2.0.0.11969, Culture=neutral, PublicKeyToken=null" name="Custom Handler"/> </exceptionHandlers> </add> --> </exceptionTypes> </add> </exceptionPolicies> </exceptionHandling>
Labels: coding, Enterprise Library
Subscribe to:
Posts (Atom)
Latest Posts
Popular Posts
-
I am *very* keen on automating tests, so I was looking into unit testing a WCF service. If I say "unit test", I mean a fast ,...
-
It's easy I thought, just select the Property of the EntityType and set the Default Value in the Properties window to: DateTime.Now ...
-
*Updated* 26. September 2010: Updated with comments from Adam Cogan *Updated* 27. September 2010: Updated the comparison between anonymo...