Izrada web-servisa s podrškom za protokol OData uz korištenje objektno-relacijskog preslikavanja alatom Dapper

master's thesis

• Title (english): Creating an OData compliant Web-service when Dapper is used for Object-Relational Mapping
• Author: Katarina Kelam
• Mentor: Boris Milašinović (mentor)
• Committee member: Boris Milašinović (predsjednik povjerenstva)
• Committee member: Mirta Baranović (član povjerenstva)
• Committee member: Mirjana Domazet-Lošo (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2019-07-04, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

U ovom radu je analizirana i istražena mogućnost izrade web-usluge uz OData protokol koristeći Dapper sustav objektno-relacijskog preslikavanja. Objašnjene su teoretske osnove obje tehnologije i dokumentiran je način njihova neovisnog korištenja. Razrađeni su načini pristupa i obrađivanja podataka koristeći OData protokol uz Entity Framework te je isto napravljeno u implementaciji s Dapperom. OData opcije upita su prevedene u SQL upite za uspješnu koordinaciju s drugačijim tipom objektno-relacijskog preslikavanja. Pristup bazi podataka je u ovom radu ostvaren preko Dapper sustava objektno-relacijskog preslikavanja, rezultirajući brzim odgovorima na klijentske zahtjeve. Napravljena je klijentska aplikacija koja poziva web-uslugu te na taj način testira ispravnost implementacije. Svi zahtjevi i odgovori unutar sustava (klijentske aplikacije i web-usluge) su uneseni u zapisnik za kasnije proučavanje.

Abstract (english)

This paper explores and analyses the possibility of creating a web-service using OData protocol and Dapper object-relational mapping system. It explains the theoretical foundations of these two technologies and describes the way they should be used. Different approaches of data access and processing ways in the implementation of Entity Framework and Dapper are compared against one another. In the implementation of this paper, wanting to achieve successful coordination of OData with a different type of object-relational mapping, OData query options are converted to SQL queries. Communication with the database is realized using Dapper, accomplishing swift responses to client requests. As a part of this thesis, a client application is made that calls the web-service to test the implementation. All requests and responses in the system (both client application and web-service) are written in a log file for further study.

• Keywords: OData; Dapper; Entity Framework; web-usluga; REST API; objektno-relacijsko preslikavanje; SQL
• Keywords (english): OData; Dapper; Entity Framework; web-service; REST API; object-relational mapping; SQL
• Language: croatian
• URN:NBN: urn:nbn:hr:168:020899
• Study programme: Title: Computing; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra inženjer/inženjerka računarstva (magistar/magistra inženjer/inženjerka računarstva)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2020-01-07 19:03:49