Accessing data
Data displayed or updated by a user is stored in a database. In our case, as we are oriented towards Microsoft technologies, it is stored in the SQL Server database.
If you are a veteran, you will remember how connections opened in Windows developments via databases from the application itself, and queries were executed. This was possible as these applications were in the same local network as our server.
When web technologies and globalization came in, things got more complicated. Our database server, due to security reasons, is located behind a firewall, so only certain users/servers can access it. Moreover, our application is executed in environments and languages which do not allow direct access to data, for instance, a web browser and JavaScript language. In order to solve this issue, there were two common options:
Legacy web applications used to make a post of the page on the server, accessing the database (no AJAX calls), at that stage. This was an easy approach, although...