Flexibility

ODS has been built from the ground up to support multiple database types. This goes well beyond simply selecting a type of database that you want your DAL to support:

• ODS supports the following database types:
  • SQL Server 2000/2005/2008
  • MySQL
  • SQLite
  • MS Jet (The database used by MS Access)
• ODS generates a database agnostic DAL - write one set of code in your application and have it work with any of the supported database types.
• Support for multiple simultaneous database types - support as many simultaneous databases of whatever type you want, all through the same code.
• Hot swappable database types - decide at run time which type of database you want to use, or let the user choose.
• Create new databases or upgrade existing ones directly from the DAL - no external tools required.
• Easily customised DAL source code - the generated DAL source code implements a framework that can be easily leveraged using inheritance to add custom functionality.