<div>
Retrieving data from a DB is no different in WCF than it is in a WinForms or Console application. As far as turning that data into a List, use the ExecuteReader method of your command object. Then it is simply a matter of continually calling <i>Read</i> against the resulting DataReader until it returns false, and within the loop add each datum to your list.<br />
<br />
You can simply specify the return type of your WCF method as List&lt;XXX&gt; (I'm guessing XXX will be <b>string</b> for your purposes). The runtime will take care of serializing that object into XML for you.
</div>


Retrieving data from a DB is no different in WCF than it is in a WinForms or Console application. As far as turning that data into a List, use the ExecuteReader method of your command object. Then it is simply a matter of continually calling Read against the resulting DataReader until it returns false, and within the loop add each datum to your list.

You can simply specify the return type of your WCF method as List<XXX> (I'm guessing XXX will be string for your purposes). The runtime will take care of serializing that object into XML for you.

<div>
Thanks this template helped me create my own.
</div>


Thanks this template helped me create my own.

<div>
template was able to help me create a WCF per my requrements
</div>


template was able to help me create a WCF per my requrements

<div>
<div class="content wysiwyg-content">
Can anyone provide me a simple example of how to get data using WCF from a database preferably returning a List&lt;&gt;. &nbsp;I have a SPROC set up in the database which will return the data.<br />
<br />
Thanks
</div>
</div>


Can anyone provide me a simple example of how to get data using WCF from a database preferably returning a List<>.  I have a SPROC set up in the database which will return the data.

Thanks

WCF Get Data from database as List&lt;&gt;

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).

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.

WCF Get Data from database as List&lt;&gt;

WCF Get Data from database as List<>