Research on technologies for accessing relational databases using MS SQL Server

Abstract

In the modern world, hundreds of large projects are developed every day, and thousands of startups with a wide variety of topics appear, developers start creating their projects, companies modernize old projects. Each of these activities has something in common - the way they store and manipulate data. Almost all modern projects have a database, because it becomes simply impossible to interact with the client without it. Now, no matter what your application, service, game or anything else is, it is necessary for the user to be able to have his account page, save progress, anything that needs to be saved locally or in the cloud or on the server. And a modern developer can use the database directly or through special database access technologies, including through ORM or Micro ORM. The subject is the study of access technologies for working with relational databases. The goal is to compare the efficiency, flexibility and use of various access technologies when working with the MS SQL SERVER database. Task: to investigate access technologies to MS SQL SERVER. Collect the technical characteristics of queries when using different database access technologies. Compare the results. Methods: analysis of MS SQL SERVER access technologies, experimental research, statistical analysis of results. Results: it is shown how access technologies such as ORM Entity Framework, Micro ORM Dapper and ADO.NET differ in use, it is shown that the performance is most effective in ADO.NET, followed by Dapper and in third place among the access technologies used in terms of efficiency is Entity Framework . But it is shown how the type of request contributes to the efficiency of execution by various technologies. Conclusions: ORMs are used in cases where it is necessary to work with a database using an object-oriented approach. ORM transforms data from the database into objects in the application, which facilitates interaction with the database and reduces the amount of code that must be written to work with the database. Micro ORMs are used when the speed of execution of requests to the database is required, or if the project is small in scope and does not need the full functionality of ORM. Micro ORM is smaller, faster and easier to use than ORM. ADO.NET is recommended when direct interaction with databases is needed.. ADO.NET allows you to create multithreaded and distributed applications, interact with databases using transactions, and manage data security. It is more extensible and scalable than ORM and Micro ORM, but requires more code to interact with the database.