This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi there, I'm using sql server 2000 and therefore have done the connection manually. I have created a non-query stored procedure in the entity model that matches a stored procedure in the database (Insert stored proc). How can I use it without having to declare select, delete and update (As I'd like to use the default for this). Is this supported? This stored procedure is meant to insert data to a composite keyed table. Thank you Sally |
|
|
|
|
No, this is not currently possible (though it is on the wish list) -- if you are using a sproc for one CRUD operation you must use sprocs for all CRUD operations. The scenario that CRUD procedures aim to support is when an architect has mandated that all database access be through sprocs and apps are not allowed to access tables directly. However you should be able to use normal table inserts on SQL Server 2000. So there should be no need to use CRUD procedures at all. What problem are you seeing with the default insert? |
|
|
|
