Comparison of C# and Python programming languages in terms of performance and coding on SQL server DML operations ...

• Main Author: Ataturk University
• Format: Article in Journal/Newspaper
• Language: unknown
• Published: Ataturk University 2024
• Subjects: DML
• Online Access: https://dx.doi.org/10.5281/zenodo.12547651; https://zenodo.org/doi/10.5281/zenodo.12547651

Nowadays, there are several computer programming languages and database management systems, and they have advantages and disadvantages one over another. Databases are essential components of computer programs, regardless of their language. Thanks to databases, computer programs record the data that they need or produce and perform the given tasks by retrieving these data when necessary. For a computer program to run efficiently and quickly, it is essential that both the database and the computer program are well structured. In this study, C# and Python languages, which are among the most widely used programming languages out of these various programming languages, have been evaluated in terms of transaction performance and the amount of code that needs to be written to perform SQL DML (Data Manipulation Language) operations such as INSERT, SELECT, UPDATE, DELETE operations and print the results of the operation on the screen via MSSQL database,1 which is one of the most widely used database management ...