IEnumerable, IEnumerator, IQueryable in C# .NET

Q. What is IEnumerable in C#?
Q. What is the difference between IEnumerable and IEnumerator in C#?
Q. What is the difference between IEnumerable and IQueryable in C#?
Why to use IQueryable in sql queries?
1. Full .NET Interview Course (with PDF Book)
C# / ASP.NET Core / MVC / API - Top 500 Interview Questions
www.udemy.com/...
Don't worry if course not helping you, Udemy has 30 days Free Refund Policy.
2. Quick Revision Book (PDF format)
Top 500 .NET Interview Questions - OOPS/ C#/ ASP.Net/ MVC/ SQL /.Net Core /Web API
imojo.in/inter...
50% Off - Limited Time Offer Applied on above link.
Don't worry if book not helping you, I will return 100% of your money with in 7 days of purchase. Just mail me at [e-mail].
My best wishes are with you.

[@digambarbhandare4485]

Good explanation sir. In short IEnumerable featch the data and filtere it rather than IQuerable featch filtered data. That's why it is faster as compare to IEnumerable

[@runawayvon01]

This appears as a question from the technical round.
Thank you so much for this because I got the job offer.

[@nishanthgmk3487]

Very well explained, subscribed to your channel because of this great explanation :)

[@interviewhappy]

Thanks Nishant and all the best for your career.

[@nishanthgmk3487]

@@interviewhappy thank you, same to you!

[@MyLifestyleYaaro]

You make the video short and to the point.. good for revision...Add one more video if possible regarding best code practices... And best design patterns with situations..

[@nguyenducduy5013]

amazing explaination, thank bro

[@logeshk2811]

can you explain about the pipielines in program.cs? What's the flow

[@interviewhappy]

Hi Logesh, I think I already explained this in .NET core part

[@levkirichuk]

Nice video, one point IQueryable executes a "select query" on server-side with all filters that appended to it until database execution.
That give to use make more flexible code.

[@mihirkumartripathy9412]

Hi Sir, I have one doubt.. in which scenario we have to use innumerable rather than iqurable in linq query ?

[@interviewhappy]

When you have in-memory collections

[@serg1778]

​@@interviewhappyyesterday i was testing IEnumerable and IQueryable and got the same result using inline query with linq Where(),that is each of them generated sql where.But using 2 lines,like : IEnumerable data = context.Users; var filtered = data.Where(...).ToList(); In this case with IEnumerable we don't have sql where.Can you clarify it?

[@pranavbhat92]

@@serg1778 If you are using SQL server, then you can check that in SQL Server Profiler. Just check which query is being executed.

[@himanshuverma9596]

Crisp and clear explanation

[@interviewhappy]

Thanks and all the best Himanshu

[@shwetaranshinge3803]

Very useful explanation..

[@interviewhappy]

Thanks Shweta and all the best for your career.

[@imadabab]

Brilliant. Thanks a lot.

[@SravikaVaka]

Sir.., Can you explain solid principles concept bit brief

[@interviewhappy]

Sure Will do it soon Sravika

[@waqasmumtaz6109]

Wah Sir g