| In some situations, Data Providers can be used instead of Procedures. We can say that a Data Provider solves a subset of problems created by Procedures. What are they? Those where the input is taken from the Database or an SDT, or fixed data, and the goal is to obtain a hierarchical output that could be represented by an SDT (or BC).
While in a procedure the focus is in the transformation language (that transforms the input into the output), in a Data Provider the focus is on the proper Output. For this reason, we say that it's an output-based language, mainly "declarative" (instead of "procedural").
What are the benefits? In addition to its ease of use, a declarative language is higher-level. In the future, the underlying implementation will be changed without having to change the declaration of what the DP does, that is, the DP code itself.
|