Orasis Mapping Studio is a new approach to mapping relational data and objects using the power of code generation. From reading and persisting objects, building complex SQL Queries, managing mappings, and unit testing database access code, it provides a complete toolset for Developers and DBAs.
|
|
|
|
Build Read mappings using Select Queries for reading Objects and build Write mappings to persist data from Objects into the database using Insert, Update or Delete Statements.
Parameterized queries are the safest and most efficient way to build dynamic queries and filtering. The Orasis Mapping Studio's Query Parser recognizes query parameters, their associated columns and data types for different databases and uses them for mapping and generating code.
Edit, format and visualize your SQL, in a fully intellisense and keyword enabled SQL editor that makes writing SQL easy.
With the Orasis Mapping Studio's SQL features, SQL query "writing" is no longer a chore.
Supports mapping data to any .NET Type as long as it has a default constructor and member Properties.
You can import and browse your .NET Assemblies and select the Types to map to. The browser displays class details and can search by name, Base Classes and Interfaces.
The Orasis Mapping Studio's powerful mapper allows you to map data into nested Classes, by instantiating the necessary nested Objects. If you have Class members that are Interfaces or Abstract Classes you can easily instantiate them with concrete implementations within the mapping.
If you do not have existing Class libraries, generate the Classes on the fly and populate your application with data in minutes.
If you are using the MVC pattern, populate your existing Model objects directly with data from the database without any modifications to your Classes. Keep database access code separate from Object code!
Manage all your Types whether they are imported or generated used in your project in one location.
The code generation approach does not require you to alter your Business or Domain object to map them with data. Keep you objects light, easy to serialize and for use in Web Services.
The code generator generates statements for establishing Connections, executing queries or stored procedures, setting Parameters, and mapping the data. The code is built with the optimum pattern for performance and readability. The code is built using only ADO.NET base classes and Data Providers along with the DataReader. To provide a well performing data-access layer attention is paid to details such as; closing Connections, performing Null Checks when necessary, setting fields to DBNull where applicable, converting data types implictly if applicable. The code is generated with the user's documentation comments making it readable and up to the standards of good coding and documentation practices.
The code is also compiled to Assemblies with all your mapping methods and classes for performing your data-access. Simply reference the Assemblies, instantiate the Classes and call the methods to access your data.
All the generated code is compiled using the .NET compiler and the
Assemblies are generated.
All the SQL Statements are also verified for syntax and symantic
errors against the Database.
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.
A fully integrated development environment with multi document interface, integrated windows and dockable components.
- Microsoft SQL Server
- Oracle
- MySQL
- Microsoft Access
- OLEDB
- ODBC
Automatically generate solution and project files and launch them in Microsoft Visual Studio.
Generate Code in either C# or VB.NET
View all the generated code in a Visual Studio style code editor.