Login
Language:
Currency:
VAT Mode:

Products

Product Matrix

Graphical Step-By-Step Interface

The DOM Wizard Tool is an easy to use, step-by-step program that leads you through the process of generating your code. You will be amazed at how quick and easy it is. In 5 easy steps, the DOM Wizard will collect the necessary information to generate your code. At the end of the generation, it even creates a customized sample application that uses your newly generated code! You are instantly jump started and have all the code and examples you need to complete your project.

Watch the video and see how fast and easy it is... just 5 easy clicks from start to finish!

Back to the top

Visual Studio 2008 and 2005 Support

DOM Wizard automatically creates Visual Studio 2008 and 2005 enabled class and project files. Enjoy intellisense support of your generated objects for fast agile development. No matter what your current programming environment DOM Wizard makes it easy for you.

Back to the top


C# and VB.Net Support

C# and VB.Net are the most poular development languages for Visual Studio. If you have some developers that use C# and some that use VB.Net the DOM Wizard is perfect for you. It can produce the same 100% managed code no matter what languages you or your clients use. Simply click a button and switch your output to your language.

Back to the top


Select/Fetch Helper Methods

It is great that DOM Wizard will produce strongly typed objects modeled off your database schema. But where the real value is added is in the Fetch methods. DOM Wizard generates custom Fetch methods that create dynamic SQL statements that read data from your database and populate your generated objects. These Fetch methods not only speed development tremedously but also reduce your SQL code maintenance. The Fetch methods will handle all your data access. That means when you make a database change and regenerate, the compiler will tell you when a Fetch method is no longer valid. Click here to get more information about the Fetch and other helper methods generated by the DOM Wizard.

Back to the top


Delete Helper Methods

Every class generated by the DOM Wizard also creates Delete methods. These methods create dynamic SQL statements to delete from your database and wrapper these calls in transactions to protect your data. If the call fails the process will be rolled back. Click here to get more information about the Delete and other helper methods generated by the DOM Wizard.

Back to the top


Save Helper Method

By far the favorite method amoung DOM developers is the Save helper method. The Save method is so great because of its simplicity. All you have to do is load your object with the necessary data and then call Save. The only parameter is the connection string. It is so smart it even knows whether the data will create an insert or an update and handles it appropriately. Plus, it is all safe and secure in a transaction. To take it a step further, the Save will even follow the object tree if you loaded it. For example, if you created a Customer object and also added the Orders for that customer, the Save method would save the Customer and the Orders in the same transaction. This method alone is reason enough to use the DOM Wizard for every project.

Back to the top


Paging Collections

The generated Fetch methods can load a single object or a collection of the same object. When you want a collection that is paged, you would call a Fetch method that ends with "Collection_Paging". Calling these methods is just as easy and flexible as all the other Fetch method. All you do is pass in the PageSize and the PageNumber you want. It also accepts a TotalPages parameter so you can use the value returned to build your custom paging solution. Click here to see a code example. *** SQL SERVER 2005 ONLY

Back to the top


Extensible Partial Classes

DOM Wizard makes all the generated classes partial so you may add your own custom methods. All you have to do to extend the classes is to create another partial class file and you add your own customized methods to extend the functionality of your generated class files.

Back to the top


Override-able Methods

If extensible was not enough, the DOM is also override-able. Override-able means that if you want to change a DOM generated method, you can override that method and use your own code. For example, maybe you need to add some special logic to the Save method. Well, all you need to do is override the Save method and you can implement your own Save method anyway you like. All non-static methods are Virtual which gives you all the power and control that you need to override.

Back to the top


XML Support

Sharing data between systems is a must in todays development world. XML is the standard for sharing data. The DOM Wizard provides several ToXML methods on every generated object to meet you XML needs. All you have to do is load the object with a Fetch and then call the ToXML method that works for you. These methods are also Virtual so these methods are override-able.

Back to the top


Stored Procedure Support

