Error in Silverlight project in ASP.NET with LINQ

AmandaP

New Member
I want to make a simple Silverlight application in ASP.NET and LINQ. I have two talbe \[quote\] Student :[student_id,student_name,address, phone,country_id] Country :[country_id,country_name]\[/quote\]Thiw tow table is join by country_id. I have inluced a LINQ Data Class in my project. I have included a Silverlight-Enabled-WCF-Serfice. In this service I have made tow method and there code is like\[code\][OperationContract] public List<Country> LoadCountry() { var result = from coun in oLINQDataClassesDataContext.Countries select coun; return result.ToList(); } [OperationContract] public IList<Student> LoadStudent() { var result = from std in oLINQDataClassesDataContext.Students select std; return result.ToList(); }\[/code\]Then I add a service reference of that WCF service. Then I include a DataGrid in my silverlight .xml file.Now I want to show all the students in that DataGrid. For this I have written the following codeWCFServiceReference.WCFServiceClient oWCFServiceClient = new WCFServiceReference.WCFServiceClient();\[code\] public Home() { InitializeComponent(); oWCFServiceClient.LoadStudentCompleted += new EventHandler<WCFServiceReference.LoadStudentCompletedEventArgs>(oWCFServiceClient_LoadStudentCompleted); oWCFServiceClient.LoadStudentAsync(); } void oWCFServiceClient_LoadStudentCompleted(object sender, WCFServiceReference.LoadStudentCompletedEventArgs e) { dataGrid1.ItemsSource = e.Result; }\[/code\]Then I build the whole project and found no error. If I run the project then I found an error and it is--\[quote\] An exception occurred during the operation, making the result invalid. Check InnerException for exception details. at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary() at Silverlight.WCFServiceReference.LoadStudentCompletedEventArgs.get_Result() at Silverlight.Home.oWCFServiceClient_LoadStudentCompleted(Object sender, LoadStudentCompletedEventArgse) at Silverlight.WCFServiceReference.WCFServiceClient.OnLoadStudentCompleted(Object state)\[/quote\]If I remove county table form the LINQ class and remove LoadCountry() method form the service and call LoadStudent() method form silverlight form then it runs accurately and all the data is displayed in my DataGrid. If I remove student table form the LINQ class and remove LoadStudent() method form the service then LoadCountry() method runs accurately. Both methods are not work if the present same time in LINQ & WCF Service .NB: Both tables has data. If I run a SQL join query then it returns dataI can
 
Back
Top