LINQ

List of Articles in LINQ

How to Improve LINQ to SQL Performance with Complied Query

In this article I will explain how to improve LINQ to SQL query performance with Complied Query. There may be scenario where we need to execute a particular query many times and repeatedly. LINQ allows us to make this task very easy by enabling us to create a query and make it complied always. We call this type of query as complied query.Read more..
By: Dhananjay Kumar   |    On:  1/8/2011 1:53:15 AM   |    Article

Increase Query Performance with Read-Only Data in LINQ

By default CRUD operation can be performed on the retrieved data from LINQ query. We can modify the data fetched through LINQ query.IF we do not want to modify the data then we can increase the performance by making the data as READ ONLY.Read more..
By: Dhananjay Kumar   |    On:  1/10/2011 10:55:52 AM   |    Article

Introduction to LINQ and Lambda Expressions with Examples-Tutorial

In this tutorial I will explain all about Language Integrated Query (LINQ) and Lambda Expression basic with examples. The Language Integrated Query (LINQ) is powerful query language in .NET and we can use the Language Integrated Query (LINQ) to query to Object Collection, XML expression and more.Read more..
By: abhi2434   |    On:  12/7/2010 10:23:59 AM   |    Article

Functional Construction of XML Tree in LINQ-Part03

how to create a XML tree using Functional Construction method of LINQ to XML.Read more..
By: Dhananjay Kumar   |    On:  4/13/2010 11:14:26 AM   |    Article

LINQ with IIS sites and web Applications

In this article, we will see how to work with LINQ against IIS.Read more..
By: Dhananjay Kumar   |    On:  8/10/2010 8:13:42 AM   |    Article

Remote and Local execution of Query in LINQ

In this article we will focus LINQ Remote and Local exaction such as This query executes on the server, Remote execution of query is default in LINQ, In Remote execution advantage of Databases index can be taken, Remote execution allows us to take the advantage of Database server engine, Remote execution allows us to only select particular rows from the table. This is very useful when we do have large amount of data in the server.Read more..
By: Dhananjay Kumar   |    On:  1/7/2011 7:25:15 AM   |    Article

Deferred Execution and Immediate Execution in LINQ

Deferred Execution executes the query only when Loop starts. What I mean here is that, we iterate through the query variable to get the result.Read more..
By: Dhananjay Kumar   |    On:  1/15/2011 5:28:15 AM   |    Article

Var vs IEnumerable when retrieving LINQ Query

Var derives type from the right hand side. And its scope is in the method. And it is strongly typed. IEnumerable is interface which allows forward movement in the collection.Read more..
By: Dhananjay Kumar   |    On:  1/16/2011 2:03:53 AM   |    Article

Internal of Deferred or Lazy Execution in LINQ

In this article we will see how internally Deferred or lazy execution is implemented. Deferred Execution executes the query only when Loop starts. What I mean here is that, we iterate through the query variable to get the result.Read more..
By: Dhananjay Kumar   |    On:  2/10/2011 8:24:32 AM   |    Article

LINQ to SQL, LINQ to XML and Accessing DataTable using LINQ

This article demonstrates how to use LINQ on DataTable, XML Data using LINQ to XML and SQL server data base using LINQ to SQL Classes.Read more..
By: kirtan007   |    On:  6/28/2010 7:49:55 AM   |    Article

How to use Any Method with Collection in LINQ

In this article, I will share with you, how to use the Any method in LINQ.We can use this method in two differen ways, one is with collection and another one is without collection.Read more..
By: pranay rana   |    On:  8/14/2011 6:36:03 AM   |    Article

How to Read Excel Data Using LINQ to ExcelProvider in .NET

In this article I will show to how to read Excel work book data using LINQ to Excel provider in LINQ. The LINQ has many powerful ways to extend and access different type source. Let’s see how to implement this with Visual studio 2008 and .NET 3.5 Framework.Read more..
By: RRaveen   |    On:  12/27/2010 8:18:02 AM   |    Article

