Can we configue how CLR app domains are associated with db connections?

Question

The docs suggest that the only way to define distinct app-domains for SQL/CLR code is to assign different DB user-ids.

But is this strictly true? can we configure this in any way? like per-connection or some other criteria?

 

Thx

 

Answer 1

Hi Captain Kernel,

You may cannot to configure the AppDomain per connection. The isolation level for an AppDomain for SQLCLR is one AppDomain per database per owner. Please have a look at this article: http://msdn.microsoft.com/en-us/library/ms187720.aspx.

For more information about using appdomain in SQL Server CLR: http://msdn.microsoft.com/zh-cn/magazine/cc301479(en-us).aspx.

Best Regards,
Stephanie Lv

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Hi Captain Kernel,

You may cannot to configure the AppDomain per connection. The isolation level for an AppDomain for SQLCLR is one AppDomain per database per owner. Please have a look at this article: http://msdn.microsoft.com/en-us/library/ms187720.aspx.

For more information about using appdomain in SQL Server CLR: http://msdn.microsoft.com/zh-cn/magazine/cc301479(en-us).aspx.

Best Regards,
Stephanie Lv

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Thanks Stephanie, so is it the case then that there are NO other isolation options available? this is the ONLY one? I am just trying to get 100% certainty on this.

Cap'n