LINQ to DataSet utilizes the query features of LINQ, letting you
create queries in your programming language and eliminating the need to place query string literals
in your code. In essence, you get all the features and benefits of LINQ combined with all the features
and benefits of DataSets, such as IntelliSense, syntax checking, and static typing. For instance, how many
times have you had to run and rerun your application to test your inline string query because your syntax
was incorrect? With LINQ to DataSets, you know before your application ever runs whether your query
will execute.
Initially, Microsoft was looking at several options to give developers to populate DataSets using LINQ to
SQL. However, at the time of this writing, the only option available is to use the DataAdapter class. That
is not to say that other methods won??™t be added later, but for now, the DataAdapter class is your only
option.
LINQ to SQL also adds several specific extensions to the DataSet that enable you to access DataRow
objects. Just as important, there are additional things you need to do to your Visual Studio project to
enable LINQ to DataSet functionality.
Pages:
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438