<div>
If you execute the stored procedure, and don't convert it to an IList, do you get the correct results?
</div>


If you execute the stored procedure, and don't convert it to an IList, do you get the correct results?

<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
I'm trying to retrieve whole custom table from a stored procedure ( SLClient_ContractPage() ) in (.Net C# Silverlight), but with no success so far;<br />
<br />
Using the ORM designer (drag-drop stored procedure, recreated the dbml file)<br />
<br />
Created funciton in the DomainService (web project):<br />
<br />
public IList&lt;SLClient_ContractPag<wbr />eResult&gt; SP_ContractsData()<br />
&nbsp; &nbsp; &nbsp; &nbsp; {<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return this.Context.SLClient_Cont<wbr />ractPage()<wbr />.ToList&lt;SL<wbr />Client_Con<wbr />tractPageR<wbr />esult&gt;();<br />
&nbsp; &nbsp; &nbsp; &nbsp; } <br />
<br />
Then, from DomainContext (on silverlight project), when I execute the above method and gather the results, the number of it is proper (105 records in my case), but only one record is repeated 105 times!<br />
<br />
I debugged the situation, and seen that on the server I have retrieved the all data, but on the client only the first record is repeating itself for as many times as there is data in the server...<br />
<br />
Can you tell me what could cause this situation?
</div>
</div>


Hi 

I'm trying to retrieve whole custom table from a stored procedure ( SLClient_ContractPage() ) in (.Net C# Silverlight), but with no success so far;

Using the ORM designer (drag-drop stored procedure, recreated the dbml file)

Created funciton in the DomainService (web project):

public IList<SLClient_ContractPageResult> SP_ContractsData()
        {
            return this.Context.SLClient_ContractPage().ToList<SLClient_ContractPageResult>();
        } 

Then, from DomainContext (on silverlight project), when I execute the above method and gather the results, the number of it is proper (105 records in my case), but only one record is repeated 105 times!

I debugged the situation, and seen that on the server I have retrieved the all data, but on the client only the first record is repeating itself for as many times as there is data in the server...

Can you tell me what could cause this situation?

Linq2Sql executing stored procedures (Silverlight)

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Windows Communication Foundation (WCF) is a tool used to implement and deploy a service-oriented architecture (SOA) to support distributed computing where services have remote consumers. It features a runtime and a set of APIs in the .NET Framework for building connected, service-oriented applications. Services typically have a WSDL interface (Web Services Description Language) that any WCF client can use to consume the service, regardless of which platform the service is hosted on. WCF implements many advanced Web services (WS) standards such as WS-Addressing, WS-ReliableMessaging, WS-Security, RSS Syndication Services, WS-Discovery, routing and better support for REST services.

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).