Creating a Transaction (Enterprise Libraries)

Following is an example of creating a transaction when require to save on many tables at once. I used Microsoft Enterprise Libraries. I assume one to many relation.

Dim _Connection As DbConnection = Nothing
Dim _Transaction As DbTransaction = Nothing

Try

         Dim _DB As Database = DatabaseFactory.CreateDatabase("YourConnectionStringNameInConfigFile")
         _Connection = _DB.CreateConnection
         _Connection.Open()
         _Transaction = _Connection.BeginTransaction()

                            //Inserting Master table record, You can set parameters here
                            .Insert(_DB, _Transaction)


                              For i As Integer = 0 To NoOfItemsInGrid

                                         //Inserting Transaction Records, You can set parameters here
                                        .Insert(_DB, _Transaction)

                             Next

               _Transaction.Commit()


               Catch ex As Exception
              

                                _Transaction.Rollback()

                Finally

                                 If _Connection.State = ConnectionState.Open Then
                                         _Connection.Close()

                                 End If

End Try

You must Login to comment.