Top End Devs Logo Top End Devs Logo
Dashboard Podcasts Screencasts Courses Coaching Calendar
Sign In
Dashboard Podcasts Screencasts Courses Coaching Calendar
Sign In

.NET 007: What We Know About LINQ

Adventures in .NET

Level up your .NET skills with our weekly discussion of C# and other Microsoft technologies for developers.

Subscribe

  • RSS
  • Apple
  • Amazon
  • Spotify

Follow

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

.NET 007: What We Know About LINQ

Hosts :
  • Caleb Wells
  • Shawn Clabough
Published : Sep 24, 2019
Duration : 48 Minutes

Show Notes

 In this week’s episode of Adventure in .NET the panel shares their experiences using LINQ or Language Integrated Query. They discuss the benefits of using LINQ  along with the struggles they have with it. They share some of their favorite tips and tricks for using LINQ. 
 
LINQ is something .NET developers use on a daily basis. The panel starts by giving a little background on LINQ. LINQ was introduced to the .NET framework 3.5 with the intent of providing a better way of dealing with data. The panel explains what they did before using LINQ and what it was like making the switch. 
 
LINQ has two different syntaxes, the query syntax, and the lambda syntax. The panel discusses the similarities between query syntax and SQL. They explain why they didn’t just use SQL. Because SQL and query were so similar, the panel both started by using query. They share different ways to get used to the query syntax and the lambda syntax. 
 
One benefit of using LING is that it is supported in all .NET languages and has been ported over to other languages such as PHP, JavaScript, and Typescript. The panel discusses using in it Angular Typescript and the similarities between it and C#. 
 
The panel reveals that there are a number of features in .NET that were built to support LINQ. Lambda expressions, anonymous type, and tuples are some examples of features that support LINQ. The panel defines these features and explains how they help you sort through collections of data. 
 
The panel considers why some programmers are turned off by LINQ. They suppose it is because of its foreign look and that it is not highly structured. Also, LINQ has a lot of syntactic sugar, doing a lot of stuff for you behind the scenes. The panel discusses ways LINQ simplifies workflow and shares tips for using LINQ to simply code. 
 
Programmers often complain that using LINQ to objects or LINQ to entities and chaining LINQ extensions is an improper use of LINQ.  The panel explains how using LINQ this way makes the code cleaner and more readable. The panel compares the readability of LINQ statements to SQL statements. They explain why LINQ is easier to read and understand.
 
The panel shares their tips and tricks for using LINQ statements and deferred executions. They discuss the possible use cases for using deferred executions. They also consider the downsides and gotchas to watch for when using deferred executions. 
 
LINQ to entity and the Entity framework are considered. The panel discusses the common complaints made about Entity. They address these complaints, explaining how LINQ to entity and the framework has improved. The panel suggests the use of LINQPad for LINQ statements to see the generated sequel statement. They explain what to watch out for when using LINQ pad this way. 
 
One struggle panel discusses is knowing when to use first or firstordefault. They share tips, things to look for when using either one of these in LINQ. First and single are compared, the panel explains why they use first more than single. 
 
The possibilities for extension methods in LINQ are considered. Along with using C# extension methods the panel discussing using custom extension methods. They share their favorite third party extension methods and explains how they have helped them simplify their code. 
 
While the panel is aware that many programmers are averse to mixing functional programming and object-oriented programming, the panel explains that there are a few functional programming concepts built into LINQ. The benefits of being able to use functional programming in C# is explained. 
 
The panel considers some of the hardest things to do in LINQ and share tips on how to better understand them. Select many and aggregate LINQ queries being to examples they share. The explain what powerful tools they can be. The panel ends the episode with some tips for improving performance when using LINQ
 
Panelists
  • Shawn Clabough
  • Caleb Wells
Sponsors
  • Adventures in Blockchain
  • My Ruby Story
  • The Dev Rev
  • CacheFly
