IS CLR存储过程是一个非常有用的东西 [英] IS CLR Stored Procedure a really useful stuff

问题描述

HI团队，

我试图在我的一个应用程序中使用名为CLR Assembly的概念，我们在文本文件中提交数据，然后从文本文件中获取记录csv格式到SQL表使用c＃进程，从那里我们做了一些代价高昂的操作。

所以我想为什么我们不能去CLR Storeprocedure这样它可以在一个单独的SP中完成上述所有操作但是我有一些问题需要微软从Framework 4.0中避免使用CLR SP吗？是因为失败。

如果没有，如果有任何人认为这是一个不错的选择，请向我提供一些有助于执行复杂操作的高级教程

HI Team,
Iam trying to make use of the Concept called CLR Assembly in one of my application in which we are having data comming in text files and then we fetch record from text which is in csv format to SQL Table using c# process and from there we do some costly operation.
so i thought why cant we go for CLR Storeprocedure so that it can do all this above mentioned operations in one single SP it self.But i have some questions in mind why Microsoft avoided CLR SP from Framework 4.0 ? is that because of failure.
if not if any body felt that this is a good option please provide me with some advanced tutorials on it which may help to perform complex operations

推荐答案

你问一个不确定的问题。没有进一步的细节，很难提出建议。如果您希望答案为：是的，CLR真是好东西！然后你可能无法在这里得到它。它看起来像是某种不适合的调查。 CLR适用于某些任务，而且适用于其他任务。

作为替代方案，可能只使用SSIS来处理csv，而不是CLR存储过程。但是如果你计划进行任何复杂的计算或字符串操作，你应该使用CLR。

尝试参考此链接 [ ^ ]了解详情。

You ask an uncertain question. It is hard to make suggestions without further details. If you expect answer as: "Yes, CLR is really good stuff!" then you probably couldn''t get it here.It looks like some kind of survey which is not in the right place. CLR is good for some tasks, and poorly applicable for others.
As alternative one might use SSIS simply to deal with csv, not the CLR stored procedures. But if you plan to make any complex calculation or strings manipulation you should use CLR.
Try refer this link[^] for details.

这篇关于IS CLR存储过程是一个非常有用的东西的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！