Comparison of LINQ and ADO.NET database accessing mechanisms on the ground of Web application built in a spiral model
Michał Świderski, Piotr Bugla · 2013
LINQ technology is one of the representatives of the object-relational mapping. Article proposes the thesis that this technology reduces the number of errors in the access to the database and facilitates the creation of software. The study attempted to prove the validity of this thesis by comparing the data access technologies LINQ and ADO.NET on the ground of a Web application. The aim of this study was to write two applications using both approaches, what helped to state the validity of the thesis. The conclusions of the study confirm that the LINQ technology increases the efficiency of writing code. Also interaction with the database using the programming language itself, reduces the number of errors in the access to the database. Work has also shown the only disadvantage of LINQ, which is being less efficient than ADO.NET. However, we claim that the lower performance is not as expensive price to pay, if one takes many advantages of LINQ technology into account.