What is LINQ

Introduction to LINQ:

LINQ stands for Language Integrated Query. This is new technology in latest .Net Framework 3.5.
“Microsoft original motivation behind LINQ was to address the impedance mismatch between programming languages and database.”
-Anders Hejlsberg
What is LINQ?
If someone wants to develop database application on .Net platform the very simple approach he uses ADO.Net. ADO.Net is serving as middle ware in application and provides complete object oriented wrapper around the database SQL. Developing application in C# and VB.Net, so developer must have good knowledge of object oriented concept as well as SQL, so it means developer must be familiar with both technologies to develop an application.
LINQ is a set of extensions to the .NET Framework that encompass language-integrated query, set, and transform operations. It extends C# and Visual Basic with native language syntax for queries and provides class libraries to take advantage of these capabilities.
LINQ defines a set of query operators that can be used to query, project and filter data in arrays, enumerable classes (implementing IEnumerable interface), XML, relational database, and third party data sources. While it allows any data source to be queried, it requires that the data be encapsulated as objects. So, if the data source does not natively store data as objects, the data must be mapped to the object domain. Queries written using the query operators are executed either by the LINQ query processing engine or, via an extension mechanism, handed over to LINQ providers which either implement a separate query processing engine or translate to a different format to be executed on a separate data store (such as on a database server as SQL queries). The results of a query are returned as a collection of in-memory objects that can be enumerated.

LINQ and Productivity:
Increase productivity and reduce run-time errors in your applications by using strongly typed objects instead of embedded SQL query syntax.
1) Optimize development efforts: Help to become more productive and optimize the overall application development effort by using a single consistent query language for all aspects of the application
2) Reduce bugs and errors (due to compile time checking): LINQ Works with strongly typed CLR objects that reduce run-time errors in applications. Identify query-related coding errors at compile time and reduce the debugging effort by using strongly typed variables
3) Be more productive with Microsoft Visual Studio: Maximize developer efficiency when writing code that includes strongly typed data objects and take full advantage of the productivity enhancing capabilities of Visual Studio, such as the object browser and IntelliSense, debugging, and rich refactoring support
4) Extensibility: LINQ let you to easily adapt to the needs of a particular application scenario by taking advantage of several data source-specific implementations of LINQ to query various types of data.
Which is the Assembly for LINQ?
The base LINQ functionality is located in Syste.Core.dll. All Default projects in VS 2008 readily include reference to this assembly. The Namespace for LINQ is “System. Linq”.
For inline coding in ASP.net add
<%@ import Namespace=”System. Linq” %>
For Code Behind Model
using System.Linq;

Types LINQ Query: There are three basic types of LINQ queries.
a) LINQ to Objects
b) LINQ to XML
c) LINQ to SQL

Comments

Post a Comment

Popular posts from this blog

GROUP BY, CUBE, ROLLUP and SQL SERVER 2005

Image
  I learn about CUBE and ROLLUP function today and I found it really usefull for generating reports. Let me give you one example where we can use ROLLUP and CUBE. Lets say you are developing the E-Commerce application and administrator wants the report which shows products purchased by all user group by product and buyer. You will say that’s really easy and can write the query as shown below, 1: SELECT CustomerName,CustomerName,SUM(Quantity*PricePerItem) 2: FROM Orders GROUP BY CustomerName,CustomerName Fig – (1) Group By clause.      Which will returns the result as shown below, Fig – (2) Result of GROUP BY clause     However what if you want result as display below, Fig – (3) Desire result        Here ROLLUP and CUBE comes into the picture and help us. The above result is generated using ROLLUP.  ROLLUP adds new row for each column used in GROUP BY clause. First have a look ...
Read more

How to get content of Ckeditor & Fckeditor using Javascript

CKEDITOR: To get content of ckeditor we will create object of ckeditor and then we will provide id of textarea that is replaced by ckeditor. Syntax: CKEDITOR.instances.textarea_id.getData();getData(); Where CKEDITOR.instances   :  gives all the instances of CKEDITOR; textarea_id   : it is ID of textarea that is containing data ; getData()       : return content of Ckeditor current instance. FCKEDITOR: To get content of Fckeditor we will create Instance of Fckeditor for textarea and then we will get data using GetHTML method. Syntax : FCKeditorAPI.GetInstance('textarea_id'). GetHTML(); Where textarea_id     :  it is ID of textarea that is containing data ; GetHTML()             :  This function returns content of textarea with id textarea_id.  
Read more

How to Fix Error- Sys.WebForms.PageRequestManagerTimeoutException - The server request timed out

To solve this problem we can increase the timeout. You can change the timeout time by adding a new property to the script manager control. This property is called AsyncPostBackTimeOut and it can help us to define the number of seconds before the request will throw a request timeout exception*. For example if you want that the timeout will take maximum 10 minutes your code should be look like this: < asp : ScriptManager ID ="ScriptManager1" runat ="server" AsyncPostBackTimeOut ="600" > </ asp : ScriptManager >       * The default value of the AsyncPostBackTimeOut property is 90 seconds.
Read more