IS CLR Stored Procedure a really useful stuff

Question

1.00/5 (2 votes)

See more:

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

Posted 22-May-13 4:26am

KK Kod

Updated 22-May-13 4:27am

v2

Add a Solution

Comments

joshrduncan2012 22-May-13 10:41am

Have you checked with google to see if there are any available? Great place to start.

ZurdoDev 22-May-13 10:53am

What do you mean by "Microsoft avoided CLR SP from Framework 4.0 ?" I have used CLR SPs in .Net 4.0.

KK Kod 22-May-13 23:16pm

i dosent mean that ,why MS not promoting using this feature in 4.0 .. :)

KK Kod 22-May-13 23:20pm

Could you please provide details on how effectively can we use and how to write complex queries in this . i found that we have to use Queries as command parameters ,if i want to do complex joins and all how can we write the query with out proper formatting.it would look clumsy code right ..?

ZurdoDev 23-May-13 7:30am

I have only done CLR SPs a few times. I would recommend reading up on them on Microsoft's site.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

skydger · Accepted Answer · 2013-05-22T09:11:00

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 Stored Procedure a really useful stuff

1 solution

Solution 1

Add your solution here

Preview 0

IS CLR Stored Procedure a really useful stuff

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us