Hi all,

I was wondering if I used the following code it would be run in a valid transaction.

try
 _DataAccessAdapter.StartTransaction(IsolationLevel.Serializable, "CreateIncidentCaseEntity")

DatabaseSpecific.RetrievalProcedures.SPNAME(PARAM1,_DataAccessAdapter)
_DataAccessAdapter.Commit()

Catch ex As Exception
_DataAccessAdapter.Rollback()
 End Try

so that it would be able to be commited or rolled back depending on errors or not?

Cheers Sam

Yes it will.

You can verify this for yourself by watching the generated SQL using SQL Profiler.

Matt