Database operations using Silverlight 2.0 WCF and LINQ to SQL
(Page 1 of 5 )
This is my fifth article in a series focusing on Silverlight 2.0 development using Visual Studio 2008. Technically, we will have Silverlight 2.0 controls accessing a regular WCF Service and doing CRUD operations against a database using the “LINQ to SQL” model.
This article assumes that you have a minimum knowledge of technologies like “LINQ to SQL,” “WCF,” “Silverlight” and so forth. If you don’t, and if you need step-by-step walk-throughs for the above technologies, please go to the following links.
If you are new to Silverlight 2.0 development, please refer to the following articles that I have written before reading the rest of this one (available at http://www.aspfree.com/cp/bio/Jagadish-Chatarji/):
Beginning Silverlight 2.0 Development using Visual Studio 2008
Developing a Silverlight 2.0 Application that Consumes a WCF Service Using Visual Studio 2008
Silverlight 2.0 Application Development with “LINQ to SQL” and WCF Service (HIGHLY RECOMMENDED)
Introducing Two-Way Data Binding using Silverlight 2.0, WCF and “LINQ to SQL”
This article is based on the following configuration:
To make this article simple, I created a table structure as seen at http://cid-41050f68f010a662.skydrive.live.com/self.aspx/Public/images/DeptEmp.gif
The entire source code for this article is available in the form of a free downloadable zip file. The solution was developed using Microsoft Visual Studio 2008 Team Edition (with SP1) with Microsoft SQL Server 2008 Developer Edition on Microsoft Windows Server 2003 Standard Edition (with SP2) with Silverlight 2.0 (RTM). I didn’t really test it in any other environment. I request that you post in the discussion area if you have any problems in execution.
Next: Developing a WCF Service to interact with LINQ to SQL for all CRUD operations >>
More Windows Scripting Articles
More By Jagadish Chaterjee