Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored procedures vs. functions
Message
From
08/07/2008 08:21:29
John Baird
Coatesville, Pennsylvania, United States
 
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 2.0
OS:
Windows 2000
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01329296
Message ID:
01329675
Views:
11
>BLG is the Mere Mortals Business Layer Generator. Referencing stored procedures is one of the enhancements in version 2.4.
>
>>>I have been working with someone who is a more experienced SQL programmer than I. He suggested that I use functions rather than procedures for single table returns. When I use functions rather than procedures the code compiles without any problem. However, I notice that the BLG does not list the functions. Will using functions cause problems down the line? Thanks.
>>
>>What is BLG and this is an interesting statement, I'd like more information about it.


I think that the advice to use funcitons over stored procs is a bit off the mark. Could you post the reasons why that statement is made?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform