Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

Conversion Operators in Linq

Conversion Operators are helpful in transforming the type of the item in a collection. In linq, We have a three types of conversion operators:- 1. As operators(AsEnumerable and AsQueryable) 2. To operators(ToArray, ToDictionary, ToList a...

Linq Aggregation Operator: Max

Max aggregate operator is used to find the largest item from a collection. Exapmle:- In the below example we created a complex type collection for an Employee. This Employee collection contains EmpId, EmpName and Age. We need to find a maxi...

Generation Operators in LINQ

In this blog we illustrate the generation operators in linq. We have a three Generation Operators : 1. Empty 2. Range 3. Repeat 1. Empty:- Empty operator  is used to return an empty sequence of the type that is specified . It is a ...

Quantifier Operators in Linq

The quantifier operators  analyse a collection of items on some condition and  return a boolean value if any or all the items in collection satisfy a condition.   In linq, We have three types of Quantifier Operators:- 1. All...

Grouping Operators in Linq

Grouping operators generates a categories or groups of an item on the basis of given key. These type of operators implements IEnumerable collection of type IGrouping<Key, SourceItem> where Key is a key value, on the basis of which grouping ...

Difference between LINQ and Stored procedure

 LINQ and Stored procedure   LINQ provides a query syntax used for querying different data sources like SQL server, Oracle, Collections etc. Type checking is done at compile time in LINQ. DOT NET framework languages like C# a...

Deferred vs Immediate Query Execution in LINQ

Deferred vs Immediate Query Execution in LINQ   There are two execution behaviours in LINQ namely Deferred and Immediate.   Deferred Execution : In this type query execution does not take place at time of declaration ra...

Understanding Single, SingleOrDefault, First and FirstOrDefault

There are element operators provided by LINQ which are capable of returning single or specific element from a collection. These element operators can be defined as follows :-   Single : This element operator is capable of returning ...

Select distinct records using Linq

We often need to select distinct records from a list or from database. In Linq, we can select distinct records from a list or collection using Distinct method. Suppose we have a list with the name Employees and we want to select only Distinct ...

Using Left Outer Join in LINQ

We use left outer join when we want each element of the first collection should be fetched irrespective of whether it has the related element in the second collection  or not. In LINQ, we perform left outer join by calling Defaul...

Using Union All in Linq

This is a simple example of how we use UNION ALL in Linq. In fact there is no UNION ALL operator in Linq but we have an equivalent of UNION ALL as Concat operator. So suppose we have two list (oldEmployees and newEmployees) which hold name...

Basics of LINQ To SQL

Getting started with LINQ To SQL:     When we say LINQ To SQL, it refers to the technology through which we can access Database via LINQ. This has replaced the traditional way of writing SQL Query for Database access, even ...

LINQ Basics

GETTING STARTED WITH LINQ:     As data plays a vital role in almost every application development therefore LINQ was provided as a whole new way to manipulate data, either to or from database, or with XML file or with simpl...

LINQ

LINQ is used for Data querying in a type safe way. Data to be queried can be XML, SQL, and Object etc. Lets have a look at simple LINQ query: var items = from employee in db.Employee where Employee.Salary < 20000 ...

Tutorial On LinQ and Simple LinQ examples

Introduction of LINQ: Abbreviated for Language-Integrated Query (LINQ). It was introduced in Visual Studio 2008 and .NET Framework version 3.5. The main concept behind it was to fill the gap between world of objects and the world of data. LINQ...

How to add, update and delete the records into the database using linq

UserEntities objUserEntities= new UserEntities();/*Create object of user entity /* Add records into the database */ public void AddUser(User objUser) { objUserEntities.AddToUsers(objUser); /*Linq has its own function to ...
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: