LINQ to SQL Pipeline Video with Luca Bolognese and Matt Warren

C# Principal Architect Matt Warren and Lead PM Luca Bolognese detail the pipeline that hastens your LINQ queries to execution. Matt did most of the design and implementation of this code. His explanations are vivid and useful. The drawings are well organized, well executed, and clearly explained. Matt and Luca have worked together for years, and they make an excellent team.

You can see the 40 minute video by clicking on the Soapbox graphic shown in Figure 1. There are also two downloadable versions of this video. The smaller one is roughly equivalent in quality to the embedded Soapbox video found in this blog, the other is of much higher quality, but also much larger. Both versions of the video are in WMV format and are stored in zip files.


Figure 1: Video: LINQ Pipeline


Topics covered in the video:

  • A step by step in depth explanation of the LINQ Pipeline that transforms a LINQ query into SQL and returns a result to the user.
  • A detailed explanation of updates and calls to SubmitChanges() including discussions of:
    • Transactions 
    • Injecting stored procedures into the update pipeline.
  • A discussion of the history of LINQ and its roots. Matt and Luca talk about the many years of hard work necessary to bring LINQ to fruition, and the roles that such luminaries as Erik Meijer and Anders Hejlsberg had in that process. Both Luca and Matt have been with LINQ since its inception. They know the whole story, and no one could possibly be better poised to explain it than these two who had so much to do with its creation and implementation.

kick it on

Comments (16)

  1. You’ve been kicked (a good thing) – Trackback from

  2. Charlie Calvert published a video where Matt Warren (C# Principal Architect) & Luca Bolognese (Lead

  3. Charlie Calvert published a video where Matt Warren (C# Principal Architect) & Luca Bolognese (Lead

  4. If you are interested in the history of LINQ to SQL and how it works internally, go watch Charlie Calvert's

  5. Brent says:

    Great information, but the camera motion started making me feel ill…

  6. Adrian Johnery says:

    Very good discussion.  On the side, I would suggest he buys JFM for the hair.

  7. LINQ to SQL Pipeline Video with Luca Bolognese and Matt Warren De manière plus générale, le blog à retenir

  8. As LINQ nears release, people are starting to consider the performance implications that the extra overhead…

  9. dskcheck says:


    Help me to understand as why i should use LINQ when compared to the traditional mechanism including DataAdapter, Connection, DataReader blah.. blah..

    I recently realised that LINQ implementation is consuming double the time consumed by the traditional methods. So when i look at the performence, it is really going to be a bottleneck for my application.

    Having said that, am at no clue as why i should use LINQ. Please help to understand the power of LINQ and the possitive points of LINQ

    Thanks for reading my request.

  10. JD Conley says:

    This is very interesting. It helped me understand why I had some performance issues with a query of mine:

  11. Azhar says:

    Great video, its funny, its knowledge booster, its in detail, indeed its a kind of presentation that have to be followed in future.

  12. Azhar says:

    Hey guys (Luca Matt), its really a impressive video, but please give me some details with respect to the advantages of LINQ. When you have developed it, it definately gonna have some advantages. Look, I am a developer, but when I insisted in our team to use LINQ, they dont agreed. It really affecting the performance in great deal. Please clearify… Waiting for the reply (Despirate to know infact).

  13. ilves says:

    Great Video.I want more videos like this.Thanks a lot.

  14. Isaac says:

    Linq over DataReader – so much easier to use! You can access your data in a typesafe manner, access your data in the same way that you work with collections of objects, no more memory intensive and slow datatables but "proper" classes – can use inheritance.

  15. It’s a bit rainy and snowy today in Redmond. What an excellent time to curl up by the fire and watch