Using LINQ to SQL for creating the service
LINQ to SQL is the family of LINQ technologies targeting relational databases where data is mapped as objects. LINQ to SQL provides the fastest way to create an interface to the backend. The only disadvantage is it can only map one level of relationship. So, if you need deeper relationship management, the Entity Framework is the way to go. Some of the features of LINQ to SQL are as follows:
Translates LINQ expression to T-SQL (Transact-SQL)
Provides an easy way to query objects instead of SQL statements
Has the ability to create databases and tables in the database
Provides a way to query the database using regular T-SQL statements
In this recipe, let's build the MyTask service like the preceding recipe, but instead of using the Entity Framework we will use LINQ to SQL classes.
Getting ready
Open the Visual Studio and create a new project using the WCF Service Application template and name it Recipe4_LINQToSQL under the CH7 folder. Right-click on App_Data...
