IEnumerable vs IQueryable C# | C# Interview Questions | Csharp Interview Questions and Answers

See our other Step by Step video series below :-

Difference between ienumerable vs iqueryable c#
-----------------------------------------------------------------------------------------------
For more details :-
📱 Mob. No. : [phone] / [phone] / [phone]

Share, Support, Subscribe and Connect us on!!!

#DifferenceBetweenIEnumerable&Iqueryable #CSharpIEnumerable #CSharpIqueryable #C#Questions #CsharpInterviewQuestions #C#InterviewQuestions&Answers

[zebcode]

Straight to the point, you answered the question and visually showed the effects of using IQueryable using the profiler. Very well done!

[ladanseyedzadeh]

You are the best instructor in the field of programming based on my experience, I wish I had a professor like you when I studied CE at University. I can not help but admire your natural talent to simplify complex concepts.

[ajaypanse]

Hi Shiv,

Your videos are very good to understand the concepts.
In one of the interviews, along with this difference I was asked which one is having thread safety feature or thread safe.
I couldn't answer it properly. I tried to search on net but didn't get proper answer. Can you help me to get this answer so it will help me to clear that concept.

Thanks

[pearsonkevin]

Short and sweet yet taught ME the difference! Thank you!!!

[thesuperiorman]

I like the way you explain these topics in all your videos.

[mrmanualways]

awesome bro.. can't say thank you enough to all youtube teachers .. Happy 2019

[AjaySaini-]

Really cleared explanation in simple words.

[BrutusPalmeira]

Great video as always. Of course an example of in memory would have been nice too. If we have an in memory list and we use iqueryable instead of ienumerable, do we get any drawbacks?

[bernardfitzgerald]

Might be worth noting that the delay in querying the database could lead to adverse results if there are table changes between creating the interface and applying the filter. Good video though

[CezarLisboa]

Perfect! Great video! Very useful for deciding to use both interfaces. Thank you!

[MrTanveer]

Excellent explanation within a very short time.

[artak]

If I remember IEnumerable uses expression tree and IQueriable uses tree traversial.

[SweepAndZone]

❤ 😮 wow thats awesome! This can be a huge performance hindrance

[RahulSharma-psrf]

Hello Sir, I have one question. We have 2 options to get data from DB using EF ie. List<tableName> data = => x.id == 33144).ToList(); and List<tableName> data = _context.TableName.Where(x => x.id == 33144).ToList();. Both have same impact when we see in SQL profiler then why to use IQueryable?

[gulbadanofficial]

Thank You Sir It helps a lot 😍.. Good information

[Iamnontechnical]

good example, suggestion work more on speech it will become great

[mosesnova]

Great video adds more insight into collections.

[SmileIfYouhaveTeeth]

Can i get referral for .net developer fresher opening!??

[sanketshahane]

Very Nicely Explained it sir,
But I have one small query regarding IQueryable, may be it is silly question (don't mind)..!!
If I am declaring IQueryable variable and initializing (getting data from DB) Apply where conditions and filter the data, and in next line I am getting a count() of that variable then there will be 2 DB call (1st for getting data with filtered and 2nd for getting count(*)) or only 1st DB call..??
Ex:
IQueryable<TableName> results =

var recordList = results.ToList();

int totalRecords = results.Count();

Please help..!
Thank you in advance..!!

[SimplefundBaba]

Great video, i was always confused to these concept. but today i am fully clear on this concept.