Stored procedure output parameter value is null (entity framework)

Question

I am trying to call a stored procedure from entity framework but I am unable to get the output parameter value. It is always returning null. Here is my code

object[] parameters = {
    new SqlParameter("@Date", date),
    new SqlParameter("@outDate", SqlDbType.Date) {Direction= ParameterDirection.Output}
};
int defval = context.Database.CommandTimeout.Value;
context.Database.CommandTimeout = 1800;
context.Database.ExecuteSqlCommand("dbo.TestDateFormatAndRegion @Date, @outDate", parameters);
var NoOfSyncOperationsDeleted = parameters[1].ToString();

Can you please help.

Thanks

Answer 1

// Define the parameters array with input and output parameters
var parameters = new[]
{
    new SqlParameter("@Date", SqlDbType.Date) { Value = date },
    new SqlParameter("@outDate", SqlDbType.Date) { Direction = ParameterDirection.Output }
};

// Execute the stored procedure using ExecuteSqlCommand
context.Database.ExecuteSqlCommand("EXEC dbo.TestDateFormatAndRegion @Date, @outDate OUT", parameters);

// Retrieve the output parameter value after executing the stored procedure
var outDateValue = parameters[1].Value;


// Check if the output parameter value is not null before converting it to string
var NoOfSyncOperationsDeleted = outDateValue != DBNull.Value ? outDateValue.ToString() : "NULL";

// Restore the original command timeout if needed
context.Database.CommandTimeout = defval;

try this one