Orasis Mapping Studio is a new approach to mapping databases and objects using the power of code generation. Whether the task is reading objects or persisting objects, building complex SQL Queries, managing your mappings or testing your database access code, it provides a complete toolset for Developers and DBAs.

A mapping an association of data between the Relational Database fields and .Net Object Properties. A mapping in OMS is made of three parts; a SQL Query, a .NET Object and a set of Field Mappings that associate the columns from the query to the .NET Object's properties. Once a mapping has been completed, the OMS stores the mapping and generates a method that translates the mapping into .NET code instructions that execute the mapping and return the results.

Orasis Mapping Studio has a sophisticated code generation engine to translate the mapping and database information into optimized, non-proprietary .NET code. This generated mapping layer compiles with no syntactical errors and is written in partial classes for extensibility. The code generator uses efficient ADO.NET constructs and Database Provider information to generate code for performing all of the database access activities as necessary.

Orasis Mapping Studio provides a built-in test bed, that allows users to test mappings through the generated code. This allows the users to unit test and benchmark their mappings and generated code for performance, data accuracy and execution. This is an must have for any software developer to be able to unit test his or her own code before calling it complete.