Mr.Venkat I would like to thank you from the bottom of my heart.Your mvc tutorials were the starting point of my mvc career.I have been working with a company using MVC 5 for some time now.Thanks again god bless you.
Hello Dear Hasanuzzaman, Thank you very much for the feedback. Means a lot to me. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. ua-cam.com/video/y780MwhY70s/v-deo.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ua-cam.com/users/kudvenkat If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat
We don't have to hit db again and again to get the desired data as per condition. whenever we hit query it gets data from memory rather than db which improves the execution performance. Compare this scenario with a dinner time. If you have everything on your table (memory) for dinner then you don't have to go to kitchen (db) and take the required dish from there. Keeping all the required things on table will save your time and make dinner time good 😊
AsEnumerable as stated in the video is executed in memory where in AsQueryable is suitable for querying data from out-memory (like remote database, service) collections, in this case sql server.
Explanation was simple and understood very well. but one query comes to mind why we need to do so. Where can we apply this concept in real world projects?
Nice. Thanks for the tutorial . I've one quest. Which operator it default takes? as if we do not use any operator then result come direct from SQL Server collection like IQueryable.
Mr.Venkat I would like to thank you from the bottom of my heart.Your mvc tutorials were the starting point of my mvc career.I have been working with a company using MVC 5 for some time now.Thanks again god bless you.
Hello Dear Hasanuzzaman,
Thank you very much for the feedback. Means a lot to me. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos for offline viewing please visit
www.pragimtech.com/kudvenkat_dvd.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
ua-cam.com/video/y780MwhY70s/v-deo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ua-cam.com/users/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Good Luck
Venkat
Venkat thanks for your kind answer.
@@Csharp-video-tutorialsBlogspot Hello Venkat sir, But AsQuerayable operator is missing in this video
These videos are gold, kudvenkat you help sooo many aspiring programmers all around the world
Again everything is explained with simplicity. Thank you Venkat...
Hi Venkat! Your tutorials make me better programmer.
what is the benefits when I executed query on the memory rather than on the database side?
We don't have to hit db again and again to get the desired data as per condition. whenever we hit query it gets data from memory rather than db which improves the execution performance.
Compare this scenario with a dinner time. If you have everything on your table (memory) for dinner then you don't have to go to kitchen (db) and take the required dish from there. Keeping all the required things on table will save your time and make dinner time good 😊
You do things uniquely and explain them precisely... Thanks for knowledge sharing !!
Please explain Asqueryable().And also in what case we have to use AsEnumerable and Asqueryable
AsEnumerable as stated in the video is executed in memory where in AsQueryable is suitable for querying data from out-memory (like remote database, service) collections, in this case sql server.
For all of those who wants to understand the difference with AsQueryable, read here
stackoverflow.com/questions/1578778/using-iqueryable-with-linq
the best teacher
Very well explained nice work.
Very nicely explained, good video. But where is AsQueryable ?
I think sir you must be interactive also... You have not replied to anyone's comment...
kudvenkat Can you please explain a case when AsEnumerable would be required?
Awesome!! Awesome as usual!!
Very Good Understanding...
Awesome kudvenkat
video is full of knowledge but AsQueryable is not discussed
@@RameshKumar-bj1wv Thanks !
Explanation was simple and understood very well. but one query comes to mind why we need to do so. Where can we apply this concept in real world projects?
great tutorial as always
shall we use edmx instead of dbml sir?
Thank You Sir :)
Can somebody tell why one will use AsEnumerable? Asking because its never a good idea to get a huge collection in memory and then operate on it.
What is the use of moving query processing to client side?
thank you sir
Thanks
Nice. Thanks for the tutorial . I've one quest. Which operator it default takes? as if we do not use any operator then result come direct from SQL Server collection like IQueryable.
thnx a lot sir
Good vid but AsQueryable is not discussed in the video
Because he will talk about it in Unit testing video
Please do explain AsQueryable() also!
AsQueryble is not discussed. Anyway nice explanation
excellent video. But when where do we discussed AsQuearyable?
Simply Awesome
nice
can you explain repository framework please ?
nice :)
Why not explain AsQueryable, as video post is like - AsEnumerable & AsQueryable
Nice one, however, AsQueriable not here..
Where is querable?
Where is AsQueryable ?
Thank You Sir :)