Benefits for Developers
- Manage your data access tier in an IDE
- Auto-generate source code and assemblies for the entire Data Access Layer as C# or VB.Net!
- Map SQL Queries directly to .NET Objects, visually!
- Powerful Query Designer
- Use existing Objects or generate dynamically
- Generates low level ADO.NET code
- Unit Test before deploying
- Have full control of your code!
With Orasis Mapping Studio, take your business requirements from conception to source code in one IDE.
No need to write a single line of database access code. Visually map your queries to objects and objects to queries with simple drag and drop controls, and then generate your source code with the click of the mouse!
This promotes proper software design by minimizing the influence of your database schema on your object tier and vice versa. Other approaches force you to have an object for each table, but how often does your business object directly reflect your database tables?
Map from queries to nested objects, interface and abstract class implementations, and back to queries again.
With an integrated SQL editor you can visually build queries directly in the IDE or simply cut & paste them from your editor of choice.
Have existing class hierarchies? Not a problem, map to existing objects by importing your existing assemblies with our built-in Type Navigator.
Or start building your class hierarchy by using the IDE to generate model objects dynamically based off of your queries.
The code generated by Orasis Mapping Studio cuts directly to the chase and utilizes only the lowest level ADO.Net mechanisms.
With the integrated Unit Test Workbench, you can execute queries and the actual generated code without leaving the IDE. Verify data quality and performance before exposing one line of code to your project!
All generated code is Pure, Open ADO.Net code that is easily utilized and extensible. There are no dependencies on third-party libraries that will bind you to a particular technology.
With the click of the mouse, launch your mapping project in Visual Studio 2005 or 2008. Or simply include the generated Visual Studio projects in your solution; then each time your mapping project is built, the changes are automatically detected by your solution.
All code that is produced is Pure, Open ADO.Net code. There are no runtime or source code restrictions at all.
Class files are generated with the partial class construct so they are easily extensible, allowing you to regenerate your database access code without losing your custom functionality.
Leverage the most powerful databases in the industry. Even port your mapping project to another database vendor! Simply change your connection settings and regenerate your code!
Simply expose your data access code through a .Net WebMethod and you're done!