مزایای کار با CLR

[irpersian20]

سلام

من با CLR به وسیله سی شارپ یک ST خیلی ساده نوشتم که تعداد سطر بر می گرداند.
حالا با توجه به اینکه چند مرحله بیشتر دارد این مورد.
واقعا کی باید رفت کوئری را در سی شارپ نوشت و جه مزایا و معایبی دارد؟

[tooraj_azizi_1035]

مزایا:

Among the major benefits of this integration are:


A better programming model. The .NET Framework languages are in many respects richer than Transact-SQL, offering constructs and capabilities previously not available to SQL Server developers. Developers may also leverage the power of the .NET Framework Library, which provides an extensive set of classes that can be used to quickly and efficiently solve programming problems.
Improved safety and security. Managed code runs in a common language run-time environment, hosted by the Database Engine. SQL Server leverages this to provide a safer and more secure alternative to the extended stored procedures available in earlier versions of SQL Server.
Ability to define data types and aggregate functions. User defined types and user defined aggregates are two new managed database objects which expand the storage and querying capabilities of SQL Server.
Streamlined development through a standardized environment. Database development is integrated into future releases of the Microsoft Visual Studio .NET development environment. Developers use the same tools for developing and debugging database objects and scripts as they use to write middle-tier or client-tier .NET Framework components and services.
Potential for improved performance and scalability. In many situations, the .NET Framework language compilation and execution models deliver improved performance over Transact-SQL.





منبع:http://msdn.microsoft.com/en-us/library/ms131089.aspx