Databases
ODS currently supports SQL Server 2000/2005, MySQL, SQLite 3 and MS Jet 4.0 databases.
Do you intend to support other types of database in the future?
show answer...
hide answer...
Yes, very much so. ODS has been built from the ground up with an extensible plug-in system that allows new database types to be easily supported. We regularly release plug-ins that support new database types.
I have an existing database. Can ODS generate a DAL from it?
show answer...
hide answer...
As of ODS version 2.2, you can now create new classes based on tables in an existing SQL Server 2000/2005 database. Please note that this is a one way import process.
Can an ODS generated DAL share a database with other systems such as DotNetNuke or the ASP.NET membership tables?
show answer...
hide answer...
Yes. An ODS generated DAL can create a new database from scratch but it will happily create tables and stored procedures in an existing database. To prevent database object names conflicting, ODS can automatically prefix the names of all database objects created by your DAL with the text of your choice. This provides a high degree of isolation from other systems, including other ODS data stores.