Using Entity Framework Core for Data Access & Relational Mapping/

...

/

Raw SQL Queries and Split Queries

Raw SQL Queries and Split Queries

Learn the basics of using raw SQL queries and split queries to improve query operations.

We'll cover the following...

Overview

In this lesson, we’ll review the following topics:

  • Raw SQL queries
  • Split queries

Note: The outputs from the projects in this lesson contain the results of sample codes and logs of the translated SQL queries used.

Raw SQL queries

Raw SQL queries provide a powerful medium to interact with relational databases. They are beneficial when we cannot express the desired query with LINQ.

We’ll demonstrate them using the C# console project below:

{
    "version": "0.2.0",
    "configurations": [
        {
            // Use IntelliSense to find out which attributes exist for C# debugging
            // Use hover for the description of the existing attributes
            // For further information visit https://github.com/OmniSharp/omnisharp-vscode/blob/master/debugger-launchjson.md
            "name": ".NET Core Launch (console)",
            "type": "coreclr",
            "request": "launch",
            "preLaunchTask": "build",
            // If you have changed target frameworks, make sure to update the program path.
            "program": "${workspaceFolder}/bin/Debug/net6.0/QueryData.dll",
            "args": [],
            "cwd": "${workspaceFolder}",
            // For more information about the 'console' field, see https://aka.ms/VSCode-CS-LaunchJson-Console
            "console": "internalConsole",
            "stopAtEntry": false
        },
        {
            "name": ".NET Core Attach",
            "type": "coreclr",
            "request": "attach"
        }
    ]
}
Demonstrating raw SQL queries
...
Access this course and 1400+ top-rated courses and projects.