public class TestDataService : DataService<EntityLib.MyEntities>
{
	public static void InitializeService(DataServiceConfiguration config)
	{
		config.SetEntitySetAccessRule("*", EntitySetRights.All);
		config.SetServiceOperationAccessRule("*", ServiceOperationRights.All);
		config.DataServiceBehavior.MaxProtocolVersion = DataServiceProtocolVersion.V3;
	}

	[WebGet]
	public int GetInt()
	{
		return 1;
	}

	[WebGet]
	public List<String> GetStringList()
	{
		List<String> myList = new List<String>();
		myList.Add("First string");
		myList.Add("Second string");
		myList.Add("Third string");

		return myList;
	}

	[WebGet]
	public IQueryable<EntityLib.Order> GetOrderById(int orderId)
	{
		var res = this.CurrentDataSource.Order.Where(o => o.OrderID == orderId);
		return res;
	}

	[WebGet]
	public IQueryable<EntityLib.uspGetOrdersByCustomer_Result> uspGetOrdersByCustomer(int customerId)
	{
		var res = CurrentDataSource.uspGetOrdersByCustomer(customerId).AsQueryable();
		return res;
	}
}

public partial class MainWindow : Window
{
	public MainWindow()
	{
		InitializeComponent();
		context = new DataServiceContext(new Uri("http://localhost:4637/MainDataService.svc/"));
	}

	DataServiceContext context;

	private void btnGetInt_Click(object sender, RoutedEventArgs e)
	{
		IEnumerable<int> varInt = context.Execute<int>(new Uri("http://localhost:4637/MainDataService.svc/GetInt"));
		this.tbckGetInt.Text = varInt.LastOrDefault().ToString();
	}

	private void btnGetStringList_Click(object sender, RoutedEventArgs e)
	{
		IEnumerable<String> stringList = context.Execute<String>(new Uri("http://localhost:4637/MainDataService.svc/GetStringList"));
		this.dgStringList.ItemsSource = stringList;
	}

	private void btnGetOrderById_Click(object sender, RoutedEventArgs e)
	{
		string uri = string.Format("http://localhost:4637/MainDataService.svc/GetOrderById?orderId={0}", this.tbxGetOrderById.Text);
		IEnumerable<MainDataServiceReference.Order> orderById = context.Execute<MainDataServiceReference.Order>(new Uri(uri));
		this.dgOrderById.ItemsSource = orderById;
	}

	private void btnUspGetOrdersByCustomer_Click(object sender, RoutedEventArgs e)
	{
		string uri = string.Format("http://localhost:4637/MainDataService.svc/uspGetOrdersByCustomer?customerId={0}", this.tbxUspGetOrdersByCustomer.Text);
		IEnumerable<MainDataServiceReference.uspGetOrdersByCustomer_Result> ordersList = context.Execute<MainDataServiceReference.uspGetOrdersByCustomer_Result>(new Uri(uri));
		this.dgOrdersByCustomer.ItemsSource = ordersList;
	}
}

CREATE PROCEDURE [dbo].[uspGetOrdersByCustomer](@customerId INT)
AS
BEGIN
	SET NOCOUNT ON;

	SELECT OrderID, CustomerID, OrderDate FROM dbo.[Order] WHERE (CustomerID = @customerId)
END