Please note that ODS is no longer available
How does ODS work?
ODS is a dedicated Data Access Layer designer. Rather than starting with a database, you start by designing the objects that you want to store in a database, using ODS Design Studio. ODS automatically designs a database for you based these objects and generates .NET source code that implements a Data Access Layer (DAL). Your application uses the DAL to create new databases and store and retrieve your objects. ODS Design Studio also tracks design changes and automatically generates updated DAL source code that can be used to upgrade databases previously created by your DAL.
Key technical features
Fast source code generation
ODS generates and re-generates source code in seconds. Since ODS also takes care of the database schema design and schema upgrades automatically, it's perfect for rapid prototyping or for quickly developing n-tier / layered applications.
Requires little or no database expertise
ODS does not require an existing database or, in many cases, require you to write any SQL. Instead, you use ODS Design Studio to design the objects that you want to store in a database. You can choose from a number of pre-defined "Add", "Update", "Delete" and "Get By" methods that you want to use to store and retrieve objects in the database. ODS automatically designs a database that can store the objects that you have designed. It also designs the SQL/Stored Procedures needed to implement the "Add", "Update", "Delete" and "Get By" methods. All of this is built into the source code which ODS generates.
All in one Data Access Layer designer
ODS Design Studio can be used to design and generate source code for an entire DAL from scratch. No existing database is required, in many scenarios you won't need to write any code or SQL and no external tools are needed. It's all done automatically. ODS automatically designs the database schema and data access SQL for you. It even automatically handles changes to the design. An entire DAL can be created from scratch using only ODS Design Studio.
Generates the entire DAL as C#.NET 2.0 source code
ODS is a source code generation tool, not a run-time library, environment or service. The generated source code does NOT require ODS or any ODS run-time components to be installed for the source code to compile or run. No DAL functionality is hidden away in proprietary dlls or run-time components. Since it's all source code, you can view or modify any part of your DAL. ODS generates high quality, consistent, well documented source code that fully conforms to Microsoft's best practice style and consistency rules.
Supports SQL Server 2000/2005/2008, MySQL, SQLite 3 and MS Jet 4
ODS gives you the flexibility to support multiple database types through a single DAL. No need to create and maintain separate DALs for each different type of database. Write your code once and let the ODS generated DAL deal with the different database types. ODS generated DALs implement a provider model which allows you to switch seamlessly between database types, without changing your code.
An ODS generated DAL allows you create multiple data stores within the same database and makes it easy to share the database with other systems. A high degree of isolation is achieved by automatically prefixing all database objects (table and procedure names) created for each data store. This allows different DALs to share the same database as well as multiple instances of the same DAL and other systems, such as ASP.NET security.
Easily extendable source code
ODS generates source code for an Object Oriented DAL with extendibility built in. Virtually all functionality can be overridden and extended using inheritance. Alternatively, since the entire DAL is generated as source code, you can simply modify it.
No runtime licenses or source code restrictions
ODS is a source code generation tool, not a run-time library, environment or service. As such you only need to purchase a license for each development machine that you install ODS on - to generate source code. Once you've generated source code, you are completely free to modify, compile or distribute the source code with your commercial or non-commercial application. There really are absolutely no licensing requirements or restrictions on the source code generated by ODS. You do not need ODS or any ODS run-time component to be installed to compile or run the source code generated by ODS.
Generates Visual Studio 2005 project and solution files
To save time, ODS can automatically generate Visual Studio 2005 Project and Solution files that can be used to compile the generated source code. ODS can package the generated source code into one or several VS2005 projects.
Key business benefits
- Greatly reduced development time - developers spend less time coding and bug fixing
- Increased quality - source code is consistent, bug free and well documented
- Greater flexibility - seamlessly support multiple database types
- Reduced developer skill requirements - ODS requires little or no database skills to use
- No technology lock in - ODS generates source code - there are no proprietary components
- Excellent ROI - no expensive runtime licenses