Linq Resources

About Linq

LINQ is shorted for ( Language Integrated Query ) which is programming model of Microsoft .NET that have query capabilities to the .NET programming languages. All these extensions are provide easy and expressive syntax to manipulate data. In C# and Visual Basic have number of features that support LINQ operations. It has been powerful querying on objects, XML files, and databases. LINQ encapsulates heavy generics and there different features likes extension methods, lambda expressions, an object Initialize, query syntax, and anonymous types. These are language extensions to enhance syntactic performance to queries.

Share

Related resources for Linq

Convert LINQ Query Result to Datatable 1/12/2021 10:11:14 AM. In this article, we will learn how to convert Linq query result into the Datatable.
Bind Add Update Delete Data Using MVC Entity Framework And LINQ1/12/2021 10:02:00 AM. In the article, you will learn how to add, update, and delete data, using Entity Framework and LINQ. This is for the beginner users like me in MVC.
ASP.NET Web API 2 In MVC 5 Using C# With Example1/11/2021 2:11:36 PM. in this article, I am going to explain how to create and access the Web API 2 in the ASP.NET MVC 5 application using C# and bootstrap with Example. Here I'll also show you how to create the step b
Bind Menu And Sub Menu Dynamically In ASP.NET MVC From Database Using LINQ1/5/2021 10:05:49 AM. Many times we need to create a menu for a simple application. We ususally get stuck on how to bind the menu. Here in this article we you will learn how to bind menu and sub menu dynamically in ASP.NET
ORM Designer for Entity Framework1/1/2021 9:47:01 AM. This article describes the Entity Developer tool Devart.
Common Problems With Entity Framework For Importing Stored Procedure1/1/2021 4:50:56 AM. This article describes three common issues that can occur while adding a Stored Procedure to an edmx file of Entity Framework.
4 Real Time Use of Partial Classes and Partial Method12/15/2020 6:37:22 AM. In this article we will explain use of partial classes and partial methods for 4 real time.
Join Two DataTables Using LINQ In ASP.Net C#12/8/2020 6:35:54 AM. In this article, we will learn how to join two DataTables using LINQ In ASP.Net C#.
Creating a Dynamic Data Web Site in ASP.NET 4.012/3/2020 3:15:38 AM. You can create Dynamic Data Web sites in Visual Studio by using ASP.NET Dynamic Data templates.
Linq To Excel In Action11/9/2020 7:39:30 AM. In this post, we will demonstrate how we use LinqToExcel library to query data from Excel.
Calling an stored procedure using ADO.NET Entity Model11/4/2020 9:17:54 AM.
Standards In Defining The AutoMappers10/4/2020 11:17:23 PM. This article describes the tips or standards in defining mapping profiles.
Var Keyword In C#9/29/2020 8:24:38 AM. C# var keyword is used to declare implicit type variables. Let's learn what is var in C# and when to use a var in C#.
Using LINQ with C#9/21/2020 9:31:49 AM. LINQ introduces a standard, unified, easy-to-learn approach for querying and modifying data. In this article, you'll learn basics of LINQ and how to use LINQ in C#.
Using LINQ Expressions In C#9/18/2020 10:58:23 AM. In this article, you will learn how to use LINQ Expressions in C#.
LINQ Queries9/2/2020 2:54:10 PM. In this article, you will learn about LINQ Queries.
Optimizing LINQ Queries In C#.NET For MS SQL Server 8/13/2020 7:44:03 AM. In this article, you will learn about some aspects of LINQ query optimization for MS SQL Server.
Learn To Use LINQPad8/5/2020 7:39:57 AM. In this article, you will learn about LINQPad.
Cascading Deletes in LINQ to SQL7/6/2020 8:54:50 AM. This article will discuss alternative methods for performing cascading deletes using LINQ to SQL. Cascading delete refers to the action of removing records associated by a foreign key relationship to
JavaScript Functions vs LINQ C#7/5/2020 7:41:32 AM. This is a comparison between Javascript functions and LINQ in C# for collections.
Multi-Select Dropdown With Checkboxes Using jQuery In MVC6/9/2020 8:48:23 PM. This article is about creating a multi-select dropdown with CheckBoxes in MVC by using Jquery on a country sample data. This kind of scenario is taken on applications such as on insurance domain. When
EF Core - SELECT DISTINCT on a Few Columns Only4/26/2020 2:53:51 PM. In this article, you will learn about implementing EF Core - SELECT DISTINCT on selected columns only.
Efficient Data Modification with Entity Framework Core4/16/2020 3:02:47 PM. In this article, you will learn about efficient data modification with Entity Framework Core.
LINQ In C#3/6/2020 10:55:13 AM. LINQ stands for Language Integrated Query. LINQ is a data querying API that provides querying capabilities to .NET languages with a syntax similar to a SQL. LINQ queries use C# collections to return d
LINQ Join Operations Explained12/3/2019 3:41:29 AM. In this article, you will learn about LINQ Join Operations.
Basic Concepts About LINQ In C#10/16/2019 11:53:31 PM. In this article, you will learn some basic concepts about LINQ in C#.
FlexibleList In C#10/8/2019 1:04:31 AM. This article is about FlexibleList in C#.
Practical Use Of Extension Methods In C#8/29/2019 3:48:31 AM. In this video, we will talk about and learn the practical usage of extension methods in C#.
LINQ Operators And Lambda Expression - Syntax & Examples7/21/2019 6:20:29 PM. Here is a list of code examples for LINQ operators and the equivalent Lambda Expressions.
SQL Join Query With LINQ7/15/2019 3:51:55 AM. In this article, I will show you how to create SQL queries in LINQ. LINQ Join queries.
Lazy Loading And Eager Loading In LINQ To SQL7/5/2019 6:27:29 AM. In this article, you will learn about Lazy Loading and Eager Loading in LINQ to SQL.
How To Use LINQ To SQL For Retrieving Data From SQL Server Database7/4/2019 6:10:31 AM. In this article, we will learn how to use LINQ to SQL to retrieve data from the SQL server database.
Dynamic Sorting (OrderBy) Based On User Preference6/21/2019 9:17:07 AM. In this article, I am going to demonstrate how we can sort the data based on user preference.
SQL Join in LINQ (LINQ to Entity / LINQ to SQL)6/7/2019 12:58:19 AM. This article explains various types of joins in LINQ query. Learn Inner join, Outer Join, Left Outer join, Right Outer join, Full outer join, Cross Join, Group Join in LINQ query.
Understanding Group In LIQN By With Easy Examples6/2/2019 7:23:18 AM. This article explains GroupBy in LINQ with real-world code example.
How To Use Extensions For LINQ - C#5/20/2019 11:36:38 PM. In this tutorial, we will learn how to use extension methods with LINQ in C# to simplify the coding.
LINQ For Beginners4/10/2019 1:16:52 AM. LINQ stands for Language Integrated Query. In this article, we will dive deep into the basics of LINQ.
Increase Performance Of LINQ By Parallelism4/9/2019 9:16:22 AM. Parallelism solves many problems in the computing world if done in the right way; parallelism is not good if the task is small and needs synchronization of resources, such a scenario would hurt perfor
IEnumerable Vs IQueryable In LINQ4/7/2019 11:11:13 PM. In this article, I will demonstrate how to use IEnumerable and IQueryable in C#. Also learn the differences between IEnumerable and IQueryable.
Aggregate Function In LINQ3/14/2019 4:39:15 AM. In this article, we going to see about how to use the aggregate function with LINQ.
Simple SELECT, INSERT, UPDATE and DELETE Using LINQ to SQL3/14/2019 1:37:54 AM. In this article I am going to explain simple Select, Insert, Update and Delete operation using to LINQ to SQL.
Anonymous Types In C#3/1/2019 5:45:57 PM. Anonymous types allow us to create new types without defining them. In this article, you'll learn how to use Anonymous Types in C#.
Convert DataTable to List In C#3/1/2019 2:57:11 AM. This article shows 3 ways to convert a DataTable to a List in C#.
Introduction To LINQ2/25/2019 12:05:15 AM. In this article, you will have an introduction to LINQ. Here we will see What LINQ is, benefits of using LINQ, LINQ Architecture, and LINQ Providers.
Working With Multiple Tables Using LINQ Join In MVC2/22/2019 11:29:49 AM. In this article, we will learn how we can join multiple tables using LINQ and display records in a View. We will learn everything in a step by step manner.
All About IEnumerable and IQueryable2/12/2019 9:00:34 AM. When we talk about LINQ, we consider two collections, IEnumerable and IQueryable. In this article, we will learn all about IEnumerable and IQueryable, except how they are evaluated. Possibly, I will c
Difference Between IQueryable, IEnumerable, And IList In LINQ2/10/2019 11:15:21 PM. This article explains how to work with IQueryable and IEnumerable and IList in LINQ. Also, it tells when to use IQueryable and IEnumerable in real-time scenarios.
Cascading Dropdown List With MVC, LINQ to SQL and AJAX1/31/2019 3:15:52 AM. This article explains how to populate a child DropDownList depending on each new value as values are selected in the parent's DropDown List.
Cascading Dropdown List In MVC Using LINQ to SQL1/31/2019 3:05:29 AM. In this article we will learn how to bind data from a table to a DropDownList in MVC using LINQ to SQL.
LINQ Extended Joins1/14/2019 3:36:33 AM. This article illustrates LINQ extended joins like Inner Join, Left Join, Right Join, Full Outer Join, Left Excluding Join, Right Excluding Join, Full Outer Excluding Join.
A Brief Introduction To LINQ1/7/2019 2:40:25 AM. Introduction to LINQ.LINQ query can be written in three ways, Query expression, Fluent Syntax, Mixed Syntax. LINQ allows you to query local data (e.g LINQ to Objects) as well as remote data (LINQ to S
Update Data to XML Using LINQ to XML12/4/2018 3:45:10 AM. Today, in this article let’s play around with one of the interesting and most useful concepts in LINQ to XML. Update Data to XML Using LINQ to XML.
Select Data From XML With Where Clause Using LINQ to XML12/4/2018 3:28:54 AM. Today, in this article let’s play around with one of the interesting and most useful concepts in LINQ to XML. Select Data From XML With Where Clause Using LINQ to XML.
Insert Data to XML Using LINQ to XML12/4/2018 2:37:45 AM. Today, in this article let’s play around with one of the interesting and most useful concepts in LINQ to XML. Insert Data to XML Using LINQ to XML.
Delete Data From XML Using LINQ to XML12/4/2018 12:16:47 AM. Today, in this article let’s play around with one of the interesting and most useful concepts in LINQ to XML. Delete data from XML using LINQ to XML.
Add Attribute to XML Using LINQ to XML12/4/2018 12:07:36 AM. Today, in this article let’s play around with one of the interesting and most useful concepts in LINQ to XML. add a new XAttribute to XML with help of a LINQ query.
Dynamic LINQ Query In C#11/30/2018 5:25:13 AM. This article shows how to use a dynamic LINQ library in C#. We will learn how to use SELECT Statement at runtime in Linq C#
Func<> Delegates in LINQ10/24/2018 3:15:54 AM. Learn how Func<> Delegates in LINQ work. Func delegates are pointers to methods that take one or more parameters and must return a value.
Show/Delete/Edit data in WPF DataGrid using LINQ to SQL Classes9/18/2018 4:30:25 AM. This article will demonstrate how to Show, Delete, and Edit data in WPF Data Grid using LINQ to SQL Data Classes.
An Overview Of LINQ9/6/2018 4:33:19 AM. In this article, you will get an overview of LINQ. LINQ Stands for Language Integrated query which is used to access memory objects, Databases and XML documents and so on.
LINQ Extension Methods - Partitioning Operator - Part Four8/16/2018 11:16:54 PM. This article is continuation of Linq extension methods. In this article I am going to demostrate partitionaning operators like skip, skipWhile, take and TakeWhile.
How To Use Join Operations With Database Using LINQ8/16/2018 8:58:54 AM. In this article. I will demonstrate how we can perform join operation with SQL database using Language-Integrated Query (LINQ).
How To Use Join Operation With Multiple SQL Database Tables Using LINQ8/15/2018 11:41:30 PM. In this article, I will demonstrate how we can perform join operation with multiple SQL database tables using Language-Integrated Query (LINQ).
LINQ Extension Methods - Element Operator And Set Operator - Part Three8/14/2018 9:23:40 AM. In this article, we are going to explore another two operators like element operator and set operators. Element operators are used to returning the particular element from the collection and set opera
Learning LINQ Made Easy: Tutorial 18/14/2018 4:53:36 AM. In this article, you will learn about LINQ. Language Integrated Query (LINQ) provides a way to query any type of data source. LINQ simplifies this situation by offering a consistent model for working
5 tips to improve performance of C# code: Part 48/13/2018 4:18:36 AM. In this article, I will show a few ADO.NET tips to improve performance. A connection object is one of the most resource consuming objects in ADO.NET. So we need to manage this object very carefully.
How To Use Data Filtering Operations With Database Using LINQ8/9/2018 9:00:23 AM. In this article. I will demonstrate how we can use Where and OfType operator of Language-Integrated Query (LINQ).
LINQ Extension Methods Quantifier And Aggregation Operator - Part Two8/8/2018 1:38:14 PM. This article is continuation of Linq extension methods. If you want to read first part please click here Part One. In this article I will demonstrate quantifier operator and aggregation operators.
How To Use Aggregation Operations With Database Using LINQ8/8/2018 1:33:24 PM. In this article. I will demonstrate how we can use Sum, Min, Max Count, Average, LongCount, Aggregate operator of Language-Integrated Query (LINQ). Sum, Min, Max Count, Average, LongCount, Aggregate o
How To Use Grouping Data Operations With Database Using LINQ8/7/2018 9:07:50 AM. In this article, I will demonstrate how we can use GroupBy and ToLookup operator of Language-Integrated Query (LINQ). GroupBy and ToLookup operators are part of grouping data in Language-Integrated Qu
LINQ Extension Methods - Part One8/5/2018 11:18:50 AM. This article explains linq extension methods like filtering, grouping and sorting and projection orators
How To Use Data Partitioning Operations With Database Using LINQ8/5/2018 11:15:25 AM. In this article, I will demonstrate how we can use skip, SkipWhile, take, TakeWhile operator of Language-Integrated Query (LINQ). Skip, SkipWhile, take, TakeWhile operators are part of partitioning da
How To Use Data Sorting Operations With Database Using LINQ8/5/2018 10:33:26 AM. In this article, I will demonstrate how we can use OrderBy, OrderByDescending, ThenBy, ThenByDescending and Reverse operator of Language-Integrated Query (LINQ). OrderBy, OrderByDescending, ThenBy, Th
An Overview Of LINQ To SQL8/3/2018 10:04:57 PM. LINQ to SQL is a mapping between the Relational Database Schema and Objects. The relational data can be manipulated using LINQ by its mapped objects. When an object is linked to relational data, it re
How To Implement Paging Using Skip And Take Operators In LINQ8/3/2018 1:23:33 PM. In this article, I will demonstrate how we can use skip and take operator of Language-Integrated Query (LINQ) for implementation of paging in C# programming. Skip and take operators are part of partit
Introduction To LINQ And LINQ Syntaxes7/24/2018 11:11:46 AM. In this article, we will discuss on the introduction to LINQ And LINQ syntaxes.
LINQ Fundamentals - Single() Vs SingleOrDefault() - Part Two4/15/2018 11:53:24 PM. In first part we discussed First() and FirstOrDefault() extension method, In this part we will discuss Single() and SingleOrDefault().
LINQ Fundamentals - First() Vs FirstOrDefault()4/4/2018 11:48:20 PM. There are four famous concepts in LINQ, almost every C# developer knows about them and has used them in their daily development work.
Aggregate, The True LINQ Aggregator Operator3/8/2018 10:39:47 PM. Aggregate LINQ operator is unknown in the LinQs world. The goal of the project is to review the LinQ Aggregators operators (Count, LongCount, Min, Max, Sum and Average), and show all operators can be
Introduction To LINQ With Entity Framework In Visual Studio2/8/2018 9:23:56 AM. LINQ queries are similar to SQL query created for developers to maintain standardized coding approach. It deals with the data objects therefore it is similar to OOPs.
Excel To XML Using LINQ1/4/2018 2:05:38 AM. In this article we will show you the easiest way to convert Excel data into Xml files. There is a certain way to convert Excel file to Xml, for example using Excel Library (Com Component)
Overview Of Let In LINQ10/10/2017 1:15:34 AM. In general, Let allows create a local variable at the LinQ query. Let has the same operation as to build local variable in a loop. The example with let hast better performance than the without let exa
Productive C# - Inferred Tuple Element Names In C# 7.19/22/2017 1:33:34 AM. Learn how tuple element names are automatically inferred in C# 7.1.
Two Ways To Get Data From Entity Framework9/18/2017 6:27:52 AM. In this article, you will learn about two basic ways to get data from Entity Framework and display data in angular UI-Grid using MVC application with Web API.
Practical C# - Sorting In LINQ9/6/2017 6:50:29 AM. Learn how to order collections using C# and LINQ.
Practical C# - LINQ Set Operations9/5/2017 2:12:33 AM. Learn how to use the LINQ Set Operations in C# (distinct, union, intersect and except).
Use Of Union, Intersect, Distinct And Except In LINQ9/1/2017 12:45:29 PM. Here, you will learn the uses of Union, Intersect, Except, and their differences, To get a clear picture, we will go with examples.
Practical C# - Sorting in LINQ9/1/2017 2:19:53 AM. Learn how to sort collections in ascending and descending order using LINQ in C#.
Use Of Deferred And Immediate Query Execution In LINQ8/31/2017 6:59:34 PM. Here, you will see about query execution in linq and what is deffered query execution, what is immediate query execution and it's differences, we will see with example for better understanding.
Dynamic LINQ Query In C# Using Predicate Builder8/23/2017 7:43:58 AM. This article explains how to create a dynamic LINQ query in c# using Predicate Builder.
Practical C# - SelectMany In LINQ8/23/2017 1:29:02 AM. Learn all the possible ways to use SelectMany in LINQ to implement sophisticated queries who need to flatten sequences of sequences in C#.
Use Of Range, Repeat And Empty In LINQ8/21/2017 5:15:28 PM. Here, we are going to see the uses of the Range,Repeat and Empty keywords in LINQ and we also will discuss their differences.
Practical C# - Sequence Equality 8/18/2017 2:11:04 AM. Learn how to check if two lists or sequences are equal using C#. Did you know Microsoft implemented this for you in the .NET Framework 3.5?
Element Operators In LINQ8/17/2017 10:59:42 AM. Here, we will learn about Element Operators, their uses, and various element operators.
Use Of Into And Let In LINQ8/7/2017 12:34:11 PM. Here, we going to see the uses of Into and Let keywords in LINQ and their differences.
How To Use Joins, and Group By Clause In Entity Framework With LINQ C#7/15/2017 12:40:08 PM. In this article will be going to learn How to use Joins, and Group By Clause in Entity Framework with Linq C#
Writing Complex Queries Using LINQ And Lambda6/26/2017 7:54:53 AM. I am writing this article based on request by some developers regarding how to write some complex queries using LINQ & Lambda expression which consist of joins / groupby / aggregate functions
What LINQ is6/22/2017 4:21:49 AM. In this article you will learn about LINQ. Language Integrated Query (LINQ) enables us to query any type of data stored in SQL Server, XML documents, List, Arrays and so on.
LINQ Basic To Advanced - MVC Demo Application5/17/2017 5:44:49 PM. Here, in this post, we are going to see some basic and advanced LINQ queries
What Is Deferred/ Lazy Loading And Eager Loading?4/28/2017 3:18:56 PM. In his article, you will learn about Deferred/ Lazy Loading and Eager Loading.

Topics