Insert and Update Stored Procedures in RIA


  •  Hi

    I have a few issue with using  RIA with my existing database.

    1) My database uses the same stored procedures for doing updates and inserts, an id of 0 is sent to the sp if its an insert then the new id is returned. In the Entity Data Model it doesnt seem to allow the same sp to be used for both, is their any way round this?

    2) All of my stored procedures require me sending the username of the person doing the operation with the entity parameters. I can't seem to find a way in the Entity Data Model of allowing me to send in parameters from outside the entity I'm working on, any solutions? I can't be the only person who needs to do this?

    I have been looking for a while but can't seem to find any way round both these issues, any help would be greatly appriecated.



    Tuesday, December 08, 2009 12:02 PM