Linq
< C# and ASP
< Work
< jayempee
Get flash to fully experience Pearltrees
Over the last few months I wrote a series of blog posts that covered some of the new language features that are coming with the Visual Studio and .NET Framework "Orcas" release. Here are pointers to the posts in my series: The above language features help make querying data a first class programming concept. We call this overall querying programming model "LINQ" - which stands for .NET Language Integrated Query . Developers can use LINQ with any data source.
Introduction This article focuses on how to read XML content and perform a bulk insert to a database using LINQ to XML, LINQ to SQL, and LINQ, and discusses the significance of LINQ. Background Commercial applications often require bulk data from various sources. This data is commonly available in the format of XML, and it requires the data to be updated in to the application's database.
LINQ (language integrated query) is one of the new features provided with VS 2008 and .NET 3.5. LINQ makes the concept of querying data a first class programming concept in .NET, and enables you to efficiently express queries in your programming language of choice. One of the benefits of LINQ is that it enables you to write type-safe queries in VB and C#. This means you get compile-time checking of your LINQ queries, and full intellisense and refactoring support over your code: While writing type-safe queries is great for most scenarios, there are cases where you want the flexibility to dynamically construct queries on the fly. For example: you might want to provide business intelligence UI within your application that allows an end-user business analyst to use drop-downs to build and express their own custom queries/views on top of data.
In previous parts of this series of articles about LINQ to SQL I already covered the following topics : Part 4 will cover : Visualizers LINQ to SQL Visualizer Expression Tree Visualizer Refresh Refresh (re-execute) query Refresh one object Dynamic Where-clause Anonymous functions and IEnumerable Lambda expression trees and IQueryable PredicateBuilder class and combining expressions Predicate library Dynamic OrderBy-clause Anonymous functions and IEnumerable Lambda expression trees and IQueryable Predicate library Visualizers Visualizers are Visual Studio plugins which allow developers to view objects and data using a specialized user interface while debugging. It seems that the LINQ to SQL Visualizer and Expression Tree Visualizer are not installed by default within Visual Studio 2008 RTM.