A comparison of database access methods in C# programming language

Marko Kastelec (2013) A comparison of database access methods in C# programming language. EngD thesis.

Preview

PDF Download (1413Kb)

Abstract

The purpose of this study is comparison of different database access methods in C# programming language. Based on our findings the developer will easier choose the most appropriate database access technology, best suited for his needs. We compared three different ways of access: connected, disconnected and through the Entity Framework. When using connected layer, client establishes connection, performs action and closes the connection. When client wants to update the data the connection must be reestablished. Unlike the connected layer the disconnected layer allows data manipulation also when connection is not established. Object DataAdapter automatically establishes and closes the session. It also provides automatic update of data. Entity Framework is ORM framework - data returned through it is returned as strongly typed objects. The developer can interact with database using LINQ queries. Different manners of access were compared on the basis of following criteria: learning curve, documentation and support, implementation time, speed, flexibility and level of object orientation. Each of criteria was assessed with score on scale from 1 to 5. Final score of each of access manners based on weighted average. Each of criteria was weighted by common sense. During the comparison we found out that all three access manners differ by difficulty, the amount of code needed and by performance. We recommended usage of Entity Framework to more expirienced developer even if it's score is not the best. But we advised against using this technology to developers on beginning of their programming path.

Actions (login required)