Using LINQ to SQL in Windows Phone 7

LINQ to SQL allows .NET developers to write “queries” in their .NET language, lets have a look how to use it in windows phone 7.

LINQ to SQL allows .NET developers to write “queries” in their .NET language of choice to retrieve and manipulate data from a SQL Server database. It is the data model of a relational database is mapped to an object model expressed in the programming language of the developer. It solves the mismatch between the object oriented and relational database world. In an application we deal in terms of our domain objects such as customer and orders. When the application runs, LINQ to SQL translates into SQL the language-integrated queries in the object model and sends them to the database for execution. When the database returns the results, LINQ to SQL translates them back to objects that you can work with in your own programming language.

Steps to using LINQ to SQL

• Create a new database and table and insert record in SQL
  
  
  
  
  
• Create new windows phone application
  
  
  
• Go to your solution file and add new WCF service application in your project
  
  
  
• Add new LINQ to SQL class in WCF service
  
  
  
• Attache you database to the project
  
  
  
  
  
• Drag you table
  
  
  
• View service.svc file in browser
  
  
  
• Add service references
  
  
  

Now you database is attached to the project you can use you data of the table.

Thank You..