The Fetch methods generated for you by the DOM Wizard are incredibly flexible and powerful. However, you may need to do a complicated table join or do some calculations on the data that is best done on the SQL server. For these situations, the DOM Wizard builds special Fetch and Delete methods that support Stored Procedures. Again, it is just a simple matter of giving these methods a connection string, the stored procedure name and any necessary parameters. 

Back to the top


Static Table Enumeration

Enumerated tables are tables that are often thought of as "Lookup" tables. Enumerated tables should be static tables with few rows. Examples of enumerated tables might be Customer Types, Product Types, and Regions. These tables should have foreign keys back to a parent table to maintain your data integrity. Enumerating tables is beneficial because it helps the developer quickly assign values, makes code more readable, maintains data integrity and can improve performance by eliminating round trips to the database.

The DOM Wizard gives you the choice of defining an Enumerated table during the generation process. Click here for a screen shot and a more detailed explanation.

Back to the top


Command Line Support

Using a windows tool to generate your code is great but sometimes you want to skip all the clicking and get down to the business of generating your code. We have a solution for you there too. The DOM Wizard saves all the information you enter into a project file. The DOM Builder is an application that takes that project file and generates your code. So all you have to do to generate your code is call the DOM Builder from the command line and pass in the appropriate project file. And in seconds you will have your generated code.

Back to the top


Entity Relationship Awareness

The DOM Wizard builds classes that are aware of database foreign key relationships.

Entity relationhip awareness gives you access to parent/child relationships when reading and saving data. With a single fetch to the database you can populate your entire object tree (Customer -> Orders -> Order Details, etc.). Then change the data and commit all the data to the database with a single save. You can do all this without writing any SQL.

Back to the top


Database Script Execution

Not all development enviroments will allow the person generating the code to install the DOM Wizard generated stored procedures on the SQL Server. Therefore, the DOM Wizard gives you the choice to execute/install the stored procedures. Regardless of your choice, a sqlscripts.sql file is created within the output directory so you can easily run the scripts at any time.

Back to the top


LINQ Support

Leverage the power of LINQ in your applications. Full LINQ support is just a click away. Simply check the Enable LINQ option in the DOM Wizard GUI tool. DOM Wizard will apply all the table/object attributes and the column/property attributes for you. DOM Wizard even creates the EntitySet relationships for you.

LINQ and DOM Wizard generated objects are a perfect combination. Use DOM Wizard's super fast and efficient DataReader FetchBy methods or LINQ's infinite query flexiblity to populate your objects. Combine the 2 technologies for coding agility like you have never experienced before.

Back to the top


No Update Tables

No Update Tables are tables designed to be insert only tables or read only tables. Examples of such tables are logging tables. The DOM Wizard creates special stored procedures for these tables that are more efficient and faster than normal table stored procedures.

The DOM Wizard gives you the choice of defining No Update Tables during the generation process. Click here for a screen shot and a more detailed explanation.

Back to the top


No Update Columns

No Update Columns are columns in a table that are designed to be read only. After the data is inserted and a row is created, the data should only be read from the database. After you set a column to No Update, the column will not be updated even if the developer explicitly sets the column to a new value. No Update columns relieve the developer of the responsibility of remembering what columns should or should not be updated.

The DOM Wizard gives you the choice of defining No Update Columns during the generation process. Click here for a screen shot and a more detailed explanation.

Back to the top


Custom Get/Set Accessors

The DOM Wizard provides an easy way for developers to inject their own code into the generation process. By using the Custom Get/Set Accessor page, developers may write custom code to their specifications and their work will be saved and reinjected each time the DOM Wizard re-generates the code for the project.

Click here for a screen shot and a more detailed explanation.

Back to the top


100% Managed Source Code

The DOM Wizard generated code requires the use of the DOM library for Fetch,Save and Delete functionality. The DOM library is 100% managed .Net code. If you find the need to change the DOM library you can buy the Enterprise license that will give you the complete source code in either C# and VB.Net. Special terms and conditions apply to this license. The DOM Builder source code is not provided.

Back to the top