score:3
there is an sql query generated in the background. it may be as complex as required to only fetch the relevant data.
if a query cannot be generated because certain linq features are not supported against a database, then the whole expression will not be compiled (to sql). you can override this behaviour manually if you want to fetch all data and then filter in a complex way on the client side. to do that, you place .tolist() or .toarray() at some early point of your linq query, and carry on where'ing that list.
you can also view the resulting sql.
more reading: linq to sql queries.
Source: stackoverflow.com
Related Query
- Does LINQ convert code to SQL queries
- Why does LINQ to SQL translate GroupBy into multiple queries
- How do i convert this linq code to inline sql
- convert linq to object query to sql query (no linq to sql code or datacontext)
- convert sql queries to linq queries
- Convert code that uses Linq to code that does not
- Convert SQL code to linq (LIKE, SELECT)
- Does Linq in Entity Framework code first use SQL or does it get the whole table first?
- Convert SQL update query to c# LINQ code
- Convert SQL to Linq queries in Entity Framework
- Convert sql code to linq (Inner join Query)
- Convert string[] to int[] in one line of code using LINQ
- Convert SQL to Linq left join with null
- How are people unit testing code that uses Linq to SQL
- how to convert sql union to linq
- Why does ReSharper suggest I convert a for loop into a LINQ expression?
- Convert simple SQL group-by into LINQ to SQL
- EF Core nested Linq select results in N + 1 SQL queries
- Convert LINQ Expression to SQL Text without DB Context
- How to Convert Row to Column in Linq and SQL
- Convert SQL to LINQ Query
- LINQ to SQL does not update when data has changed in database
- If it's bad to use inline SQL, how does using LINQ to perform queries differ in practice?
- How can I directly execute SQL queries in linq
- performance of LINQ queries against the SQL equivalent
- Does this LINQ code perform multiple lookups on the original data?
- LINQ to SQL *compiled* queries and when they execute
- How can I convert this SQL Query into LINQ (OVER (PARTITION BY Date))
- Why does Entity Framework 6 generate complex SQL queries for simple lookups?
- Which versions of SQL Server does LINQ to SQL support?
More Query from same tag
- Combining items in a given datatable column using LINQ
- trying to sort a list with Linq
- Update entity in mvc4
- Need to Convert this SQL query to LINQ
- LINQ query for subset of two parallel arrays
- retrieve data with Contains id
- Using Linq in domain service in Silverlight
- LINQ: Call Stored Procedure and Join its results with IQueryable
- Searching if value exists in a list of objects using Linq
- Linq to SQL: Combining objects through a summation of one field only
- are you missing a using directive or an assembly reference?
- How can I have an index value inside an inner select in a LINQ expression?
- convert Request.QueryString toDatetime and then fetch using datacontext in linq in c# asp.net
- Different OrderBy based on different filters
- how to store dynamically the desired value in my linqued query variable
- Use Include method to show specific fields in a jount table
- Linq get child from Parent.Child.child
- linq with null condition
- linq query list of guids
- Selecting earliest date using linq/lambda
- Getting username from Linked tables using Linq
- Linq to XML (C#) parse XML tree with no attributes/id to object
- how to debug `Null reference exception occured` in linq?
- Fluent Nhibernate QueryOver fetch record only by Date without time
- Linq operations against a List of Hashtables?
- Use linq to populate model with data from two diffrent models
- LINQ to objects changing the display column
- EF6 - Include objects with List<Func<T, object>>
- How to select/merge multiple matching result?
- How to write an efficient LINQ query when searching by both parent and child entity fields
