This question is locked. New answers and comments are not allowed.
Hello!
I have created the following view in ORACLE (10g):
CREATE OR REPLACE VIEW VW_VC as
select vc.*,
(select bp_s_name from vw_vcbp where vcbp_s_vc_key=vc_s_key nd vcbp_B_default=1) bp_s_name
from vc
The view shows all fields from the table VC and one additional field BP_S_NAME, which is only for reading. In the .rlinq file I inserted the view and changed the following properties of the column BP_S_NAME:
- Kind to "PersistentReadOnly"
- Nullable to "True"
If I make an insert onto the view directly in Oracle it works, but if I make an insert through my silverlight application there comes an error.
Meldung: Unhandled Error in Silverlight Application
Code: 4004
Category: ManagedRuntimeError
Message: System.ServiceModel.DomainServices.Client.DomainOperationException: Submit operation failed validation. Please inspect Entity.ValidationErrors for each entity in EntitiesInError for more information.
bei System.ServiceModel.DomainServices.Client.OperationBase.Complete(Exception error)
bei System.ServiceModel.DomainServices.Client.SubmitOperation.Complete(OperationErrorStatus errorStatus)
bei System.ServiceModel.DomainServices.Client.DomainContext.CompleteSubmitChanges(IAsyncResult asyncResult)
bei System.ServiceModel.DomainServices.Client.DomainContext.<>c__DisplayClassd.<
SubmitChanges
>b__5(Object )
Has anyone already tried to make an insert onto a database view??? How can I solve my problem?
Thanks for your help,
regards Richard Koslik