A Cloudy Approach – SQL Data Services

/**
 * Microsoft Student Program - Demo Source
 * 
 * This demo shows how to connect via SOAP to 
 * a SQL Server Data Service and make some query.
 * 
 * 10/18/2008 - [MSP] Denis Dwornitzak
 */
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MSP_SSDS_Demo.SSDSClient;

namespace MSP_SSDS_Demo
{
    class Program
    {
        // Please enter your credentials right here
        static string _UserName = "";
        static string _Password = "";

        static void Main(string[] args)
        {
            using (SitkaSoapServiceClient proxy = new SitkaSoapServiceClient("SitkaSoapEndpoint"))
            {
                // Access to SSDS
                proxy.ClientCredentials.UserName.UserName = _UserName;
                proxy.ClientCredentials.UserName.Password = _Password;
                
                // Definition of the scope
                Scope myContainerScope = new Scope();
                myContainerScope.AuthorityId = "msp-goes-ssds";
                myContainerScope.ContainerId = "actiongames";

                // Sample Query
                string sampleQuery = @"from e in entities where e.Id > ""1"" select e";

                // Process Query
                IEnumerable<Entity> games = proxy.Query(myContainerScope, sampleQuery);

                // List response
                foreach (Entity e in games)
                    Console.WriteLine(e.Properties["Name"]);

                Console.Write("Press any key...");
                Console.ReadKey(true);
            }
        }
    }
}