How to Read CSV file using LINQ to CSVProvider in C#

In this article we will focus, how to read CSV file using LINQ to CSVProvider.I hope we know read CSV file using StreamReader or any other readers in C#. But when we are use the LINQ to CSVProvider, and then we could get additional features to query data in LINQ as like Sql Query.Read more..
By: RRaveen   |    On:  1/1/2011 3:01:31 AM   |    Article

Plinq Vs Linq Parallel Programming in .Net Framework 4.0

PLINQ automatically parallelizes local LINQ queries. PLINQ has the advantage ofbeing easy to use in that it offloads the burden of both work partitioning and resultcollation to the Framework.Read more..
By: usamawahabkhan   |    On:  5/25/2010 8:39:12 AM   |    Article

Link to LINQ

Link to LINQRead more..
By: ak.tripathi@yahoo.com   |    On:  2/16/2010 12:18:12 AM   |    Article

Creating XML Tree from Scratch through LINQ

Creating XML Tree from Scratch through LINQRead more..
By: Dhananjay Kumar   |    On:  2/16/2010 12:48:56 AM   |    Article

LINQ to XML Part 5: Catching Parsing Exceptions

How to handle exception in parsing XML using LINQ to XML in .NETRead more..
By: Dhananjay Kumar   |    On:  4/3/2010 5:42:30 AM   |    Article

Introduction to LINQ and VS 2008 web application

very basic idea on asp.net 3.5 website using LINQRead more..
By: ashraf   |    On:  2/16/2010 3:00:44 AM   |    Article

LINQ Deferred Execution

LINQ Deferred ExecutionRead more..
By: Geming Leader   |    On:  2/16/2010 2:59:02 AM   |    Article

How to use the LinqDatasource in .NET

I have used data source control many times and its great it provides us great features for declarative binding. LinqDataSource Control is a great control and it allows us to bind linq queries without writing any code declarativelyRead more..
By: jalpesh   |    On:  9/2/2010 11:22:29 AM   |    Article

How to Create Dynamic Query with LINQ

In this article i'm going to discuss about building dynamic query with the LINQ. LINQ to SQL allow user to query data from the database without writing sql queries by writing LINQ queries. LINQ represent each table as one entity and where LINQ queries allows to manipulate data in type safe.Read more..
By: pranay rana   |    On:  4/16/2011 11:28:32 AM   |    Article

LINQ FAQ Part 1

LINQ FAQ Part 1Read more..
By: questpond   |    On:  2/16/2010 12:02:29 AM   |    Article

Introduction of the LINQ

Introduction of the LINQRead more..
By: RRaveen   |    On:  2/15/2010 10:59:46 PM   |    Article

LINQ to XML in silverLight 3.0

how to use LINQ to XML to read data from a XML file and bind that to SILVERLIGHT 3.0 Data Grid. XML file will be read in a WCF service and WCF service will return a List to be bind in a Grid.Read more..
By: Dhananjay Kumar   |    On:  4/16/2010 10:05:50 AM   |    Article

LINQ to XML Part #4: Different way of Parsing string to create XML tree

I will show different way of parsing string to create XML tree using LINQ to XML.Read more..
By: Dhananjay Kumar   |    On:  4/16/2010 11:21:01 AM   |    Article

LINQ to XML Part #1-XAttribute Class

In this article, I will give explanation on XAttribute class. This class is used to construct Attributes in XML Elements.Read more..
By: Dhananjay Kumar   |    On:  4/17/2010 10:14:19 AM   |    Article

LINQ to XML Part #2 - XElement Class

In this article, I will give explanation on XElement class. This class is used to construct XML Elements.Read more..
By: Dhananjay Kumar   |    On:  4/17/2010 10:29:55 AM   |    Article

LINQ projection operators( Select and SelectMany)

Projection helps us developer to retrieve desired result from the collection . LINQ provides two projection operator. Select and SelectMany. Select works with one collection whereas SelectMany works with more than one collectionRead more..
By: Dhananjay Kumar   |    On:  8/20/2010 10:14:43 AM   |    Article

