Using SProcs in repositories

gistfile1.cs

//private method to use SProc
private void WithStoredProcedure(string storedProcedureName, Action<SqlCommand> commandAction) 
{ 
    using (var connection = OpenConnection()) 
    using (var command = connection.Connection.CreateCommand()) 
    { 
        command.CommandText = storedProcedureName; 
        command.CommandType = CommandType.StoredProcedure; 
        commandAction(command); 
    } 
} 


//Usage example
public void MarkAsDispatched(string messageId) 
{ 
    WithStoredProcedure("MarkAsDispatched", command => 
    { 
        command.Parameters.AddWithValue("@messageId", messageId); 
        command.ExecuteNonQuery(); 
    }); 
} 

//another example
public IList<MessageData> GetUndispatchedMessages() 
{ 
    var undispatchedMessages = new List<MessageData>(); 

    WithStoredProcedure("GetUndispatchedSlice", 
                        command => 
                        { 
                            //probably should be another method that receives IReader
                            using (var reader = command.ExecuteReader()) 
                            { 
                                while (reader.Read()) 
                                { 
                                    var messageData = new MessageData( 
                                        reader.GetString(0), 
                                        reader.GetString(1), 
                                        reader.GetSqlBinary(2).Value, 
                                        reader.GetSqlBinary(3).Value); 

                                    undispatchedMessages.Add(messageData); 
                                } 
                            } 
                        }); 

    return undispatchedMessages; 
}