LINQ is a programming model that introduces queries as a first-class concept into any
Microsoft .NET language. However, complete support for LINQ requires some extensions in the language used. These extensions boost productivity, thereby providing a shorter, meaningful, and expressive syntax to manipulate data.
Following is a simple LINQ query for a typical software solution that returns the names of customers in Germany:
(more…)

If you want to add a record to a table or remove a record from a table, creating or deleting an object in memory is not enough. The DataContext instance must be notified also. This can be
done directly by calling Add or Remove on the corresponding Table collection (these methods
operate on the in-memory copy of the data; a subsequent SubmitChanges call will forward the
SQL commands to the database):
(more…)