Two main ways to interact with the database: using a stored procedure vs. using a direct SQL statement. Here's a brainstorm of the pros and cons to each:
|Technique (called from managed code):||Pro||Con|
|Stored Procedure|| || |
|Sql Statement|| || |
In general (of what I've seen), many enterprise apps will use Stored Procs, while sometimes a RAD will use raw SQL statements.
What has your experience been?