Please enable Javascript to correctly display the contents on Gurukulsight!

LINQ Tutorial - For Beginners & Professionals

linq with c#,linq to sql,linq with .net,linq recipes,linq tips, linq tricks, linq tips & tricks, linq internal
 
Author : Shailendra Chauhan
updated on 17 Jul 2014

LINQ standard query operators are the methods which help you to write LINQ query. Most of these query methods operate on sequences or collection whose implement the IEnumerable<T> interface or the IQueryable<T> interface. These operators provide query capabilities including filtering, projection, aggregation, sorting and much more.

 

 

Author : Shailendra Chauhan
updated on 16 Jul 2014

As you know LINQ provides a common query syntax to query any data source and ADO.NET allows you to execute query against any RDBMS like SQL Server, Oracle etc. In this article, I am sharing my view on LINQ and ADO.NET.

 

 

Author : Shailendra Chauhan
updated on 16 Jul 2014

LINQ has a JOIN query operator that provides SQL JOIN like behavior and syntax. As you know, Inner join returns only those records or rows that match or exists in both the tables. The simple inner join example is given below:

 

 

Author : Shailendra Chauhan

LINQ provides element operators which return a single element or a specific element from a collection. The elements operators are Single, SingleOrDefault, First, FirstOrDefault, Last, LastOrDefault.

 

 

Author : Shailendra Chauhan
updated on 16 Jul 2014

LINQ provides a uniform programming model (i.e. common query syntax) to query data sources (like SQL databases, XML documents, ADO.NET Datasets, Various Web services and any other objects such as Collections, Generics etc.). LINQ provides you three different ways to write a LINQ query in C# or VB.

 

 

Author : Shailendra Chauhan
updated on 16 Jul 2014

LINQ provides a common query syntax to query any data source. In a LINQ query, you always work with objects. The object may in-process object or out-process object. Based on objects, LINQ query expression is translated and executed.

 

 

Author : Shailendra Chauhan
updated on 16 Jul 2014

Select and SelectMany are projection operators. Select operator is used to select value from a collection and SelectMany operator is used to select values from a collection of collection i.e. nested collection.

 

 

Author : Shailendra Chauhan
updated on 26 Sep 2016

In .NET, Expression is an abstract class which contains static methods and inherited by various types (like ParameterExpression, MethodCallExpression) to create expression tree nodes of specific types. A ParameterExpression represents a named parameter expression and a MethodCallExpression represents a method call.

 

 

Author : Shailendra Chauhan
updated on 04 Jun 2014

LINQ provided you common query syntax to query various data sources like SQL Server, Oracle, DB2, WebServices, XML and Collection etc. LINQ also has full type checking at compile-time and IntelliSense support in Visual Studio, since it used the .NET framework languages like C# and VB.NET.

 

 

Author : Shailendra Chauhan
updated on 26 Sep 2016

There are Different Types of SQL Joins which are used to query data from more than one tables. In this article, I would like to share how joins work in LINQ. LINQ has a JOIN query operator that provide SQL JOIN like behavior and syntax. Let's see how JOIN query operator works for joins. This article will explore the SQL Joins with C# LINQ.

 

 

Author : Shailendra Chauhan
updated on 24 Sep 2016

Basically, IEnumerable is an interface that can move forward only over a collection, it can’t move backward and between the items. Var is used to declare implicitly typed local variable means it tells the compiler to figure out the type of the variable at compilation time. A var variable must be initialized at the time of declaration.

 

 

Author : Shailendra Chauhan
updated on 24 Sep 2016

In LINQ to query data from collections, we use IEnumerable and IList for data manipulation.IEnumerable is inherited by IList, hence it has all the features of it and except this, it has its own features. IList has below advantage over IEnumerable.

 

 

Author : Shailendra Chauhan
updated on 28 Jan 2015

In LINQ to query data from database and collections, we use IEnumerable and IQueryable for data manipulation. IEnumerable is inherited by Iqueryable, hence it has all the features of it and except this, it has its own features. Both have its own importance to query data and data manipulation. Let’s see both the fetures and take the advantage of both the fetures

 

 

Author : Shailendra Chauhan
updated on 24 Jun 2014

XML data is often used to transfer data from one application to another. Since XML is language independent, hence it is a good choice to use xml for transferring data between two different platform applications. In C#, it is easy to make xml from database by using LINQ to SQL and LINQ to XML.

 

 

Author : Shailendra Chauhan
updated on 14 Jul 2012

LINQ stands for Language-Integrated Query. Basically LINQ address the current database development model in the context of Object Oriented Programming Model. If some one 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.

 

 

 
 
3 APR
Master Class Fast Track MVC 5 with Angular2 Development (online)

10:30 AM -03:30 PM IST (Fast Track)

Know More
1 APR
MEAN Stack 2 Development (offline)

11:00 AM-12:30 PM

Know More
1 APR
ASP.NET MVC with Angular2 Development (offline)

4:00 PM-5:30 PM

Know More
25 MAR
Xamarin Forms : Build Cross-platform Apps (offline)

8:00 AM-9:30AM

21 MAR
ASP.NET MVC with Angular2 Development (online)

09:00 PM - 11:00 PM IST( TUS, THR, SAT)

6 MAR
ASP.NET MVC with Angular2 Development (online)

07:00 AM - 09:00 AM IST( MON, WED, FRI)

25 FEB
ASP.NET MVC with Angular2 Development (offline)

05:00 PM-06:30 PM

31 JAN
ASP.NET MVC with Angular2 Development (online)

07:00 AM-09:00 AM IST(Tuesday & Thursday)

30 JAN
NODEJS & MEAN Stack 2.x Development (online)

09:00 PM-11:00 PM IST( MON, WED, FRI)

31 DEC
ASP.NET MVC with AngularJS Development (offline)

09:30 AM-11:00 AM

BROWSE BY CATEGORY
 
RECENT ARTICLES
SUBSCRIBE TO LATEST NEWS
 
LIKE US ON FACEBOOK
 

Professional Speaks

+