LINQ to SQL LINQ to DataSet

LINQ to SQL allows querying a relational structure by converting the LINQ query into a native SQL query. This means… that the queries that you write in code generates appropriate queries to access the actual database, AUTOMATICALLY! There are several concepts that you will come to know in this module…
◦ How is the query written using object names (like tables or views)? ◦ How is it validated by the compiler? ◦ When is the query generated? ◦ When is the query executed?



You could either…
◦ Create a class and annotate it with the Table name ◦ Define Fields (which correspond to columns) ◦ Get the Data context (The DataContext class handles the communication between LINQ and external relational data sources) ◦ Create a Generic type ◦ Query through LINQ



OR… use LINQ to SQL Classes in VS 2008

   





Data abstraction Working with Strongly Typed objects Tied to the object model