Your team can develop applications using a combination of Iron Speed Designer Professional Edition and Enterprise Edition.
Applications created with the Professional Edition are fully compatible with the Enterprise Edition, and no migration is required going from Professional Edition to Enterprise Edition.
Applications created with Enterprise Edition can also be extended with Professional Edition. However, if certain features are used that are only available in the Enterprise Edition, those features cannot be modified or changed in the Professional Edition.
Existing pages created with the design themes in the Enterprise Edition will continue to work in the Professional Edition.
If an application using multiple databases in the Enterprise Edition is moved to the Professional Edition, the application can continue to be generated by Professional Edition. However, new databases cannot be added and changes to the database settings for the second and subsequent databases cannot be made in Professional Edition.
When the application runs, the ASPX, ASCX, and code-behind files call on functions in the application classes. Those functions, in turn, call on the Data Access Layer classes to access database tables. The Data Access Layer classes, in turn, use ADO.NET to call on the Stored Procedures. The Stored Procedures execute SQL queries to read and write data.
In the Professional Edition, the Data Access Layer classes are slightly different from the Enterprise Edition because they construct SQL statements at run-time in the Data Access Layer. For example, when inserting a record into an Employees table, the Data Access Layer class that handles the Employees table constructs an SQL query such as "INSERT INTO Employees (FirstName, LastName, ...) VALUES (...)". These SQL queries are passed to the database using ADO.NET.