Introduction to Operators in Linq

I have found three more new operators in Linq which is use full in day to day programming stuff. Take,Skip and Reverse. Here are explanation of operators how it works.Read more..
By: jalpesh   |    On:  6/21/2010 10:56:00 AM   |    Article

Linq Join on Mutiple columns using Anonymous type

I was working on the project using LINQ. I got the requirement to join the two entity on multiple column.Read more..
By: pranay rana   |    On:  10/2/2011 6:00:41 AM   |    Article

LINQ To SQL In Silverlight 3

In this article we would see how can we use LINQ to Sql ORM in Silverlight 3 Application for interacting with SQL Server Database.Read more..
By: dpatra   |    On:  5/8/2010 10:59:45 PM   |    Article

Simple Insert,Update,View and Delete with LINQ-To-SQL

Today one of my friend asked me about simple insert,update and delete example with LINQ-To-SQL but at that time i was not having any simple example which will show the power of LINQ-To-SQL ExampleRead more..
By: jalpesh   |    On:  5/17/2010 8:07:54 AM   |    Article

Binding A Custom Entity Class to stored procedure using Linq-To-SQL

I have already written several article about Linq its a great ORM that we can use in various way. The purpose of this post to demonstrate How we can bind custom entity to stored procedure result with use of Linq-To-SQL.Read more..
By: jalpesh   |    On:  8/5/2010 11:30:59 AM   |    Article

Learn SQL to LINQ ( Visual Representation ) with Examples

Now a days most of the developers are moving towards new LINQ to SQL they find difficult to write down SQL query in C# to query data using LINQ. LINQ is a query language which get integrated in C# to query data form ObjectCollects, SQL, XML etc.Read more..
By: pranay rana   |    On:  1/8/2011 11:21:36 PM   |    Article

How to use SelectMany with LINQ JOINS

SelectMany is Projects each element of a sequence to an IEnumerable and flattens the resulting sequences into one sequence.In this post I am going to show how you can use SelectMany Extension method to achieve the join between related tables easily without writing long queries.Read more..
By: pranay rana   |    On:  1/18/2011 8:36:32 AM   |    Article

Filter Records by RowNumbers in LINQ To SQL

In this article, I am going to show how you can filter your data by RowNumbers that you assigned to your records.Read more..
By: pranay rana   |    On:  2/3/2011 10:58:38 PM   |    Article

How to Filter data by using IN and NOT IN clause SQL to LINQ

In this article,I am going to show some SQL queries and LINQ queries with IN and NOT IN clause with SQL and LINQ, but not going to show images for all cases.Read more..
By: pranay rana   |    On:  2/25/2011 8:00:43 AM   |    Article

IQueryable vs IEnumerable in terms of LINQ to SQL queries

In this article, I am going to explain what are the different between IQueryable vs IEnumerable in LINQ.Read more..
By: pranay rana   |    On:  6/11/2011 9:29:16 PM   |    Article

How to use INTO and LET in LINQ to Get Best Performance

In this article, I am going to discuss, how to use INTO and LET in LINQ in order to get best performance of the LINQ Queries and difference between these.Read more..
By: pranay rana   |    On:  6/11/2011 9:39:39 PM   |    Article

Asp.net Databind With Linq & linq to Sql

After two decades, the industry has reached a stable point in the evolution of object-oriented (OO) programming technologiesRead more..
By: usamawahabkhan   |    On:  5/12/2010 8:47:59 PM   |    Article

How to use Stored Procedure with DataContext in LINQ

In this article I will show, how to use the Stored Procedure with DataContext in LINQ to retrieve records from database. The Stored Procedure is most supportive to data driven application to manage performance and keep secured data retrieval.Read more..
By: Dhananjay Kumar   |    On:  1/7/2011 7:55:51 AM   |    Article
^ Scroll to Top