LINQ Samples

Implement Sql Server Rank and DenseRank Functions in 'LINQ Expressions'

In a class there are 100 students, and in a talent test they got some marks. I want to rank those students. To implement this, SQL Server provides two functions called Rank() and Dense_Rank(). Briefly, Rank() Returns the rank of each row in the result set of partitioned column. Dense_Rank() is same as RANK() function. Only difference is returns rank without gaps. Here i am providing those functions implementation in C# using LINQ expressions.

Filtering data table using LINQ query

LINQ can be used on data tables to filter out those rows from the data table which matches the filter criteria. LINQ query improves performance as compared to traditional Select() method on data table.

Using LINQ to XML

Here I would like to explain how to use LINQ to Query XML and XML Objects. As we know, XML is extensively used because of its popularity. XML provides data in a more accurate, flexible, and adaptable way.

Aggregate Operators In LINQ

In this article we will discuss about the Aggregate Operators in LINQ. The Aggregate Operators in Linq allow us to perform simple math operations over the elements in a sequence. There are mainly six types of Set Operators in Linq.

LINQ example using XML file

This article describes basic LINQ query that getting some data from XML file and bind a gridview.Here there is XML file name employees.xml where each employee have four attribute as FirstName, LastName, Department, Location. Our aim is to select all Department into a dropdownbox and then when we select one department and press Button then all Employee details will appear into a Gridview. I have taken two class file as Employee.cs and EmployeeService.cs and one aspx page

How to Write Inline SQL-Queries in DataContext Class

For a new programmer in Linq writing Complex Linq queries like Joins for multiple tables , using Lambda expressions and preparing dynamic queries is a bit difficult thing.Because he/she is not Used to it.For all those Programmers this article will give some relief and they can write ordinary queries and execute in datacontext to get Object as resultset.This Article will demonstrate how to use these Methods. I will illustrate with snippet of Code Lines.

How to use joins,first or default data retrieval and sorting functionality using LINQ and EF?

While writing LINQ, you may find this code snippet very useful. I have mentioned few examples to clear the syntax. LINQ stands for Language-Integrated Query. It has powerful query capabilities and easy to understand.

How to find the number of occurences of a digit in a given number?

This article would provide you with a small LINQ code snippet to find out the number of occurence of a particular digit in the input without converting its datatype.

Linq Getting distinct values from a custom list

Do you want to learn how to get the distinct values from a list of data using LINQ. Here in this article I would be demonstrating one such example where I would be displaying the distinct names of employee from an employee list.

Gridview Column sorting using Expression Tree

Does your project requires you to generate the Lamda expression at run time? Check out my resource. Here I have provided the code snippet to dynamically calculate the Lamda expression based on the grid columns.

Set Operators in Linq

In this article we will discuss about the Set Operators in LINQ. The Set Operators in Linq is some what same as that of SQL Set operators where their primary use is to find the Union, Intersection, Except, Concat and Distinct.

Ordering Operators in Linq

In this article we will discuss about the Ordering Operators in LINQ. Ordering Operators are used whenever we wants to sort the collections in some specific manner which can be ascending, descending or simply reversing the collection.

Partitioning Operators in Linq

In this article we will discuss about the partitioning operators in LINQ. Partitioning operators mean that to get some specific values from a collection. There are mainly four types of Partition Operators are there. 1. Take 2. Skip 3. TakeWhile 4. SkipWhile

Restriction and Projection Operators in LINQ

Want to learn about the LINQ Operators? This article would discuss about restriction and projection LINQ operators and how to use these LINQ operators in your program.

How to write Fluent Linq Queries?

This article helps you to understand Linq a little more easily. I have used Fluent expressions to write the LINQ queries.I have also used normal queries to that you can differentiate between the fluent queries and the normal queries.Its easy to write both types of queries, you have to decide in which way you want to write that.

Different Sorting techniques (delegate with anonymous method, lamda)

In this article, I have given a code snippet that can refer while writing your code for sorting a collection of objects based on various criteria. First technique is based on delegate, where anonymous method is used to compare and return data. Rest of the techniques are based on lambda expressions. Different GridView are used to present outputs of separate Sorting.

How to Query XML Data having name Space and Return List Object?

Do you want to know how to query the XML which is getting from the URL and converting the XML data in List Object? After get the Object List, want to bind the data to Gridview to see the details.

LINQ, where in (Value1, Value2, Value3.) equivalent Statement.

This Code Segment Help you to write Where in (x1, x2 ) equivalent statement in LINQ. The "IN" clause is built in linq via the .Contains() method

LINQ: ToLookup() vs ToDictionary()

This is about a new feature in .net called ToLookup() a extension method on IEnumerable objects. Most of us have used Dictionary object which will have a key value pair. But what if you want to have multiple value for a single key? There you need this lookpu, you have use this ToLookup() extension method and make a lookup object which will have key, collection of values on it.

Iterate two lists using linq, how to convert a for loop to linq method group

Some times we need to compare two lists using either for or foreach loop to check 'i' th position of list1 has same value in 'i' th positon list2. Some times we need to loop to write a single line of code. Example:- to get all files in a directory and need to delete the files.

Update the Attribute value using LINQ

Here i would like to show you, how to Query the XML using LINQ and Update the attribute value for one of the Element. Here i am using LINQ to load the XML and Query the XML to get the element based on its attribute value. Getting the child element we will update the value of attribute for one of the child element.

Store procedure in MVC

In this resource you will know how to create store procedure for selecting data in database . Model store procedure is given in this resource .How to Call Store procedure in MVC given in this resource.

Outer joins using LINQ

In this article I will demonstrate how to write outer joins in LINQ.

Steps to describe How to use linq for the first time in dotnet C# using VS2008

Guide to use linq with windows application in dot net. Step by step process to use linq and configure the database connection in linq to point it to config file.

Find a particular row from grid view using LINQ

This code segment explain you, how to find a particular row from grid view using LINQ