THE 3 rd INTERNATIONAL SCIENTIFIC CONFERENCES OF STUDENTS AND YOUNG RESEARCHERS dedicated to the 99
th
anniversary of the National Leader of Azerbaijan Heydar Aliyev
230
approach. In further improvements, web based, and mobile version of the
application can also be developed. Additionally, more sophisticated protections
can be built in desktop application in terms of security issues. [1]. The main
programming language which is going to be used is C#. C# provides us with
unusual flexibility and breadth, representing the seventh major update to
Microsoft’s flagship programming language. It offers us higher level abstractions
including asynchronous continuations and query expressions. In terms of IDE,
Visual Studio 2022 will be used for the machines working on Windows
Operating System. But in future, Jetbrains can be used to develop the cross-
platform application for macOS, Linux and other operating systems. [2]
To build the front end of application, WPF will be used for Windows
platforms. Microsoft Windows Presentation Foundation is an UI (User
Interface) framework which is a part of MS dot Net family. In early days,
developers mainly used Windows Forms, which has a lot of pros, as well as
cons. However, WPF is superior to the Window Forms if you want to build a
standalone, browser-hosted, client applications. The application in question
will include a lot of media types which is a deal-breaker to use the WPF
instead of Windows forms. For the database, Microsoft SQL will be used.
Microsoft SQL is one of the relational database systems (also known as
RDBMS) which supports variety of intelligent business processes,
processing of transactions, and data analytics in huge companies, banks, IT
companies. There are 3 leader technologies in database management
systems and MSSQL is one of them while Oracle DB and DB2 which is
developed by IBM comes second and third.
In SQL servers, there is a row-based table structure which connects
related elements in different tables with each other. By doing so, it also
avoids redundantly copying data in multiple places within the database to
increase the optimization of the system. SQL Server Database Engine is the
main component of MSSQL Server which includes relational engine to
control processing, storing and security of data. Database engine executes
and creates database objects, triggers views while a stored engine is used
to manage buffers, indexes, and transactions. [3]
While developing a desktop application, there are a few design patterns
that should be followed in order to build optimized, proper application. One
of them is MVVM called Model-View-View-Model design pattern which is
consists of 3 groups, namely Models, Views and View models. Models are
basically classes or structs that holds application data, while the Views are
elements controlling the view and screens. View models are simply classes
which helps to transform the model into a suitable form to display it on the
screen and they are passed around as a reference. MVVM makes it possible
for developers to work on the code while the designers work on the UI at the
same time without interrupting each other by separating the visual section of
the app from the related code.