A powerful and dedicated tool like Orasis Mapping Studio fully integrates with Visual Studio and auto generates/manages and tests C# and VB.Net producing ADO.Net code for every parameterized SQL that you would like to build. To generate C# and VB.Net code is now mouse clicks away. Yes, that simple.
A powerful Query designer will tame SQL through drag and drop and intelligence. The Query designer assists developers to build new parameterized queries; visually analyze them and benchmark them before they decide to map them to code. The Mapping Wizard simply does the work for you based on your code settings preferences. Generate C# and VB.Net producing ADO.Net code totally on your requirements and extended as needed. Having a tool that writes the SQL as you drag and drop tables, not only gives you full control to your parameterized queries but also gives you a better understand of the database schema that you are working on. With the designer you can see the relationships among the tables the keys and simply build powerful and optimized queries.
The Orasis Library Reflector allows developers to utilize their class libraries that do not and should not resemble the physical database table schemas. With no requirements on the development of the data models like attributing them or implementing interfaces or extending third party classes and even forcing them to contain ID properties simply provide a default contractor and start mapping! The Reflector will bring in all of the needed library dependencies in the project. Developers can even add them the same way that they are familiar with. So if you generate C# or VB.Net libraries that contain your model objects simply add a default constructor and bring them in.
The Orasis Field Mapping control enables nested object graph mappings between SQL columns/parameters and object fields in your C# or VB.Net model classes. Exploit pure object models that you have generated by visually mapping them to your query results and parameters. Visually expand nested class references or simply replace them with derived instances. Replace interfaces with their implementation classes, or simply replace an abstract class with one of its implementation classes. The Orasis Smart Data Access code generation engine will minimize the number of statements that are required to select, insert, update and delete whether the mappings target queries or stored procedures. Fully advices database metadata, .Net object metadata and standard .Net conversions to produce extremely efficient code. The smart code generation engine will generate C# or VB.Net pure ADO.Net code that performs. Benchmark the generated C# or VB.Net code using the build in unit test engine.
|
Who can you hire to write thousands of pure high performance C# ADO.Net code for only what you need in minutes? Would you prefer a tool that is consistent to generate C# or VB.Net pure ADO.Net code for you?
Apparently for a human to do this, seems impossible. In addition to that, it is such a tedious job that humans tend to copy and paste, apply non standard patterns, add more code that is needed and not even consider the database column metadata for optimum code with less CPU execution cycles in mind.
Does that mean that we will shift to an ORM solution that will shield us from ADO.Net and even SQL? We thought so too and we did it. We found it more costly, non performing, had to learn completely new skills and when it came down to tuning, there was not so much we could do rather experiment with the object query language and the entities. In addition to that, it was impossible to utilize our domain classes and map at any depth in their object graphs.
Orasis Mapping Studio is simple to use, directly targets your business requirements and generates all of the tedious code that you hate to write. You do not want to generate C# or VB.Net ADO.Net code by hand. Some tasks are better left to code generation engines to do so we can concentrate on business logic to grow the value of out applications. There is no reason to abandon ADO.Net and the power of SQL with some ORM framework that can impact development time and performance. There is no reason to abandon control of your data access layer to some framework and treat it as a black box and only wish that it will perform and is easily tuned.
Orasis integrates with Microsoft Visual 2005 and 2008 through auto generated project files that can be added to a project solution. It supports .Net 2.0, 3.0 and 3.5 frameworks, C# and VB.Net and major database vendors like SQL server, Oracle, MySql and Microsoft Access.
|