valuesRepository.cs

public async Task Insert(Value value)
{
    using (SqlConnection sql = new SqlConnection(_connectionString))
    {
        using (SqlCommand cmd = new SqlCommand("InsertValue", sql))
        {
            cmd.CommandType = System.Data.CommandType.StoredProcedure;
            cmd.Parameters.Add(new SqlParameter("@value1", value.Value1));
            cmd.Parameters.Add(new SqlParameter("@value2", value.Value2));
            await sql.OpenAsync();
            await cmd.ExecuteNonQueryAsync();
            return;
        }
    }
}