This was one of the first, basic and an important component, that supported and load balanced the entire Entity framework.
The component accepts queries, through APIs for:
* Reading Single / Multiple Entities * Reading Single / Multiple Entities with a query attached * Writing Single Entities * Querying Entities with Related Entities attached
When the entities were built / designed, some boiler-plate stored procedures were also created at the same time and attached to the database. DataLoader translates the queries mentioned above into Stored Procedures and Parameter sets.
It then looks into a database specifically built for Dataloader to find out which Server (node) to use, for the query that needs to be executed.
Once a server/node is selected DataLoader executes the query on that specific server and returns the result in any Entity type
Here is a Read flow:
Here is a Write flow: