title: EF Core 3.0 Stored Procedure : Multiple Parameters
body: <p>I have gone through this question <a href="https://stackoverflow.com/questions/58207182/how-to-call-a-stored-procedure-in-ef-core-3-0-via-fromsqlraw">How to call a stored procedure in EF Core 3.0 via FromSqlRaw</a>. But this is not solving my problem. I am working with a <strong>MySql Database</strong>. In my database there is a stored procedure in which I am inserting some data and then returning this whole table.</p>
  
  <p>My stored procedure code is something like:</p>
  
  <pre><code>DELIMITER $$
      Create Procedure InsertDepartments(DName longtext,DLoc longtext)
  BEGIN
      INSERT INTO Departments (DepartmentName, DepartmentLocation) 
      VALUES (Dname, DLoc);
      SELECT * FROM Departments ORDER By Departments.DepartmentId DESC;
  END$$
  </code></pre>
  
  <p>As you can see I am trying to take two parameters DName and DLoc. Now in my controller in backend I have tried with something :</p>
  
  <pre><code>public JsonResult InsertDepartment([FromBody]Department department)
  {
       try
       {
          var deptName = new MySqlParameter("Dname", department.DepartmentName);
          var deptLoc = new MySqlParameter("DLoc", department.DepartmentLocation);
  
          var departments = _context
            .Departments
            .FromSqlRaw("EXECUTE InsertDepartments @Dname , @DLoc", new object[] {deptName, deptLoc})
            .ToList();
       return Json(departments);
      }
      catch (Exception e)
      {
         return Json(e.Message);
      }
  }
  </code></pre>
  
  <p>But this is failing somehow. The error log returned in PostMan is:</p>
  
  <pre><code>"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''CSE' , 'DT5'' at line 1"
  </code></pre>
  
  <p>Error Log:</p>
  
  <pre><code>System.NotSupportedException: Specified method is not supported.
     at System.Text.Json.JsonSerializer.WriteDictionary[TProperty](JsonConverter`1 converter, JsonSerializerOptions options, WriteStackFrame&amp; current, Utf8JsonWriter writer)
     at System.Text.Json.JsonPropertyInfoNotNullable`4.OnWriteDictionary(WriteStackFrame&amp; current, Utf8JsonWriter writer)
     at System.Text.Json.JsonPropertyInfo.WriteDictionary(WriteStack&amp; state, Utf8JsonWriter writer)
     at System.Text.Json.JsonSerializer.HandleDictionary(JsonClassInfo elementClassInfo, JsonSerializerOptions options, Utf8JsonWriter writer, WriteStack&amp; state)
     at System.Text.Json.JsonSerializer.HandleObject(JsonPropertyInfo jsonPropertyInfo, JsonSerializerOptions options, Utf8JsonWriter writer, WriteStack&amp; state)
     at System.Text.Json.JsonSerializer.WriteObject(JsonSerializerOptions options, Utf8JsonWriter writer, WriteStack&amp; state)
     at System.Text.Json.JsonSerializer.Write(Utf8JsonWriter writer, Int32 originalWriterDepth, Int32 flushThreshold, JsonSerializerOptions options, WriteStack&amp; state)
     at System.Text.Json.JsonSerializer.WriteAsyncCore(Stream utf8Json, Object value, Type inputType, JsonSerializerOptions options, CancellationToken cancellationToken)
     at Microsoft.AspNetCore.Mvc.Infrastructure.SystemTextJsonResultExecutor.ExecuteAsync(ActionContext context, JsonResult result)
     at Microsoft.AspNetCore.Mvc.Infrastructure.SystemTextJsonResultExecutor.ExecuteAsync(ActionContext context, JsonResult result)
     at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.&lt;InvokeResultFilters&gt;g__Awaited|27_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
     at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.&lt;InvokeFilterPipelineAsync&gt;g__Awaited|19_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
     at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.&lt;InvokeAsync&gt;g__Logged|17_1(ResourceInvoker invoker)
     at Microsoft.AspNetCore.Routing.EndpointMiddleware.&lt;Invoke&gt;g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
     at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
     at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)
  </code></pre>
  
  <p><strong>How can I solve this problem?</strong></p>