{"id":2301,"date":"2023-06-17T16:46:57","date_gmt":"2023-06-17T09:46:57","guid":{"rendered":"https:\/\/csharptutorial.net\/?page_id=2301"},"modified":"2023-06-17T16:47:39","modified_gmt":"2023-06-17T09:47:39","slug":"executesqlraw","status":"publish","type":"page","link":"https:\/\/www.csharptutorial.net\/entity-framework-core-tutorial\/executesqlraw\/","title":{"rendered":"ExecuteSQLRaw()"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to use the EF Core <code>ExecuteSQLRaw()<\/code> method to execute a raw SQL statement.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction to the EF Core ExecuteSQLRaw() method<\/h2>\n\n\n\n<p>The <code>ExecuteSQLRaw()<\/code> method allows you to execute a raw SQL and return the number of rows affected. It is useful when you want to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Execute a <code><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/sql-server-delete\/\" target=\"_blank\" rel=\"noreferrer noopener\">DELETE<\/a><\/code> statement and return the number of rows deleted.<\/li>\n\n\n\n<li>Execute an <code><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/sql-server-update\/\" target=\"_blank\" rel=\"noreferrer noopener\">UPDATE<\/a><\/code> statement and return the number of rows updated.<\/li>\n\n\n\n<li><a href=\"https:\/\/csharptutorial.net\/entity-framework-core-tutorial\/ef-core-stored-procedure\/\">Execute a stored procedure<\/a> and return the row affected.<\/li>\n<\/ul>\n\n\n\n<p>Note that the <code>ExecuteSQLRaw()<\/code> method doesn&#8217;t start a transaction. To start a transaction, you need to use <code>UseTransaction<\/code> or call <code>BeginTransaction()<\/code> first.<\/p>\n\n\n\n<p>To avoid SQL injection, you should never concatenate or interpolate ($&#8221;&#8221;) the query with non-validated user-provided values to the <code>ExecuteSQLRaw()<\/code> method.<\/p>\n\n\n\n<p>Instead, you can include parameter placeholders in the SQL query string and then provide parameters as additional arguments. For example:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"C#\" data-shcb-language-slug=\"cs\"><span><code class=\"hljs language-cs\"><span class=\"hljs-keyword\">var<\/span> id = <span class=\"hljs-number\">1<\/span>;\ncontext.Database.ExecuteSqlRaw(<span class=\"hljs-string\">\"DELETE FROM table WHERE Id={0}\"<\/span>,id);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">C#<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">cs<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>The <code>ExecuteSQLRaw()<\/code> method will automatically convert the parameters to <code>DbParamter<\/code> objects.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">EF Core ExecuteSQLRaw() method examples<\/h2>\n\n\n\n<p>We&#8217;ll use the <a href=\"https:\/\/csharptutorial.net\/entity-framework-core-tutorial\/ef-core-sample-project\/\">EF Core Sample project<\/a> for the demonstration. The following shows the <code>Employees<\/code> and <code>Departments<\/code> tables:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/csharptutorial.net\/wp-content\/uploads\/2023\/06\/EF-Core-Departments-and-Emloyees-Tables.png\" alt=\"\" class=\"wp-image-2218\" width=\"439\" height=\"181\" srcset=\"https:\/\/www.csharptutorial.net\/wp-content\/uploads\/2023\/06\/EF-Core-Departments-and-Emloyees-Tables.png 585w, https:\/\/www.csharptutorial.net\/wp-content\/uploads\/2023\/06\/EF-Core-Departments-and-Emloyees-Tables-300x124.png 300w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">1) Using the ExecuteSQLRaw() to execute a DELETE statement<\/h3>\n\n\n\n<p>The following example uses the <code>ExecuteSQLRaw()<\/code> method to delete an employee with id 1:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"C#\" data-shcb-language-slug=\"cs\"><span><code class=\"hljs language-cs\"><span class=\"hljs-keyword\">using<\/span> HR;\n<span class=\"hljs-keyword\">using<\/span> <span class=\"hljs-keyword\">static<\/span> System.Console;\n<span class=\"hljs-keyword\">using<\/span> Microsoft.EntityFrameworkCore;\n\n<span class=\"hljs-keyword\">using<\/span> <span class=\"hljs-keyword\">var<\/span> context = <span class=\"hljs-keyword\">new<\/span> HRContext();\n\n<span class=\"hljs-keyword\">var<\/span> sql = <span class=\"hljs-string\">@\"DELETE FROM employees WHERE id={0}\"<\/span>;\n<span class=\"hljs-keyword\">var<\/span> employeeId = <span class=\"hljs-number\">1<\/span>;\n\n<span class=\"hljs-keyword\">var<\/span> rowCount = context.Database.ExecuteSqlRaw(sql, employeeId);\nWriteLine(<span class=\"hljs-string\">$\"The number of row deleted <span class=\"hljs-subst\">{rowCount}<\/span>\"<\/span>);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">C#<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">cs<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"C#\" data-shcb-language-slug=\"cs\"><span><code class=\"hljs language-cs\">The number of row deleted <span class=\"hljs-number\">1<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">C#<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">cs<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Behind the scenes, EF Core parameterized the query and execute it as shown in the following log:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"C#\" data-shcb-language-slug=\"cs\"><span><code class=\"hljs language-cs\">-- &#91;Parameters=&#91;@p0=<span class=\"hljs-string\">'1'<\/span>], CommandType=<span class=\"hljs-string\">'Text'<\/span>, CommandTimeout=<span class=\"hljs-string\">'30'<\/span>]\nDELETE FROM employees WHERE id=@p0<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">C#<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">cs<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>The log shows that EF Core converted the id value into a <code>DbParameter<\/code> object.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2) Using the ExecuteSQLRaw() to execute an UPDATE statement<\/h3>\n\n\n\n<p>The following example illustrates how to use the  <code>ExecuteSQLRaw()<\/code> method to execute an <code>UPDATE<\/code> statement that increases the salary to 5% of the employee id 2:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"C#\" data-shcb-language-slug=\"cs\"><span><code class=\"hljs language-cs\"><span class=\"hljs-keyword\">using<\/span> HR;\n<span class=\"hljs-keyword\">using<\/span> <span class=\"hljs-keyword\">static<\/span> System.Console;\n<span class=\"hljs-keyword\">using<\/span> Microsoft.EntityFrameworkCore;\n\n<span class=\"hljs-keyword\">using<\/span> <span class=\"hljs-keyword\">var<\/span> context = <span class=\"hljs-keyword\">new<\/span> HRContext();\n\n<span class=\"hljs-keyword\">var<\/span> sql = <span class=\"hljs-string\">@\"UPDATE employees SET Salary=Salary*1.05 WHERE id={0}\"<\/span>;\n<span class=\"hljs-keyword\">var<\/span> employeeId = <span class=\"hljs-number\">2<\/span>;\n\n<span class=\"hljs-keyword\">var<\/span> rowCount = context.Database.ExecuteSqlRaw(sql, employeeId);\nWriteLine(<span class=\"hljs-string\">$\"The number of row updated <span class=\"hljs-subst\">{rowCount}<\/span>\"<\/span>);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">C#<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">cs<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"C#\" data-shcb-language-slug=\"cs\"><span><code class=\"hljs language-cs\">The number of row updated <span class=\"hljs-number\">1<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">C#<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">cs<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>EF Core sent the following <code>UPDATE<\/code> statement to the database for execution:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"C#\" data-shcb-language-slug=\"cs\"><span><code class=\"hljs language-cs\">-- prameters=&#91;@p0=<span class=\"hljs-string\">'2'<\/span>], CommandType=<span class=\"hljs-string\">'Text'<\/span>, CommandTimeout=<span class=\"hljs-string\">'30'<\/span>]\nUPDATE employees SET Salary=Salary*<span class=\"hljs-number\">1.05<\/span> WHERE id=@p0<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">C#<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">cs<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\">3) Using the ExecuteSQLRaw() to execute a stored procedure<\/h2>\n\n\n\n<p>First, <a href=\"https:\/\/csharptutorial.net\/entity-framework-core-tutorial\/ef-core-migrations\/\">add a new migration<\/a> to create a stored procedure:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"C#\" data-shcb-language-slug=\"cs\"><span><code class=\"hljs language-cs\"><span class=\"hljs-keyword\">add<\/span>-migration CreateDeleteDepartmentSP<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">C#<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">cs<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Second, modify the class <code>CreateDeleteDepartmentSP<\/code> in the Migrations directory to <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-stored-procedures\/\" target=\"_blank\" rel=\"noreferrer noopener\">create a stored procedure<\/a> that deletes a department by id in the <code>Up()<\/code> method and drops the stored procedure in the <code>Down()<\/code> method:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"C#\" data-shcb-language-slug=\"cs\"><span><code class=\"hljs language-cs\"><span class=\"hljs-keyword\">using<\/span> Microsoft.EntityFrameworkCore.Migrations;\n\n<span class=\"hljs-meta\">#nullable disable<\/span>\n\n<span class=\"hljs-keyword\">namespace<\/span> <span class=\"hljs-title\">HR.Migrations<\/span>;\n\n<span class=\"hljs-comment\"><span class=\"hljs-doctag\">\/\/\/<\/span> <span class=\"hljs-doctag\">&lt;inheritdoc \/&gt;<\/span><\/span>\n<span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-keyword\">partial<\/span> <span class=\"hljs-keyword\">class<\/span> <span class=\"hljs-title\">CreateDeleteDepartmentSP<\/span> : <span class=\"hljs-title\">Migration<\/span>\n{\n    <span class=\"hljs-comment\"><span class=\"hljs-doctag\">\/\/\/<\/span> <span class=\"hljs-doctag\">&lt;inheritdoc \/&gt;<\/span><\/span>\n    <span class=\"hljs-function\"><span class=\"hljs-keyword\">protected<\/span> <span class=\"hljs-keyword\">override<\/span> <span class=\"hljs-keyword\">void<\/span> <span class=\"hljs-title\">Up<\/span>(<span class=\"hljs-params\">MigrationBuilder migrationBuilder<\/span>)<\/span>\n    {\n        <span class=\"hljs-keyword\">var<\/span> command = <span class=\"hljs-string\">@\"CREATE PROCEDURE DeleteDepartment(@Id AS INT)\n                            AS\n                            BEGIN\n                                DELETE FROM Departments\n                                WHERE Id=@Id;\n                            END\"<\/span>;\n        migrationBuilder.Sql(command);\n    }\n\n    <span class=\"hljs-comment\"><span class=\"hljs-doctag\">\/\/\/<\/span> <span class=\"hljs-doctag\">&lt;inheritdoc \/&gt;<\/span><\/span>\n    <span class=\"hljs-function\"><span class=\"hljs-keyword\">protected<\/span> <span class=\"hljs-keyword\">override<\/span> <span class=\"hljs-keyword\">void<\/span> <span class=\"hljs-title\">Down<\/span>(<span class=\"hljs-params\">MigrationBuilder migrationBuilder<\/span>)<\/span>\n    {\n        <span class=\"hljs-keyword\">var<\/span> command = <span class=\"hljs-string\">@\"DROP PROCEDURE DeleteDepartment;\"<\/span>;\n        migrationBuilder.Sql(command);\n    }\n}<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">C#<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">cs<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Third, create the stored procedure by running the <code>Update-Database<\/code> command in the Package Manager Console:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"C#\" data-shcb-language-slug=\"cs\"><span><code class=\"hljs language-cs\">Update-Database<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">C#<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">cs<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Finally, execute the stored procedure to delete the department with id 1:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-11\" data-shcb-language-name=\"C#\" data-shcb-language-slug=\"cs\"><span><code class=\"hljs language-cs\"><span class=\"hljs-keyword\">using<\/span> HR;\n<span class=\"hljs-keyword\">using<\/span> <span class=\"hljs-keyword\">static<\/span> System.Console;\n<span class=\"hljs-keyword\">using<\/span> Microsoft.EntityFrameworkCore;\n\n<span class=\"hljs-keyword\">using<\/span> <span class=\"hljs-keyword\">var<\/span> context = <span class=\"hljs-keyword\">new<\/span> HRContext();\n\n<span class=\"hljs-keyword\">var<\/span> sql = <span class=\"hljs-string\">@\"EXECUTE DeleteDepartment {0}\"<\/span>;\n<span class=\"hljs-keyword\">var<\/span> departmentId = <span class=\"hljs-number\">1<\/span>;\n\n<span class=\"hljs-keyword\">var<\/span> rowCount = context.Database.ExecuteSqlRaw(sql, departmentId);\nWriteLine(<span class=\"hljs-string\">$\"The number of row deleted <span class=\"hljs-subst\">{rowCount}<\/span>\"<\/span>);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-11\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">C#<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">cs<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-12\" data-shcb-language-name=\"C#\" data-shcb-language-slug=\"cs\"><span><code class=\"hljs language-cs\">The number of row deleted <span class=\"hljs-number\">1<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-12\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">C#<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">cs<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>EF Core sent the SQL statement to the database to execute the stored procedure:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-13\" data-shcb-language-name=\"C#\" data-shcb-language-slug=\"cs\"><span><code class=\"hljs language-cs\">-- &#91;Parameters=&#91;@p0=<span class=\"hljs-string\">'1'<\/span>], CommandType=<span class=\"hljs-string\">'Text'<\/span>, CommandTimeout=<span class=\"hljs-string\">'30'<\/span>]\nEXECUTE DeleteDepartment @p0<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-13\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">C#<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">cs<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\">Summary<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use the <code>ExecuteSQLRaw()<\/code> method to execute a raw SQL and return the number of rows affected.<\/li>\n<\/ul>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful ?<\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"2301\"\n\t\t\t\tdata-post-url=\"https:\/\/www.csharptutorial.net\/entity-framework-core-tutorial\/executesqlraw\/\"\n\t\t\t\tdata-post-title=\"ExecuteSQLRaw()\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"2301\"\n\t\t\t\tdata-post-url=\"https:\/\/www.csharptutorial.net\/entity-framework-core-tutorial\/executesqlraw\/\"\n\t\t\t\tdata-post-title=\"ExecuteSQLRaw()\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, you will learn how to use the EF Core ExecuteSQLRaw() method to execute a raw SQL statement.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1970,"menu_order":21,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2301","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.csharptutorial.net\/wp-json\/wp\/v2\/pages\/2301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.csharptutorial.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.csharptutorial.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.csharptutorial.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.csharptutorial.net\/wp-json\/wp\/v2\/comments?post=2301"}],"version-history":[{"count":2,"href":"https:\/\/www.csharptutorial.net\/wp-json\/wp\/v2\/pages\/2301\/revisions"}],"predecessor-version":[{"id":2303,"href":"https:\/\/www.csharptutorial.net\/wp-json\/wp\/v2\/pages\/2301\/revisions\/2303"}],"up":[{"embeddable":true,"href":"https:\/\/www.csharptutorial.net\/wp-json\/wp\/v2\/pages\/1970"}],"wp:attachment":[{"href":"https:\/\/www.csharptutorial.net\/wp-json\/wp\/v2\/media?parent=2301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}