Simple LINQ - SQL Connecting Program in C#
LINQ - Language Integrated Query.It provides the Querying ability to the database and also doing the DML operations such as insert, update and delete.for more about LINQ, have a look at http://msdn.microsoft.com/en-us/library/bb308959.aspx There are infinite pages are available to describe the Linq, its functionality, and design. But for a beginner, let us go with creating a simple application using Linq and playing with database. Before writing the program, we need to know the following basic things. 1. DataContext This is a Layer or cache kind of stuff which interacts between the database and application. The application uses the datacontext to manipulate data with the database. 2. dbml - Database Markup Language Linq to SQL class is known as dbml. The dbml maintains the tables and linkings. Now we start with creating simple program. The aim of the program is to display the Northwind customers data whose names are starting with "a" in a datagrid. Step 1: Create new C# wi