sql server 2008 r2 - How to get UserID from Entity Framework/Wcf Service in Delete trigger in DB? -
sql server 2008 r2 - How to get UserID from Entity Framework/Wcf Service in Delete trigger in DB? -
suppose have table mytab(id, ..., userid) info like
(id=1, ..., userid =123)
then sl app + wcf ria service + ef, user userid = 456 run app , seek delete above 1 row data. did remove entity instance entityset wcf ria service, submitchanges. code like:
mytab.userid = 456; context.mytabs.remove(mytab); context.submitchanges(....);
but in delete trigger, can't info userid = 456 because delete, not update. how userid =456 in delete trigger case?
entity-framework sql-server-2008-r2 entity-framework-4.1 wcf-ria-services silverlight-5.0
Comments
Post a Comment