Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 2.4

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):

Download Icon 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.