DEV Community

Understanding IQueryable<T> in C#

Rasheed K Mozaffar on June 20, 2024

Hi There! 👋🏻 You've probably used IEnumerable&lt;T&gt;, and most certainly used List&lt;T&gt; if you've coded in C# before. These two ar...
Collapse
 
1hamzabek profile image
Hamza

i really needed it

Collapse
 
ezilemdodana profile image
Ezile Mdodana

Great, thank you very much for sharing!

Collapse
 
01dri profile image
Diego Henrique

thanks for sharing!!

Collapse
 
adn_ng_5d75dafc2f4b7f531f profile image
Adn Ng

Thank you for sharing

Collapse
 
sohilahmed profile image
Sohil Ahmed

Good article but you should also mention how SQL queries are optimised, show what you did and how are they executed at database.

For EF in debugging execution, linq displays SQL queries, that can also be used to further optimize quarries.

Collapse
 
admiralkheir profile image
Tugay Ersoy

Yes, and profiler on the sql server side can be good for hands on

Collapse
 
sohilahmed profile image
Sohil Ahmed

SQL Profiler is an amazing tool and love to use in production environment when I just couldn't retrace the issue reported by the support team, but in debug environment when I'm developing feature or repairing a bug, its always a good idea to see SQL so that it can optimized, with time I've learned what need to be done but for someone how is starting from scratch, or is new to LinQ (shifting from ADO to EF) option to see SQL really makes my job easy as Sr. Developer and lets be focus on one tool rather than focusing in two.

but that's just my opinion.

Collapse
 
david_pierson_22b9a98d865 profile image
David Pierson

Very clear examples. Well written, and gives much practical advice. Thank you.

Collapse
 
dotnet-devs profile image
Alex

Thanks for the article!

Collapse
 
rasheedmozaffar profile image
Rasheed K Mozaffar

Glad you liked it!

Collapse
 
ozan_yarci profile image
Ozan Yarcı

Great content, thank you!

Collapse
 
rasheedmozaffar profile image
Rasheed K Mozaffar

Glad you found it helpful!