does converting iqueryable to ienumerable execute the query again?

Question

in my query i need to return ienumerable but i dont know if this action make the query to execute again?

var data=Repository.Find().AsEnumerable();

find() returns iqueryable and because iqueryable inherits ienumerable i doubt if AsEnumerable make the repeatetive execution.

i know that var data=Repository.Find().ToList() make executes the query 2 times. one for find() and second for tolist()

Answer 1

An IQueryable is an IEnumerable. There is no conversion, and therefore no work of any kind going on.

The work happens when you call GetEnumerator(), either explicitly or by invoking foreach on it.

Also, have you confirmed that Repository.Find().ToList() calls SQL twice? That doesn't sound right to me.

Answer 2

AsEnumerable does not actually do anything except apply the as operator to your IQueryable. Accordingly, any future method you apply to your object will use the System.Linq.Enumerable set of extension methods as opposed to the System.Linq.Queryable methods.

It's all about deferred execution. Nothing ever gets executed against your queryable source (the database presumably) until you try to enumerate.

In other words:

var data=Repository.Find().AsEnumerable() 
/* The query is only actually performed AFTER here */  
.ToList();

If your code:

var data=Repository.Find().ToList();

executes the query two times, it's because you're doing something incorrect in your Find() method, which should definitely should not be the case.

var data = Respository.Find();

should execute the query ZERO times.

var result = data.ToList(); // THIS is what should execute the query.

Answer 3

think of linq as a "Stream" and aggregate function is a "Flush". "linq to db" stream can only flush once. .AsEnumerable(), .Where(), .... is a way to prepare query .ToList(), .First(), .Max() is an aggregate but if u not call aggregate, then your linq result wont run. its start to work only when its being enumerate.

ex

var result = users.Select(usr => usr.Name);

nothing will happen here until

1 aggregate is called

result.First()

or 2 result is being enumerate

result.ToList().ForEach(...)

to answer yout question - .Find(), .AsEnumerable() is not an aggregate function