We will not be
able to validate the query, which is passed as text strings, until it gets compiled and
executed at the database server. We cannot make use of IntelliSense or the debugging
feature of the development environment to validate
the queries.
Using LINQ to SQL, we can manage relational data as objects at run time using the
querying facility. The LINQ queries get translated to SQL queries for the database to
execute the queries, and the results are again translated to objects for the application
to understand. LINQ uses the same connection and transaction features of current
.NET framework for connecting to the database and manipulating the data under
transaction. We can also make use of the IntelliSense feature for validating LINQ
queries. To represent relational data, we need to create classes for the entities. For
creating the entity classes, we need to specify some custom attributes to the class
declaration. This is to make the entity objects have similar properties as that of the
database objects.
Pages:
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27