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

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...

Full description

Bibliographic Details
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
Description
Summary: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 ...