Started using Stored procedure on SQL server today. Much easier than I anticipated.
Still have to deal with returning error codes or error handling, but all in all, have to admit that it's better than having to incorporate SQL commands in the C# code.
A useful link on error handling! Found some other links on 4GuysFromRolla.com site. It's helped quite a bit and even more helpful than the book that I have now!
Porting most of the useful SQL commands in the code into stored procedure will be another thing though! Looks like a separate project on its own!!
Wednesday, August 31, 2005
Subscribe to:
Posts (Atom)