Why is there a string value required in starting a transaction

public virtual void StartTransaction( IsolationLevel isolationLevelToUse, string name )

What is this "name" value used for? There is no explaination as to why its there. I am guessing it might be used for Transaction SavePoints. However I do not like guessing so if you could explain its use it would be appreciated.

Starting v.2.6 the name is there for backward compatability for SQL Server. ref: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14411

Previously it was used to identify a specific transaction in logs (eg. logs created by SQL Profiler).

Walaa wrote:

Starting v.2.6 the name is there for backward compatability for SQL Server. ref: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14411

Previously it was used to identify a specific transaction in logs (eg. logs created by SQL Profiler).

You could update your documentation to say that from version 2.6 its use has been deprecated but is retained for backward compatibility purposes. I know maintaining documentation is a pain but I think it important to update it from information contained in the forums.

I noticed that it appears to be used when using savepoints. Is this actally important here or does a rollback simply rollback to the previous adaptor.SaveTransaction and the name here is more for documentation purposes. In otherwords if you use several adaptor.SaveTransactions with different names, will a rollback, rollback to the adaptor.SaveTransaction with the same name or just the most recent?

he00273 wrote:

Walaa wrote:

Starting v.2.6 the name is there for backward compatability for SQL Server. ref: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14411

Previously it was used to identify a specific transaction in logs (eg. logs created by SQL Profiler).

You could update your documentation to say that from version 2.6 its use has been deprecated but is retained for backward compatibility purposes. I know maintaining documentation is a pain but I think it important to update it from information contained in the forums.

We will look into it.

he00273 wrote:

I noticed that it appears to be used when using savepoints. Is this actally important here or does a rollback simply rollback to the previous adaptor.SaveTransaction and the name here is more for documentation purposes. In otherwords if you use several adaptor.SaveTransactions with different names, will a rollback, rollback to the adaptor.SaveTransaction with the same name or just the most recent?

The adapter.Rollback("SavepointX"); will rollback to the adapter.SaveTransaction("SavepointX");. adapter.Rollback("SavepointZ"); will rollback to the adapter.SaveTransaction("SavepointZ");. And so on...