Optimization of Code Lines and Time of Access to Information through Object-Relational Mapping (ORM) Using Alternative Tools of Connection to Database Management Systems (DBMS)

The present article presents a comparison between technologies used in the development of C# language systems for access to information in database management systems. The method used has been the classic for the input of information with some steps of data persistence to perform the modeling of information with the use of objects. The mapping scheme is directly related to the object schema and to the relational schema. This method of relational object mapping provides a reduction in the times within the development of applications and the abstraction of the database, through the reuse of the code and safe processes that have been obtained thanks to the own language of the tools of mapping. It is concluded after a thorough study of the two techniques that with relational object mapping the response time is optimized in relation of 10 to 1, in addition, the number of lines of code used to implement a system developed with a mapper is significantly smaller, reasons why it has become very popular the use of alternative tools like the one studied.