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

For more such videos visit www.questpond.com
For more such videos subscribe / questpondvideos
See our other Step by Step video series below :-
JavaScript Interview Questions: • JavaScript Interview Q...
C# tutorial for beginners (4 hrs):- • C# Tutorial for Beginn...
Abstract class vs Interface in C# :- • Abstract Class vs Inte...
ASP.NET MVC Core Interview Questions with answers:- • ASP.NET MVC Interview ...
Angular Interview Questions and Answers :- • Angular Interview Ques...
C# interview questions and answers:- • C# Interview Questions...
Azure AZ-900 fundamentals certification :- • AZ 900 Certification |...
Learn Angular tutorial step by step tinyurl.com/ycd9j895
Learn MVC Core step by step :- tinyurl.com/y9jt3wkv
Learn Design Pattern Step by Step goo.gl/eJdn0m
Python Tutorial for Beginners:- • Python Tutorial for Be...
Learn Data Science in 1 hour :- tinyurl.com/y5o7qbau
Learn Power BI Step by Step:- tinyurl.com/y6thhkxw
PHP Interview Questions : • PHP Interview Question...
Learn MSBI Step by Step in 32 hours:- goo.gl/TTpFZN
Learn Tableau step by step :- tinyurl.com/kh6ojyo
Learn SQL Server Step by Step tinyurl.com/ja4zmwu
Learn SharePoint Step by Step in 8 hours:- goo.gl/XQKHeP
Difference between ienumerable vs iqueryable c#
-----------------------------------------------------------------------------------------------
For more details :-
🌐 Website : www.questpond.com
📱 Mob. No. : [phone] / [phone] / [phone]
📧Email : [e-mail] / [e-mail] / [e-mail]
Share, Support, Subscribe and Connect us on!!!
CZcams: / questpondvideos
Twitter: / questpond
Instagram : / questpond
Facebook : / questpond
#DifferenceBetweenIEnumerable&Iqueryable #CSharpIEnumerable #CSharpIqueryable #C#Questions #CsharpInterviewQuestions #C#InterviewQuestions&Answers

[@questpondvideos]

ASP.NET, C# Job Market : czcams.com/video/H3JEWAp32-s/video.html
30 Important C# Interview Questions : czcams.com/video/BKynEBPqiIM/video.html
Software Architecture Interview Questions : czcams.com/video/AtTgcbLOqMM/video.html
25+ OOPS Interview Questions : czcams.com/video/u99wAoBjDvQ/video.html
20+ SQL Server Interview Questions : czcams.com/video/SEdAF8mSKS4/video.html
10+ Power BI Interview Questions : czcams.com/video/Cozc9WNBRt4/video.html
20 MSBI Interview Questions : czcams.com/video/Nw_sHEKnOUE/video.html
SQL Server Joins : czcams.com/video/KTvYHEntvn8/video.html
SQL Step by Step - czcams.com/video/uGlfP9o7kmY/video.html
Angular Step by Step Tutorial for Beginners : czcams.com/video/-9VcW7MBDs8/video.html
25 Angular Interview Questions : czcams.com/video/-jeoyDJDsSM/video.html
25 Important ASP.NET Interview Questions : czcams.com/video/pXmMdmJUC0g/video.html
35 Important JavaScript Interview Questions : czcams.com/video/Zb4dPi7CANU/video.html
20 MySQL Interview Questions : czcams.com/video/9hfjC-BpY20/video.html
5 MSBI Interview Questions : czcams.com/video/5E815aXAwYQ/video.html
20 PHP Interview Questions : czcams.com/video/1bpNSynUrl8/video.html

[@ladanseyedzadeh1090]

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.

[@zebcode]

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

[@pearsonkevin4699]

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

[@CezarLisboa1990]

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

[@kopilkaiser8991]

In my junior dev job, they were using different places interechangeably these two collection types: IEnumerable & IQueryable. And I was very confused with the requirement of doing such implementation. You have clarified my doubts and questions. And it makes a big difference of using the two different types of collections when we are mutating the various different objects. Thank you so much for taking the effort and time to deliver such essential information.