Links
  • https://entityframework-extensions.net/ 
  • https://github.com/morelinq/MoreLINQ 
  • Language Integrated Query (LINQ)
  • https://en.wikipedia.org/wiki/Language_Integrated_Query
  • https://www.tutorialsteacher.com/linq/linq-tutorials
  • Expression Trees (C#)
  • Supporting IAsyncEnumerable with LINQ
  • Get Func-y: Delegates in .NET - Jeremy Clark
  • https://www.facebook.com/Adventures-in-NET-373059030062837/ 
  • https://twitter.com/dotNET_Podcast
Picks
Caleb Wells:
  • Plex
  • PlayOn 
Shawn Clabough:
  • https://www.linqpad.net/ 

  • Title: Adventures in .NET

    Type:PODCAST

    Description:Level up your .NET skills with our weekly discussion of C# and other Microsoft technologies for developers.

  • Adventures in .NET .NET 007: What We Know About LINQ

  • Adventures in .NET Become a Better Developer with Steve (ardalis) Smith - .NET 165

  • Adventures in .NET Microservices Security in Action with Prabath Siriwardena - .NET 201

  • Adventures in .NET .NET 043: The Pros of Using Unity with Jason Weimann CONT'D

  • Adventures in .NET What is a BFF? - .NET 110

  • Adventures in .NET Don't Let These Things Keep You From Podcasting - BONUS

  • Adventures in .NET The S in KISS…..Embracing simplicity with Guilherme Ferreira - .NET 198

  • Adventures in .NET Wonders and Woe of Open Source Development - .NET 067

  • Adventures in .NET Community is Key - .NET 073

  • Adventures in .NET What Is Remote - Containers - .NET 107

  • Adventures in .NET .NET 036: dotNET – Blazoring with C# with Jeff Fritz

  • Adventures in .NET Quantum Computing basics with Q# - .NET 078

  • Adventures in .NET Streamlining Measurement Representations in APIs Using UnisNet Library for .NET - .NET 182

  • Adventures in .NET Building Web Apps with Blazor with Daniel Roth - .NET 183

  • Adventures in .NET Global reach of .NET - .NET 079

  • Adventures in .NET Insight into Azure Functions - .NET 116

  • Adventures in .NET How Do You Grow? - .NET 086

  • Adventures in .NET BONUS: Measuring Apps and Entrepreneurship with John-Daniel Trask

  • Adventures in .NET .NET 023: C#, NodaTime, versioning, and diversity with Jon Skeet Pt1

  • Adventures in .NET .NET 061: C# 9 Deep Dive with Jason Bock

  • Adventures in .NET BONUS: How to do LARGE Volumes of HIGH Quality Work - While Spending Fewer Hours Working

  • Adventures in .NET The future is in WebAssembly - .NET 093

  • Adventures in .NET Grokking gRPC - .NET 108

  • Adventures in .NET Containers with Michael Jolley - .NET 195

  • Adventures in .NET How Fluent Are Your Assertions? - .NET 091

  • Adventures in .NET BONUS: How to Crush Your Biggest Goals in 2021

  • Adventures in .NET BONUS: How Jason Weimann Became a Game Developer

  • Adventures in .NET Creating Developer Courses with Taurius Litvinavicius - .NET 184

  • Adventures in .NET Extending VS Code and Yourself (Part 2) – .NET 081

  • Adventures in .NET The MaxCoders Guide To Finding Your Dream Developer Job

  • Adventures in .NET Microservices Security in Action with Prabath Siriwardena - .NET 191

  • Adventures in .NET Advocate For Yourself ( Part 2 ) - .NET 088

  • Adventures in .NET .NET 063: Use cases for GraphQL in .NET

  • Adventures in .NET The Power of CSLA Framework in .NET - .NET 168

  • Adventures in .NET Quantum Computing basics with Q# - .NET 174

  • Adventures in .NET Wonders and Woe of Open Source Development - .NET 169

  • Adventures in .NET The Power to Automate - .NET 074

  • Adventures in .NET Community is Key - .NET 193

  • Adventures in .NET .NET 005: Xamarin with James Montemagno

  • Adventures in .NET .NET 015: Live Share and VS Online with Jonathan Carter at MS Ignite

  • Adventures in .NET The Role of Algorithm Implementations and Testing in Development - .NET 181

  • Adventures in .NET Way Outside the Box ( Part 1 ft. Mark Miller) - .NET 101

  • Adventures in .NET .NET 025: C#, NodaTime, versioning, and diversity with Jon Skeet Pt2

  • Adventures in .NET .NET 046: Moving .NET Solutions to Kubernetes with Andrew Lock

  • Adventures in .NET The BIG 100

  • Adventures in .NET .NET 059: Blazor Keeps Getting Better with Daniel Roth

  • Adventures in .NET .NET 030: CodeRushed with Mark Miller Pt2

  • Adventures in .NET All About Language Features - .NET 076

  • Adventures in .NET Open Telemetry and Domain-Driven Refactoring with .NET 6 - .NET 082

  • Adventures in .NET Hacking the C# Language and Other Fun Things - .NET 106

  • Adventures in .NET .NET 041: .NET Microservices: From Code To Containers To Steeltoe with David Dieruf

  • Adventures in .NET Integration Testing - The Why and How - .NET 096

  • Adventures in .NET Minimal APIs Aren’t so Minimal in Power - .NET 114

  • Adventures in .NET Developing your career - .NET 075

  • Adventures in .NET Let's Get Functional - .NET 095

  • Adventures in .NET BFF and Minimals APIs get Darker - .NET 138

  • Adventures in .NET BONUS: Relationships Matter Most

  • Adventures in .NET .NET 053: Abusing C#, Calendars, Epochs and the .NET Functions Framework with Jon Skeet (Part 2)

  • Adventures in .NET Integration Testing - The Why and How - .NET 204

  • Adventures in .NET Blangular (Blazor + Angular) - .NET 105

  • Adventures in .NET .NET 028: Modern Identity: From Internal Directories to Cross-Domain Identity Over the Public Internet with Bobby Johnson

  • Adventures in .NET .NET 052: Abusing C#, Calendars, Epochs and the .NET Functions Framework with Jon Skeet (Part 1)

  • Adventures in .NET Blazor Environment Quirks - .NET 124

  • Adventures in .NET Creating Developer Courses with Taurius Litvinavicius - .NET 203

  • Adventures in .NET .NET 034: What is Command Query Responsibility Segregation (CQRS) with Derek Comartin

  • Adventures in .NET Digging into .NET in AWS - .NET 188

  • Adventures in .NET .NET 016: Adventures in .NET Goes to Microsoft Ignite

  • Adventures in .NET Is Your Code Secure? – .NET 083

  • Adventures in .NET NET Tools and Azure for .NET developers with Tim Heuer - .NET 196

  • Adventures in .NET Learning By Doing - .NET 122

  • Adventures in .NET 3 Fundamental Pillars You Need to Succeed as an Entrepreneur - BONUS

  • Adventures in .NET Extending VS Code and Yourself (Part 1) - .NET 080

  • Adventures in .NET Finding Your Focus - .NET 128

  • Adventures in .NET .NET 027: High performance databases with RavenDB with Oren Eini

  • Adventures in .NET What is an ORM and why do they matter? - .NET 068

  • Adventures in .NET High Performance Databases with RavenDB with Oren Eini - NET 175

  • Adventures in .NET Advocate For Yourself ( Part 1 ) - .NET 087

  • Adventures in .NET BONUS: Continuing Your Learning Journey by Finding Mentors as an Influencer

  • Adventures in .NET Blockchain on Azure - .NET 092

  • Adventures in .NET VS 2022 64-bit - .NET 090

  • Adventures in .NET Innocent Application Performance Monitoring with Innocent Bindura from Raygun - .NET 189

  • Adventures in .NET Blazor Wasm Hosted or Standalone? - .NET 127

  • Adventures in .NET Want To Pair Up? - .NET 089

  • Adventures in .NET Designing C# with Mads Torgersen - .NET 156

  • Adventures in .NET .NET 003: Blazor with Daniel Roth

  • Adventures in .NET How to Get Hired at a FANG Company - BONUS

  • Adventures in .NET .NET 019: The History of .NET with Richard Campbell

  • Adventures in .NET Mastering SignalR - .NET 109

  • Adventures in .NET .NET 033: Working Remotely in the COVID 19 Pandemic

  • Adventures in .NET .NET 042: The Pros of Using Unity with Jason Weimann

  • Adventures in .NET Mastering Dotnet Testing: Using Verify to Minimize Assertions - .NET 192

  • Adventures in .NET Product Management? - .NET 111

  • Adventures in .NET Where is your code? - .NET 119

  • Adventures in .NET Blazor In Action - .NET 131 (Part 2)

  • Adventures in .NET Blazor In Action - .NET 130 (Part 1)

  • Adventures in .NET .NET 009: The Treasures of .NET Core 3.0 with Wade Gausden

  • Adventures in .NET .NET 058: Up in the Cloud with Stu Eggerton

  • Adventures in .NET .NET 044: Creating Developer Courses with Taurius Litvinavicius

  • Adventures in .NET Becoming the Go-To Person in Your Technology Area - BONUS

  • Adventures in .NET The 3 Essentials for Successful Job Outcomes - BONUS

  • Adventures in .NET Career Paths and Job Roles - .NET 077

  • Adventures in .NET Cross-Platform .NET - .NET 135

  • Adventures in .NET Digging into .NET in AWS - .NET 071

  • Adventures in .NET Getting Certified in Azure - .NET 099

  • Adventures in .NET .NET 020: Demos are cool, but it is time to talk about the real world! with Gabriel Baptista

  • Adventures in .NET How To Recession Proof Your Job - BONUS

  • Adventures in .NET Interactive C# with VS Code Notebooks with Eric Potter - .NET 066

  • Adventures in .NET .NET 001:Welcome to Adventures in .NET

  • Adventures in .NET .NET 060: Pursuing Developer Certifications

  • Adventures in .NET .NET 002: Building Extensions with Mads Kristensen

  • Adventures in .NET .NET 004: All About Azure Functions with Colby Tresness

  • Adventures in .NET .NET 008: What Makes a 10x Engineer

  • Adventures in .NET Complexities of Open Source - .NET 126

  • Adventures in .NET .NET 011: SOLID and .NET Predictions with Patrick Smacchia

  • Adventures in .NET .NET 012: F# with Phillip Carter

  • Adventures in .NET Lay off the repository pattern and other controversial opinions - .NET 123

  • Adventures in .NET .NET 014: At MS Ignite with Scott Hunter

  • Adventures in .NET .NET 017: Finding Your Focus

  • Adventures in .NET .NET 018: Fun and Development with Unit Testing, GraphQL and Firebase Auth

  • Adventures in .NET Learning From Your Mistakes (PART 2) - .NET 118

  • Adventures in .NET .NET 032: Containers with Michael Jolley

  • Adventures in .NET The Magic of DAPR with Cecil Phillip - .NET 185

  • Adventures in .NET .NET 035: Performant Applications using the Actor Pattern & Akka.NET with Aaron Stannard

  • Adventures in .NET .NET 038: EFCore 5 and Blazor with Jeremy Likness

  • Adventures in .NET New and Improved OWASP (Part 2) - .NET 098

  • Adventures in .NET .NET 039: Microsoft Orleans with Reuben Bond

  • Adventures in .NET .NET 040: The Magic of DAPR with Cecil Phillip

  • Adventures in .NET .NET 047: Microservices Security in Action with Prabath Siriwardena

  • Adventures in .NET Get Interactive with Jupyter Notebook - .NET 085

  • Adventures in .NET .NET 048: Settle into Couchbase with Matthew Groves

  • Adventures in .NET .NET 054: How do you develop an IDE (JetBrains Rider) with Maarten Balliauw

  • Adventures in .NET Participating in the .NET Community - .NET 136

  • Adventures in .NET .NET 055: Microservices or should they be called Single Responsibility Services with Christian Horsdal

  • Adventures in .NET .NET 057: Open source, MediatR and Automapper with Jimmy Bogard

  • Adventures in .NET .NET 062: Innocent Application Performance Monitoring with Innocent Bindura from Raygun

  • Adventures in .NET .NET 065: So You Want to Go to a Bootcamp

  • Adventures in .NET Product Management? - .NET 205

  • Adventures in .NET .NET 064: To CI/CD or not to CI/CD

  • Adventures in .NET BONUS: Measuring Apps and Entrepreneurship with John-Daniel Trask

  • Adventures in .NET .NET 051: What the Expression Tree in C# with Max Arshinov

  • Adventures in .NET .NET 010: What's new in C# 8.0 with Jason Bock

  • Adventures in .NET The Power in Microsoft Power Platform - .NET 104

  • Adventures in .NET Tools To Get Rid Of Your Code Smells - .NET 137

  • Adventures in .NET BONUS: How to do LARGE Volumes of HIGH Quality Work - While Spending Fewer Hours Working

  • Adventures in .NET Way Outside the Box ( Part 2 ft. Mark Miller) - .NET 102

  • Adventures in .NET Moving .NET Solutions to Kubernetes with Andrew Lock - .NET 199

  • Adventures in .NET WPF Still Going Strong - .NET 134

  • Adventures in .NET Getting into Source Generators in .Net - .NET 103

  • Adventures in .NET Authentication and Authorization - .NET 132

  • Adventures in .NET A Tour Around the World of XAML with Dmitry Lyalin - .NET 190

  • Adventures in .NET Enhancing .NET Development: Visualization Tools and Open Source Contributions - .NET 194

  • Adventures in .NET How Do You Grow? - .NET 197

  • Adventures in .NET Learning Playwright - .NET 129

  • Adventures in .NET Learning From Your Mistakes (PART 1) - .NET 117

  • Adventures in .NET Generating Class Diagrams with code - .NET 125

  • Adventures in .NET All About Language Features - .NET 177

  • Adventures in .NET Mastering SignalR - .NET 176

  • Adventures in .NET The Powerhouse Clipboard Tool - NET 173

  • Adventures in .NET Learning Playwright - NET 171

  • Adventures in .NET Building Bogus with Brian Chavez - NET 170

  • Adventures in .NET Uncovering Advanced .NET Front-end Development: Blazor, Micro Frontends, and AngleSharp - .NET 167

  • Adventures in .NET Making a Wordle clone and more - .NET 121

  • Adventures in .NET Inside .NET Development: Analyzing WinForms, Visual Studio Transition, and C# 12 Features - .NET 166

  • Adventures in .NET .NET 006: Async and C# 8 with Filip Ekberg

  • Adventures in .NET Staying on top of productivity - .NET 133

  • Adventures in .NET .NET 021: Unity Game Development with C# with Jonathan Thompson

  • Adventures in .NET Mastering NoSQL: A Deep Dive into the Evolution and Features of RavenDB - .NET 164

  • Adventures in .NET Pursuing Developer Certifications - .NET 172

  • Adventures in .NET .NET 022: Using DotVVM for migrating WebForms applications to .NET Core with Tomas Herceg

  • Adventures in .NET Azure Cognitive Services Etc - .NET 094

  • Adventures in .NET .NET 024: .NET Tools and Azure for .NET developers with Tim Heuer

  • Adventures in .NET Checking safety in Exactly-once, TLA+ and Stronger message processing - .NET 159

  • Adventures in .NET Get Interactive with Jupyter Notebook - .NET 158

  • Adventures in .NET Refactoring legacy code to use async / await - .NET 120

  • Adventures in .NET Integration Testing - The Why and How - .NET 157

  • Adventures in .NET Designing C# with Mads Torgersen (Part 2) - .NET 113

  • Adventures in .NET .NET 029: CodeRushed with Mark Miller Pt1

  • Adventures in .NET .NET 031: gRPC, Microservices, and Teaching via Pluralsight with Shawn Wildermuth

  • Adventures in .NET Microsoft in Uncharted Territory with Richard Campbell - .NET 155

  • Adventures in .NET Discovering Grace with Scott Arbeit - .NET 154

  • Adventures in .NET C# and .NET for Developing Modern SaaS Applications - .NET 153

  • Adventures in .NET Interconnection of the Messaging Platforms - .NET 152

  • Adventures in .NET API Security Risks with OWASP - .NET 151

  • Adventures in .NET How do you interview? - .NET 115

  • Adventures in .NET .NET 037: Microsoft Build 2020

  • Adventures in .NET Is Using Async and Await a Good Choice? - .NET 150

  • Adventures in .NET BONUS: Continuing Your Learning Journey by Finding Mentors as an Influencer

  • Adventures in .NET Browser Automation with Puppeteer and Playwright - .NET 186

  • Adventures in .NET High-Performance C# with Ian Griffiths - .NET 149

  • Adventures in .NET .NET 050: The S in KISS…..Embracing simplicity with Guilherme Ferreira

  • Adventures in .NET .NET 056: How does HotChocolate and StrawberryShake relate to .NET and GraphQL ?

  • Adventures in .NET Working with Minimal APIs and SignalR - .NET 148

  • Adventures in .NET Creating Pdf's in C# with Andrei Schiller-Chan - .NET 147

  • Adventures in .NET Exception Anti-Patterns in C# with Matt Eland - .NET 146

  • Adventures in .NET Artificial intelligence: What You Need to Know - .NET 145

  • Adventures in .NET Layered API Security with Ted Spence - .NET 143

  • Adventures in .NET Welcoming Our New Adventures in .NET Hosts - .NET 142

  • Adventures in .NET Staying on Top of Productivity - .NET 141

  • Adventures in .NET Monolithic Software with Erik Engheim - .NET 140

  • Adventures in .NET Liquid Templates With Martin Tirion - .NET 139

  • Adventures in .NET What is your Identity? - .NET 069

  • Adventures in .NET BONUS: How Opportunities Come Your Way When You're an Influencer

  • Adventures in .NET You've been Blazored! - .NET 070

  • Adventures in .NET New and Improved OWASP (Part 1 ) - .NET 097

  • Adventures in .NET BONUS: What is Charles Max Wood's Biggest Payoff for Being a Dev Influencer?

  • Adventures in .NET .NET 045: All .NET Stack All The Time

  • Adventures in .NET .NET 049: A web for everyone with Aaron Gustafson

  • Adventures in .NET Designing C# with Mads Torgersen - .NET 112

  • Adventures in .NET .NET Microservices: From Code To Containers To Steeltoe with David Dieruf - .NET 200

  • Adventures in .NET Navigating the Complexity of Migrating from from .NET 4.8 to NET 7 - .NET 161

  • Adventures in .NET The Magic of DAPR with Cecil Phillip - .NET 160

  • Adventures in .NET ASP.NET API Versioning with Chris Martinez - .NET 162

  • Adventures in .NET Uno Platform isn't a Card Game - .NET 072

  • Adventures in .NET Is Your Code Secure?(Part 2) – .NET 084

  • Adventures in .NET Modern Identity: From Internal Directories to Cross-Domain Identity Over the Public Internet with Bobby Johnson - .NET 202

  • Adventures in .NET Building Custom Analyzers and Refactorings Using Roslynator - .NET 163

  • Adventures in .NET To CI/CD or not to CI/CD - .NET 180

  • Adventures in .NET Voice to Code inside Visual Studio - .NET 179

  • Adventures in .NET .NET 013: Simmy and Chaos Engineering Geovanny Alzate Sandoval

  • Adventures in .NET .NET 026: A Tour Around the World of XAML with Dmitry Lyalin

Footer

Top End Devs

Facebook Instagram Twitter GitHub YouTube

Content & Events

  • Authors, Hosts, & Guests
  • Commerce
  • Insights

Support

  • Pricing
  • Documentation
  • Guides
  • API Status

Company

  • About
  • Blog
  • Jobs
  • Press
  • Partners

Legal

  • Claim
  • Privacy
  • Terms

© 2023 Intentional Excellence Productions, LLC. All rights reserved.