StrataFrame Forum » .NET Forums » General .NET Discussion » CLR Stored Procedures

CLR Stored Procedures

Edhy Rijo — Thu, 22 Oct 2009 08:38:18 GMT

Hi,
Can anybody recommend a good book or any other source about creating complex clr stored procedures?

I have a calculation process that I was doing at the client level and due to the large amount of records that needs to be used for lookups (couple of millions) I have to move this process to a Store Procedure.

The process requires some data loops for validations, currently I am taking advantage of the SF BO functionality to Filter and Seek, but I believe in a CLR SP I would not have a BO so I may be working with a data reader object to do the looping and validations.

I will appreciate any information related to managing the data in the CLR SP. I already have a Database Project and a CLR SP created and have done some testing, but need more advance data manipulation samples in order to translate my code in the form into the CLR SP.

Thanks!

RE: CLR Stored Procedures

Edhy Rijo — Thu, 22 Oct 2009 08:38:18 GMT

Thanks Greg, will check it out.

RE: CLR Stored Procedures

Greg McGuffey — Thu, 22 Oct 2009 00:38:44 GMT

I can't recommend it, because I just ordered it and its in the mail, but here is the one I picked:

Programming Microsoft SQL Server 2008 (PRO-Developer)
[codesnippet]https://www.amazon.com/gp/product/0735625999/ref=oss_T15_product[/codesnippet]

I'll let you know what I think once I get it (likely some time next week...did cheapest shipping).