By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,084 Members | 1,969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,084 IT Pros & Developers. It's quick & easy.

Help implementing a transaction

P: n/a
LBS
Hello guys

I'm trying to implement a wrapper class, and I'm havinf difficulty
implementing the transaction.

I have several classes. The wrapper WrapDbCommand, WrapConnection..etc, and
the actual SQL server class.
The connection, parameter,executes works fine.

However, When I tries to create a transaction, my property always return
"nothing"

I must not use the correct syntax.
Could somebody point me out the syntax ?

Public MustInherit Class WrapDbCommand

Implements IDbCommand

Public MustOverride Function CreateParameter() As
System.Data.IDbDataParameter Implements
System.Data.IDbCommand.CreateParameter

Public MustOverride Function ExecuteNonQuery() As Integer Implements
System.Data.IDbCommand.ExecuteNonQuery

Public MustOverride Property Transaction() As System.Data.IDbTransaction
Implements System.Data.IDbCommand.Transaction
Etc...

=================

Public Class WrSqlCommand

Inherits WrapDbCommand
Public Overrides Property Transaction() As System.Data.IDbTransaction
Get
Return m_Command.Transaction
End Get

Set(ByVal Value As System.Data.IDbTransaction)
m_Command = CType(Value, SqlCommand)
End Set

End Property
Etc...

============

public class WrSqlConnection
Inherits WrapSqlConnection

Public Overloads Overrides Function BeginTransaction(ByVal iso As
System.Data.IsolationLevel) As System.Data.IDbTransaction

m_Connection.BeginTransaction(iso)

End Function
Etc..
Nov 21 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.