filmov
tv
Part 17 AsEnumerable and AsQueryable in LINQ
Показать описание
Text version of the video
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
Slides
LINQ Tutorial - All Text Articles & Slides
LINQ Tutorial Playlist
Dot Net, SQL, Angular, JavaScript, jQuery and Bootstrap complete courses
In this video we will discuss the use of AsEnumerable and AsQueryable operators in LINQ. Both of these operators belong to Conversion Operators category.
AsQueryable operator : There are 2 overloaded versions of this method.
One overloaded version converts System.Collections.IEnumerable to System.Linq.IQueryable
The other overloaded version converts a generic System.Collections.Generic.IEnumerable[T] to a generic System.Linq.IQueryable[T]
The main use of AsQueryable operator is unit testing to mock a queryable data source using an in-memory data source. We will discuss this operator in detail with examples in unit testing video series.
AsEnumerable operator breaks the query into 2 parts
1. The "inside part" that is the query before AsEnumerable operator is executed as Linq-to-SQL
2. The "ouside part" that is the query after AsEnumerable operator is executed as Linq-to-Objects
So in this example the following SQL Query is executed against SQL Server, all the data is brought into the console application and then the WHERE, ORDERBY & TOP operators are applied on the client-side
SELECT [t0].[ID], [t0].[Name], [t0].[Gender], [t0].[Salary]
FROM [dbo].[Employees] AS [t0]
So in short, use AsEnumerable operator to move query processing to the client side.
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
Slides
LINQ Tutorial - All Text Articles & Slides
LINQ Tutorial Playlist
Dot Net, SQL, Angular, JavaScript, jQuery and Bootstrap complete courses
In this video we will discuss the use of AsEnumerable and AsQueryable operators in LINQ. Both of these operators belong to Conversion Operators category.
AsQueryable operator : There are 2 overloaded versions of this method.
One overloaded version converts System.Collections.IEnumerable to System.Linq.IQueryable
The other overloaded version converts a generic System.Collections.Generic.IEnumerable[T] to a generic System.Linq.IQueryable[T]
The main use of AsQueryable operator is unit testing to mock a queryable data source using an in-memory data source. We will discuss this operator in detail with examples in unit testing video series.
AsEnumerable operator breaks the query into 2 parts
1. The "inside part" that is the query before AsEnumerable operator is executed as Linq-to-SQL
2. The "ouside part" that is the query after AsEnumerable operator is executed as Linq-to-Objects
So in this example the following SQL Query is executed against SQL Server, all the data is brought into the console application and then the WHERE, ORDERBY & TOP operators are applied on the client-side
SELECT [t0].[ID], [t0].[Name], [t0].[Gender], [t0].[Salary]
FROM [dbo].[Employees] AS [t0]
So in short, use AsEnumerable operator to move query processing to the client side.
0:08:08
Part 17 AsEnumerable and AsQueryable in LINQ
0:08:08
AsEnumerable and AsQueryable in LINQ-Part 17
0:09:23
AsEnumerable and AsQueryable in LINQ in arabic
0:35:02
Методы AsEnumerable и AsQueryable бесполезны?
0:13:14
ToList, AsEnumerable, AsQueryable in EF Core and Relation to Performance
0:04:49
When to use IEnumerable vs IQueryable?
0:11:28
Understand your C# queries! IEnumerable & IQueryable in explained
0:08:59
Part 17 Concurrency in Linq to SQL
0:18:17
Enumerables (IEnumerable, IEnumerator) | C# Programming Tutorials Beginners: 17
0:07:21
IEnumerable vs IQueryable C# | C# Interview Questions | Csharp Interview Questions and Answers
0:01:56
CSharp - LINQ - Query table using query expression to IQueryable
0:01:34
2 Minutes Problem Solved LINQ When to use IEnumerable vs IQueryable | The Developer Q&A Series
0:17:55
Tutorial C#.Net - Queryable vs Enumera & LINQ Best Practices
0:11:39
IEnumerable vs IQueryable
0:10:35
IQueryable VS IEnumerable - C#
0:01:20
C# : What is the purpose of AsQueryable()?
0:03:32
ienumerable iqueryable
0:03:38
01 IEnumerable Vs IQueryable
0:04:23
IEnumerable vs. IQueryable | LINQ Specific Programming Constructs
0:01:24
C# : Force IEnumerable T to evaluate without calling .ToArray() or .ToList()
0:01:31
What is the difference between IEnumerable and IQueryable in C#?
0:01:21
C# : Retrieve LINQ to sql statement (IQueryable) WITH parameters
0:05:02
#167 IEnumerable and Yield Return in C#
0:01:06
SQL : What's the difference between these LINQ queries?
Комментарии