
What is an O.R.M (Object-Relational Mapping)
ORM is a technique for converting data between incompatible type systems using object-oriented programming languages. In the context of database management, an ORM provides a way to interact with a database using objects and methods, rather than writing raw SQL...

ADO The origin of data access in .NET
.NET communicates with a database using ADO.NET, which provides a set of classes and interfaces for accessing and manipulating data stored in a database. ADO.NET supports various database systems, including relational databases and XML databases. ADO.NET uses the...

Relational database systems: the holy grail of data
RDBMS stands for Relational Database Management System. It is a type of database management system that is based on the relational model, which organizes data into tables with rows and columns, and uses relationships between tables to link data together. In an RDBMS,...

Alchemy Framework: 2 – Repository Structure
Alright, it's time to start writing some code, but first, let's decide how this project will be organized. So far, the repository structure that I've found most appealing is the one I used for the SyncFramework (https://github.com/egarim/SyncFramework). Here is a...

Alchemy Framework: 1 – Creating a framework for import data
Last Friday, I received a message from a dear friend and colleague, Pedro Hernandez. He asked me if I had the latest compiled version of the XPO import framework we created in our office. As it turned out, I did not have it readily available and had to search...

Querying external data sources in XAF
I will explain what XAF is just for the sake of the consistency of this article, XAF is a low code application framework for line of business applications that runs on NET framework (windows forms and web forms) and in dotnet (windows forms, Blazor and Web API) XAF is...