I am new to silverlight and entity framework.
I have read article for solution and follwed, but no solution resolved my issue:
http://www.silverlightshow.net/items/WCF-RIA-Services-Part-1-Getting-Started.aspx
and
http://elmerdpadilla.wordpress.com/2013/03/26/exponer-datos-desde-procedimientos-almacenados-en-wcf-ria-services-para-silverlight/[^].
I have one issue in adding new/modifying existing Stored Procedure in EDMX.
I am working on already developed Silverlight Project(Silverlight version-5) with Entity Framework(EF version -4.0)
Softwares installed:
-------------------
Visual Studio 2010 SP1
Silverlight 5 sdk
In Edmx,
Tables, Stored Procedures, function import and complex types also created.
Problem:
-------
When i try to add any new stored procedure in EDMX, the Silverlight.Web(assuming as projectname.web) is building successfully.
Wherever i used the complex types in Silverlight Project not getting reference. If just i try to modify anything in EDMX getting the reference could not be found error.
The syntaxes i have tried in "Domain Service Class" is as follows:
public ObjectResult
{
return this.ObjectContext.Certification_Details();
}
And in .xaml.cs file using the following code to load grid:
MyDomainContext DBContext = new MyDomainContext();
LoadOperation
CertifiedGrid_details.ItemsSource = load.Entities;
CertifiedGrid_details.DataContext = DBContext.Certification_Details_Results;
Error:
-----
The type or namespace name 'Complex_Type_Result' could not be found (are you missing a using directive or an assembly reference?)
Can you please suggest me, how can i resolve this errors?
Piyush PansuriyaPosted Dec 10, 2014, 5:11 AM
Seeing your problem, I think you have to add different project WCF Service Application.
Add EDMX model in this project. User Service.svc for Select, Insert, Update, Delete operation.
After that add servicereference to silverlight project of this WCF Application.
Than After you can get data from database in result of the method which you have created in service.svc