In this paper, we are interested in the material selection process as one of the essential steps in the design of products or projects. This task is very complex due to the multitude and heterogeneity of criteria involved and the specificities of each project. The selection process can be very time consuming, especially if it is a repetitive operation. This type of process also requires the use of all the knowledge already available to guarantee the reliability of the decisions. This article proposes a methodology for selecting equipment and material based on an automated model that integrates Multiple-Criteria Decision Analysis (MCDA) methods and knowledge management principles. This model is particularly relevant in situations where the selection process is repetitive but should be reviewed according to the specific conditions of each case. Using this model will allow decision-makers to save time and benefit from the knowledge created during selection processes. A practical application to water pipe material selection is proposed to illustrate practical contribution of the model. It is also applicable to other cases where the selection process is repetitive and depends each time on specific conditions.