Loopback connection using CLR with same user credentials, outside current transaction

83 Views Asked by At

I want to create new connection in a clr assembly having

  • same access as the current user (ie loopback using the current user credential)
  • The new connection must be outside the current transaction and changes (update/insert/delete) should not be rolled back with the transaction failure

Found solutions for both cases individually

  1. Use sqlConn.ContextConnection = true;
  2. Use sqlConn.IntegratedSecurity = true;

but I want both conditions satisfied together

Basically i want to simulate autonomous connection in oracle using CLR instead of the extended stored procedure method suggested in this solution

0

There are 0 best solutions below