Linq

LINQ to PostgreSQL Tutorial
This tutorial guides you through the process of creating a simple application powered by LINQ to SQL technology. In less than 5 minutes you will have a ready-to-use dataaccess layer for your business objects.

In this walkthrough:

Introducing the LINQ to SQL Technology
Requirements
Preparing the Project
Generating Model from Database
Querying DataInserting New Data
Updating Data
Deleting Data
Additional Information
Introducing the LINQ to SQL Technology
LINQ stands for Language-Integrated Query, which means that data retrieval is no longer aseparate language. The LINQ engine allows .NET applications to connect to databases without bothering much about columns and rows. The data you receive is automatically formed as objects ready to use byyour business logic.

LINQ to Relational Data may be thought of as an object-relational mapping (ORM) tool. The type-safe LINQ queries get compiled into MSIL on the fly, and the query clauses aretranslated into SQL and sent to PostgreSQL server for execution. This makes your data access layer safer, faster, and greatly more convenient to design.

Requirements
In order to connect toPostgreSQL server you need the server itself running, dotConnect for PostgreSQL installed and IDE running. LINQ to SQL requires .NET Framework 3.5, Visual Studio 2008, and PostgreSQL server 8.0 or higher.Note that LINQ to PostgreSQL feature is only available in Professional Edition of dotConnect for PostgreSQL.

In this tutorial it is assumed that you already have the database objects created. Youhave to execute a script from the following file if you have not done so yet:
\Program Files\Devart\dotConnect\PostgreSQL\Samples\crm_demo.sql

Preparing the Project
Create a new console applicationin Visual Studio. It could be any other project type as well, but for simplicity's sake we'll use console project throughout the tutorial. The rest of the tutorial assumes that the name of the...