c# - Convert an IQueryable linq query to IEnumerable cancels out linq optimized way to work?

I'm kinda newbie on .NET, and I was wondering how does linq works, since you can aply many linq queries, one after another, but none of them are really executed until they're used to transfer information or converted to list, etc.
There are 2 important ways to get a linq query, by using IQueryable, which aplies the where filters directly on the Sql, and IEnumerable which get all the records and then it work with them on memory. However, let's take a look on this code:

            //Linq dynamic library
            IQueryable myResult = db.Categories
                .Where(a => a.Name.Contains(StringName))
                .OrderBy("Name")

                .Skip(0)
                .Take(10);

            if (myResult != null)
            {
                return myResult.AsEnumerable();
            } 
            else
            { return null; }



Depsite i'm using Linq dynamic library, the direct result from this query is being get on IQueryable, if the query is finally being returned as IEnumerable, is the query being really filtered on the sql? or is it in memory?
 
Answer
 

It's still going to execute in the database, don't worry. Basically it's all down to which implementation of Where etc is used. While you're calling methods on IQueryable - via the Queryable extension methods - it will be using expression trees. When you start to fetch from that query, it will be turned into SQL and sent to the database.

On the other hand, if you use any of those methods after you've got it as an IEnumerable (in terms of the compile-time type), that will use the extension methods in Enumerable, and all of the rest of the processing would be done in-process.

As an example, consider this:

var query = db.People

              .Where(x => x.Name.StartsWith("J"))
              .AsEnumerable()
              .Where(x => x.Age > 20);


Here AsEnumerable() just returns its input sequence, but typed as IEnumerable. In this case, the database query would return only people whose name began with J - and then the age filtering would be done at the client instead.
    


Subscribe to:
Post Comments (Atom)



casting - Why wasn't Tobey Maguire in The Amazing Spider-Man? -
Movies & TV

In the Spider-Man franchise, Tobey Maguire  is an outstanding performer as a Spider-Man and also reprised his role in the sequels Spider-Man...









c++ - Qt project in Visual Studio 2015: "unresolved external symbol
wWinMain"
The whole error output being: LNK2019 unresolved external symbol wWinMain referenced in function "int __cdecl __scrt_common_main_seh(vo...





express - Request header field Access-Control-Allow-Headers is not
allowed by itself in preflight response
I have come across CORS issues multiple times and can usually fix it but I want to really understand by seeing this from a MEAN stack paradi...





Javascript load Image into Offscreen Canvas, perform webp conversion
I recently used canvas to conert images to webp, using : const dataUrl = canvas.toDataURL('image/webp'); But this takes a lots of ti...















Search This Blog