Building ColdFusion services with ColdSpring and Reactor, part 4

Submitted by Falken on

The final layer is the data access (this is normally combined with a database abstraction) layer, which commonly uses ORM techniques.
Reactor or Transfer typically slot in here and take care of the details of writing actual SQL.
As an example where this might be of use, here is a quick question- is the LIKE operator in the Where clause case sensitive in the Informix database? Reactor's GetWhere().isLikeNoCase() method knows the answer, which means you can mostly not care what database your code is running on.

A good ORM will also remove the drudgery of creating the repetitive create/read/search/update/delete code for each table.

And that concludes out whirlwind tour of building ColdFusion services.

For my next trick, I'll be talking about how ColdSpring can save you even more time, by removing the Service layer entirely. Sounds crazy, but it might just work !

Previous Part | Interlude | Next Part

Sections