I found this post from Scott Guthrie's blog. This post enumerate tips, tricks, tutorials as well as link pages to get started with developing Silverlight application.

Last Friday, September 5, I attended the Philippine Launch of SQL Server 2008. Well, the new product is very promising with its new features and functionalities. The most I like is the Policy Based Management - assigning  a certain percentage of resources to set of users.  Also the new datatypes caught my attention. Building reporst seems so easy with this new SQL Server. This product is worth evaluating especially for those with large financial and/or spatial data. 

As I am experimenting with the new feature of VS 2008 - the LINQ, I came across of needing to bind a datasource to an object. The datasource that I want to use is the result of my LINQ query statement. Here is what I got and done.

First, create a LINQ-to-SQL class. 

 

 

Now that I already have my LINQ-to-SQL mark-up language, I can now run a query against it like to any ordinary database. Construct the query statement: 

            var db = new WITWAY_DATADataContext();
            var branches = from branch in db.Branches.AsEnumerable<Branch>()
                           select branch;

 The WITWAY_DATADataContext class is the generated object that the LINQ-to-SQL provided. It is where the representation of our database resides. The generic AsEnumerable<Branch> extension method tells that the we want the query's result to be enumerable of Batch type. 

 Now, bind the result to, say, DropdownList.

if (!IsPostBack)
        {         
            var db = new WITWAY_DATADataContext();
            var branches = from branch in db.Branches.AsEnumerable<Branch>()
                           select branch;

            ddlBranch.DataSource = branches;
            ddlBranch.DataValueField = "uid";
            ddlBranch.DataTextField = "Name";
            ddlBranch.DataBind();
        }