Windows® Phone 8 Unleashed

LINQ to SQL on the Phone

Retrieval and storage of data in a local database is done entirely using LINQ to SQL, which provides object-relational mapping (ORM) capabilities, allowing you to use LINQ to communicate with a relational database. LINQ to SQL maps the object model, which you define by decorating entity classes with attributes, to a relational database. When your app runs, LINQ to SQL translates language-integrated queries into Transact-SQL and then sends the queries to the database for execution. When the database returns the results, LINQ to SQL translates the results back to objects.

When first learning of Microsoft’s choice to go with LINQ to SQL in Windows Phone, I was somewhat dismayed that it was chosen over the Entity Framework. ...