From old server

jwijnker wrote:

Using LLBLGen 3.1 and .Net4 I want to add additional user-info to the SQL-Context (MS-SQL 2008 ).

In the adapter there is no way to get the connection itself to add the information. How can i add context-info to the connection?

---

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=7711 isn't helping me because it's using selfService.

In Adapter, write a DataAccessAdapter partial class in your DBSpecific project and write something like this:

using System.Data.Common;

namespace YourRootNamespace.DatabaseSpecific
{   
    public partial class DataAccessAdapter
    {
        protected override DbTransaction CreateNewPhysicalTransaction()
        {
            var trans = base.CreateNewPhysicalTransaction();

            var factory = GetDbProviderFactoryInstance();
            var command = factory.CreateCommand();
            command.Connection = this.GetActiveConnection();
            command.CommandText = "SET CONTEXT_INFO 0x1256698456";
            command.Transaction = trans;
            command.ExecuteNonQuery();

            return trans;
        }
    }
}