StrataFrame Forum
Back
Login
Login
Home
»
.NET Forums
»
General .NET Discussion
»
CLR Stored Procedures
CLR Stored Procedures
Post Reply
Like
2
CLR Stored Procedures
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Edhy Rijo
E
Edhy Rijo
posted 15 Years Ago
ANSWER
Topic Details
Share Topic
E
Group: StrataFrame Users
Posts: 2.4K,
Visits: 23K
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!
Edhy Rijo
Reply
Like
2
Greg McGuffey
Greg McGuffey
posted 15 Years Ago
ANSWER
Post Details
Share Post
Group: Forum Members
Posts: 2K,
Visits: 6.6K
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)
https://www.amazon.com/gp/product/0735625999/ref=oss_T15_product
I'll let you know what I think once I get it (likely some time next week...did cheapest shipping).
Reply
Like
2
Edhy Rijo
E
Edhy Rijo
posted 15 Years Ago
ANSWER
Post Details
Share Post
E
Group: StrataFrame Users
Posts: 2.4K,
Visits: 23K
Thanks Greg, will check it out.
Edhy Rijo
Reply
Like
2
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Post Reply
Like
2
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search