Wolf
|
Posted: 07/12/2004, 1:44 AM |
|
It would be great when in CCS stored procedures for VB.NET would be better supported.
The interface of CCS with sp is very nice and easy to handel, looks like you cann do everything - but:
In the current version of CSS there are no output parameters supported, this includes the return value too...
Now our workaround is to use the recordset of the stored procedure to get back values.
Thats not working for all circumstances, and it would be real great if CCS would do that better.
We use in most kind of DB access (on SQL Server) only sp for some good reasons:
* Great improvement of Security - on most of our tabels users haven't even the select rights and never delete or update rights
* Performance - sp are precompiled on the SQL Server, some procedures work 20-30% faster than send as SQL statement
* Singel point of program logic - checks, selections can be handled in the sp, and in ever yPage of the frontend I work with a tabel (update, insert, delete - even select) i only need to change the sp behind if i want some other logic, checks sorting without even touching the frontend
Willi
|
|
|
E43509
Posts: 283
|
Posted: 07/12/2004, 4:17 AM |
|
I'd like to have the output and return values also!!!
|
|
|
Benjamin Krajmalnik
|
Posted: 07/12/2004, 10:48 PM |
|
Both output parameters and return values are importsnt, in all of the
languages.
We use both PHP and ASP right now, and it is sorely needed on both.
|
|
|
Hans
|
Posted: 08/11/2004, 12:47 PM |
|
Need that a lot. Anyone have a good workaround?
|
|
|
Benjamin Krajmalnik
|
Posted: 09/07/2004, 5:46 PM |
|
There is a great product called ApexSQL which will generate classes to call
stored procedures.
|
|
|
|