Forums

I have added a new Stored Procedure to our database that returns some filtered rows. Is there an appropriate existing class/file where I should write the call to this SP? As I am fairly new on this area, any sample snippet how this function can be made to return a datatable will be very much appreciated. Thank you and more power!

I need to be passing input parameters so I opted for SP as I am under the assumption that it's faster to move the calculation part at the db's end.

In the same light, how about Scalar functions? I just created a few db functions and I am also wondering where's the best place to reference them and if you can point me to a sample of how it should be done in Splendid.