It would certainly simplify the equation to get rid of one side or the other.
Yet relational databases provide critical infrastructure for long-term storage and query processing, and modern programming languages are indispensable for agile development and rich computation.
The first step in building a LINQ to SQL application is declaring the object classes you will use to represent your application data. We will start with a simple class Customer and associate it with the customers table in the Northwind sample database.
To do this, we need only apply a custom attribute to the top of the class declaration.
If no Name property is supplied, LINQ to SQL will assume the database table has the same name as the class.
Only instances of classes declared as tables will be stored in the database.
LINQ to SQL defines the Table attribute for this purpose.
The samples in this document are shown in both C# and Visual Basic; LINQ to SQL can be used with the LINQ-enabled version of the Visual Basic compiler as well.Rows exist as elements of tables, vanishing as soon as they are removed.It is no wonder that applications expected to bridge this gap are difficult to build and maintain.It does this by translating language-integrated queries into SQL for execution by the database, and then translating the tabular results back into objects you define.Your application is then free to manipulate the objects while LINQ to SQL stays in the background tracking your changes automatically.Yet there is a huge divide between modern programming languages and databases in how they represent and manipulate information.