ePrints.FRI - University of Ljubljana, Faculty of Computer and Information Science

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.

Download (1413Kb)


    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.

    Item Type: Thesis (EngD thesis)
    Keywords: database access manners, connected layer, disconnected layer, Entity Framework
    Number of Pages: 56
    Language of Content: Slovenian
    Mentor / Comentors:
    Name and SurnameIDFunction
    viš. pred. dr. Igor Rožanc278Mentor
    Link to COBISS: http://www.cobiss.si/scripts/cobiss?command=search&base=50070&select=(ID=10138452)
    Institution: University of Ljubljana
    Department: Faculty of Computer and Information Science
    Item ID: 2152
    Date Deposited: 13 Sep 2013 16:36
    Last Modified: 25 Sep 2013 14:11
    URI: http://eprints.fri.uni-lj.si/id/eprint/2152

    Actions (login required)

    View Item