Data Entry with LINQ to SQL

This sample walks through how to use the new LINQ to SQL classes on your data-entry Windows Forms. One form that demonstrates Combobox filtering uses the Northwind database. The One-to-Many form uses a sample SQL 2005 Express database that is included. That form demonstrates how to properly update, insert and delete records and how to configure the LINQ to SQL classes so that they use stored procs for their update, insert and delete behaviors. It also demonstrates how to add validation messages to the LINQ to SQL classes and have them automatically display in the UI with the ErrorProvider.

Download the code!

Articles that go with this sample:

Related Data Binding and ComboBoxes with LINQ to SQL

Creating Lookup Lists with LINQ to SQL

One-To-Many (Master-Detail) Forms with LINQ to SQL

Simple Validation with LINQ to SQL Classes

This sample uses a local SQL database. Make sure you read this article if you are having problems working with the database.