I m calling a stored procedure using the following code:
dbContext.Database.ExecuteSqlRaw(sqlCommand.ToString());
I have the following Stored Procedure:
CREATE DEFINER=`user11`@`%` PROCEDURE `UpdateDimDateEntity`(IN DimDateKey INT,
IN FullDate DATE,
IN DayName NVARCHAR(50),
IN DayOfWeek SMALLINT)
BEGIN
UPDATE DimDate
SET
FullDate = FullDate,
DayName = DayName,
DayOfWeek = DayOfWeek
WHERE DimDate.DimDateKey = DimDateKey;
END
The return type of ExecuteSqlRaw is int (4 bytes) and I read at this article that MariaDb ColumnStore accepts definition of stored procedures with only input arguments and a single SELECT query does not return anything and that I suspect that it does not return anything the method expects a 4 byte message it does not receive it and it fails.
How can I call a SP from C# without waiting for number of affected rows?