Article Preview
Buy Now
COLUMN
Simple Object Relational Mapping
Working with relational databases.
Issue: 2.4 (March/April 2004)
Author: Paul Lefebvre
Author Bio: Paul Lefebvre is President and Chief Software Architect of LogicalVue Software, producers of SQLVue, Schema and other products.
Article Description: No description available.
Article Length (in bytes): 4,998
Starting Page Number: 37
Article Number: 2418
Resource File(s):
2418.zip Updated: 2013-03-11 19:07:57
Related Link(s): None
Excerpt of article text...
Sometimes it can be annoying to deal with the database in a relational format; it continually requires you to write SQL. SQL is powerful, but it is not object-oriented and is sometimes difficult for people to grasp. An alternative way to access the database is to map the data to classes and then interact with the classes. The classes contain (and hide) any SQL that is used.
Two benefits for using a design such as this are:
1. We only need to connect to the database when needed.
2. The SQL is isolated in the mapping classes making your main code more readable and minimizing the changes needed should the database change.
Softball Again
...End of Excerpt. Please purchase the magazine to read the full article.