C#企业库 [英] C# Enterprise Library

问题描述

我正在使用.NET 2.0，SQL Server 2005开发应用程序.我正在使用企业库版本3.1.

为了摆脱一些性能问题，我想将特定存储过程的ARITHABORT设置为ON.我不希望它出现在数据库级别.
有什么方法可以通过代码(企业库数据层)进行设置?还是一般来说，有什么方法可以通过企业库数据应用程序块设置此类会话参数?

我们对此表示感谢.

谢谢
Nyoti

Hi,

I am working on an application using .NET 2.0, SQL Server 2005. I am using Enterprise Library version 3.1.

To get rid off some performance issues, I want to set ARITHABORT to ON for a particular stored procedure. I do not want it to be at database level.
Is there any way we can set this through code (enterprise library data layer)? or in general, is there any way to set such session parameters through enterprise library data application block?

Any inputs on this are apprecited.

Thanks
Nyoti

推荐答案

只需在存储的proc中设置它(别忘了在存储的proc退出之前将其设置为off).

The just set it in that stored proc (don''t forget to set it to off before the stored proc exits).

这篇关于C#企业库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！