score:1
Accepted answer
They will be lazily evaluated if these methods return IEnumerable<T>.
score:2
If they are using Linq to SQL, this gets translated to proper SQL and only the records that are affected by the where clause will be returned.
Source: stackoverflow.com
Related Query
- GetAll or GetList Functions And Performance Problem
- I am wondering about the state of connection and impact on code performance by 'yield' while iterating over data reader object
- Performance tuning C# permutations and SHA1 code
- EF Code first Eager loading and OrderBy problem
- Comparing two lists of Strings and counting the matches, possible performance problem
- Problem with LINQ to Entities and String.StartsWith
- Entity Framework, Code First and Full Text Search
- What does this C# code with an "arrow" mean and how is it called?
- What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
- LINQ performance Count vs Where and Count
- How to count the number of code lines in a C# solution, without comments and empty lines, and other redundant stuff, etc?
- Entity Framework 6 Code First Custom Functions
- Performance Difference between LINQ and Stored Procedures
- OrderBy and Top in LINQ with good performance
- Use a Inline Table-Valued Functions with Linq and Entity Framework Core
- Hierarchical data in Linq - options and performance
- Simple sql to Linq query with group by and aggregate functions
- Enumerable.Empty<T>().AsQueryable(); This method supports the LINQ to Entities infrastructure and is not intended to be used directly from your code
- LINQ aggregate functions on bytes, shorts, and unsigned values
- Linq Intersect bool query and performance
- Linq Count method and Performance
- Problem with inheritance and List<>
- .NET String parsing performance improvement - Possible Code Smell
- C# linq order by and other statements with foreach, is there a performance difference?
- Is there any performance difference between myCollection.Where(...).FirstOrDefault() and myCollection.FirstOrDefault(...)
- LINQ Source Code Available
- Iterating over IQueryable with forEach vs. calling ToList() and then doing forEach - performance
- Difference between the returned values of two selector functions in this code
- Refactor Linq code and "LINQ to Entities does not recognize the method"
- .NET 4 Code Contracts: "requires unproven: source != null"
More Query from same tag
- How to retrieve the particular X th position of node using xpath?
- LINQ to SQL and configuring it not to use TOP
- Is it possible to prevent LINQ from using variables in queries and instead use string literals?
- How can i set the external data that not exist dto object to domain on automapper
- LINQ to SQL and Attaching Child Objects
- Linq SelectMany error
- Linq IGrouping, ILookup or IDIctionary divide and map into new IEnumerable
- How to check the second element of an array in linq only if it exists
- C# - from SQL to Linq - Left Outer Join/Inner Join
- C# CopyToDataTable method not working
- Dynamic JSON querying JSON.NET
- Filtering by plain date SQL to Linq syntax
- IQueryable Confusion
- Left join Linq is not working in Nopcommerce Service
- How can i change multiple same values with other in list?
- LINQ Replace Different String Values
- Linq, use "variable" inside a anonymous type
- How to make a simple formula with the current attributes in LINQ Group By?
- Linq: List all Rows in DataGridView that contain at least 2 cells with a Value
- LINQ: Converting grouped list into new list
- How to get list of all ApplicationUsers who are in certain Role from database by LINQ expression?
- Linq query to fill complex model?
- Split IEnumerable in three parts: "above", "item", "below" with efficiency
- LINQ query JOIN two tables for Web API controller method
- How to get the names of nodes with Linq
- LINQ left outer join on date not working
- Cast LINQ object as to another LINQ class
- foreach vs sum for multiple fields
- Linq left join and count - How To
- how to simplify code to print all items in an array use one line code in c#
