Getting the Generated SQL

Explore how to output and examine the SQL statements generated by Entity Framework Core from your C# queries. This lesson helps you understand the translation of LINQ queries to SQL, including parameter usage and syntax differences between databases, enabling you to write more efficient data access code.

We'll cover the following...

Analyzing generated SQL queries
Try it yourself

1.Introduction

2.Hello, C#! Welcome, .NET!

3.Speaking C#

4.Controlling Flow, Converting Types, and Handling Exception

5.Writing, Debugging, and Testing Functions

6.Building Your Own Types with Object-Oriented Programming

7.Implementing Interfaces and Inheriting Classes

8.Packaging and Distributing .NET Types

9.Working with Common .NET Types

10.Working with Files, Streams, and Serialization

11.Working with Data Using Entity Framework Core

12.Querying and Manipulating Data Using LINQ

13.Introducing Web Development Using ASP.NET Core

14.Building Websites Using ASP.NET Core Razor Pages

15.Building Websites Using the Model-View-Controller Pattern

16.Building and Consuming Web Services

17.Building User Interfaces Using Blazor

18.Conclusion

Getting the Generated SQL

Analyzing generated SQL queries