Differences between .net IQueryable and IList

Little scum · Posted on 8/22/2016 11:22:07 AM

IList (IList<T>) immediately creates persistent data in memory, which does not implement "deferred execution", and if the loaded entity has associated entities, the associated entity will not be loaded (neither immediately nor lazy).

IQeurable <T>does not immediately create persistent data in memory, but only loads data into memory if it is traversed (e.g. through forreach), converted to a list, etc., and can achieve "deferred execution", if the currently loaded entity has associations, this associated entity can be loaded by the next access.

Look at the following piece of code:
//IList的情况
IList users = res. ToList(); Users have been loaded into memory, but the associated entity (UserInfos) for each user has not
is loaded, so the next line of code doesn't go through smoothly
var ss = users. Where(p => p.UserInfos.ID != 3); Error is reported here because P's UserInfos entity cannot be loaded

IQuerable's situation
IQueryable users = res. AsQueryable(); users are not loaded immediately, and the associated entity can be obtained by "lazy loading"
Got it
var ss = users. Where(p => p.UserInfos.ID != 3); The corresponding SS was successfully obtained here

[Source] Differences between .net IQueryable and IList

Sections viewed