Data Access

Business applications inevitably need to use data. Most systems use a database of some sort, often a relational database. Applications can use SQL for querying and maintaining relational data.

SQL has a long and checkered history, which I won’t relate. Suffice it to say that SQL is useful for identifying data and specifying operations to be performed in a standard manner, but that there are two things SQL does not do:

  • It does not specify how an SQL operation should be performed; it defines only what the results should be. This is not a problem for most developers (unless you’re building your own DBMS). Database vendors fall over themselves trying to prove that their solution operates several orders of magnitude faster than the competition. ...

Get Microsoft® Visual J#™ .NET (Core Reference) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.