Model design for code generation for C# and SQL Server
DOI:
https://doi.org/10.15381/rpcs.v4i2.24852Keywords:
Software Engineering, CASE Tools, Time Optimization, CASE Technology, Source code generationAbstract
Currently there are tools that generate source code automatically. We propose a source code generation architecture focused on the 3-layer architecture, additionally we build a source code generation tool. The Tool allows to load a database schema and from this it generates the source code for the SQL Server and C# language, we use an .xls file to import or export the database schema. We have used 5 code generation requirements and their database schemas for the test, obtaining as a result the generation of source code without errors. Carrying out the time analysis, our model generates 6,998 lines of code per second, in total we have generated 13,283 lines of source code in 1472 milliseconds that correspond to 5 requirements for generating source code with their respective databases.
Downloads
Published
Issue
Section
License
Copyright (c) 2022 Juan M. Rojas Torres, Hugo D. Calderon-Vilca
![Creative Commons License](http://i.creativecommons.org/l/by/4.0/88x31.png)
This work is licensed under a Creative Commons Attribution 4.0 International License.
THE AUTHORS RETAIN THEIR RIGHTS:
(a) The authors retain their trademark and patent rights, and also over any process or procedure described in the article.
(b) The authors retain the right to share, copy, distribute, execute and publicly communicate the article published in the Revista Peruana de Computación y Sistemas (for example, place it in an institutional repository or publish it in a book), with acknowledgment of its initial publication in Revista Peruana de Computación y Sistemas.
(c) Authors retain the right to make a subsequent publication of their work, to use the article or any part of it (for example: a compilation of their work, lecture notes, thesis, or for a book), provided that they indicate the source. of publication (authors of the work, magazine, volume, number and date).