[@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?

[@MrTanveer416]

Excellent explanation within a very short time.

[@cristianfarcas3272]

I've been looking for this kind of video for a couple of hours already. great job!

[@mrmanualways]

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

[@AhmadElkhouly]

Thank you. This 7-minute video indirectly answered a question I've been trying to find an answer to for a while. Subscribed. 🎉

[@thesuperiorman8342]

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

[@musabalriani550]

Thanks a lot ,This is the best advice in my day.

[@doctonb]

Great explanation and information, thank you!

[@shreekantnoida]

I really see awesome practical example. thanks a lot sir.

[@suvmatrix]

Awesome way of showing the difference. That's what I like in your content

[@attilaguba856]

Super great explanation! Clearly understandable! Thanks!!! Keep up your good teaching

[@govindwaghmode6379]

Great explanation sir. Thank you so much.

[@AjaySaini-107]

Really cleared explanation in simple words.

[@malkitsaggu]

Very clear explanation. Thank you.

[@perumalchinnasamy1735]

Very nice explanation, Great man!, thank you so much!

[@bensonputhethu5918]

This video was awesome, straight to the point!

[@zaharivaklinov]

Great video with the answer on the question! I failed an interview the other day due to some failed answer attempts, one of which was about the difference between IEnumerable and IQueryable...

[@avinash23525]

Nice. well explained !. can't we filter while loading Employee table or using linq ?

[@vikasverma4215]

Now clear... Love it.

[@maha2818]

Awesome sir. You are great. Nicely explained the topic and very easy to understand the difference. Please keep your awesome teaching.
Thanks

[@SimplefundBaba]

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

[@prasadmadushan]

Thank you for your great explanation.

[@createyourworld2530]

tnx, man! It was really good video and good explaining different between IEnumerable and IQueryable!!! Like!

[@mrohailiqbal]

Sir you are great. Very useful video. Thanks a lot!!

[@rhoonah5849]

Excellent video. Very simply explanation of the differences between IQueryable and IEnumerable with EF.
Quick question though... if you applied a ToList() on the end of where you called dal.Employees so it was dal.Employees.ToList(), would all calls now be in memory? So would you only have gone to the DB once to load the Employees table and then all filters are just applied to the in memory list? Thank you.

[@abhilabdas9870]

Thank you so much for this explanation! God bless

[@imadabab]

Excellent tutorial. Thanks a lot.

[@AShahabov]

Thanks for good explanation!

[@AmmarTheTrainer]

Awesome... what an explanation.. Thank-you sir

[@noellangcauon7133]

Thanks bro! keep uploading useful information like this!

[@RaterisimoCBA]

Good video ! Simple and concrete answer.

[@thishandharmakeerthi5327]

This channel is one of the most underrated channels in youtube.

[@twitchdude55]

very clear explained, nailed it

[@suchismitasenapati1625]

Nicely explained. Thank you 😊

[@kumarkashyappandey6278]

You are great, Sir!

[@narendarsingh4672]

what a nice tutorial sir ji,great

[@imadabab]

Brilliant. Thanks a lot.

[@TheXunty]

Great explanation, thanks boss.

[@rezkhan3366]

Great explanation. Thanks!

[@trisonics1]

nice and informative. Thanks

[@tahatemuri8170]

Good show and crystal clear

[@rutujamokashi6389]

It's really very helpful for me...

[@SweepAndZone]

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

[@4bitmultiplexer]

Very excellent explanation...

[@rajasekharjangam4999]

Very nice explanation bro, thank you

[@AbhishekPoojara]

Great One... Superb Exlpaination.

[@claytonmcgill875]

Thank you so much for this !

[@RiskyBizz]

nice video, great information

[@lksharma6843]

Explanation was awesome

[@manoranjansahoo9721]

Thanks for making clear understanding, Please make video on visual studio 2019 tools, its features, tips & hidden tricks etc.

[@RaviKumar-td1oj]

Great explanation sir.

[@Iamnontechnical]

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

[@MSMOTOVLOGS]

Nice video. To the point. No BS

[@ayedabboushi7221]

Many thanks man.

[@cesareemauritanie5288]

Thanks a lot !!!

[@maelorable]

VERY useful video.

[@Uzair_Anwar2299]

Good explaination

[@bntdgp]

Unique Explaining

[@heenapatel1728]

Great explanation 👍

[@ale_gallardo]

Well explained, thanks

[@MrJaneHolliday]

This is neat.

[@ajaypanse4489]

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

[@bahalulkabir]

Thank you very much

[@bernardfitzgerald5697]

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

[@OT-tn7ci]

if there are table changes, and if IQueryable doesn't work, most likely even IEnumerable won't work.

[@DHARMENDRAKUMARdkp]

Great.......

[@user-su7sk3bk1r]

Thank you so much

[@ayedabboushi7221]

Many thanks

[@sidheshwarrandhave5968]

Its good for me
great sir

[@finwwwfinwww4669]

Thank you!

[@moumantimusicalmasti]

Thank you sir..

[@atifzafarkhan6703]

Worth to watch

[@moubienkayali6718]

thanks a lot

[@sanketshahane5778]

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 results = db.GetTable().Where(Expression);
var recordList = results.ToList();
int totalRecords = results.Count();
Please help..!
Thank you in advance..!!

[@sergeiarhipenko872]

thanks for this vid

[@sethnejame6786]

Good stuff.

[@sujitkumarjha7720]

Brilliant 👍

[@sridevi2011]

Perfect

[@inAshsHead]

Thanks

[@mytrolls5866]

Excellent

[@DeepakSaini-pv3rq]

awesome sir

[@prudhvirajs494]

You are awesome 😎

[@mosesnova]

Great video adds more insight into collections.

[@lovelybuck]

Super

[@ghanshamkashyup6235]

Super sir

[@vkeychaudhari]

Best video

[@SonuSingh-nj6vp]

Nice

[@rahulmishra5438]

At the starting of the video you have shown us the playlist where we'll get those videos??

[@questpondvideos]

visit www.questpond.com

[@RahulSharma-ps1rf]

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

[@MohammedDawoodAnsari]

Another use case would be to add filters on run time, for example in your query if there is one more parameter lets say as name, so if name filter needs to be applied based on condition, then also you can use IQuerayable

[@SmileIfYouhaveTeeth]

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

[@artak9439]

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

[@nandishdhadd5834]

In simple words, using Iqueryable will defer query execution..

[@questpondvideos]

yes sir , but until we do not see it , simple words are not simple :-) happy learning.

[@expertreviews1112]

Hi sir, but I thought interfaces are abstract and don't contain any logic then how are the differences highlighted in the video work.

[@questpondvideos]

Interfaces are pointing to a list or some concrete collection

[@expertreviews1112]

Thank you. Can you point out a resource where I can get this type of info?

[@nammozhi819]

I have interview tomorrow..hope this one helps

[@questpondvideos]

Just prepare this video you should be able to answer 15% of the interview questions czcams.com/video/BKynEBPqiIM/video.html

[@learningislife2934]

Sir please make interface video
Please 🙏

[@questpondvideos]

Our video on Abstract class & Interfaces you can watch below :-
czcams.com/video/0EnSPBVrbG0/video.html