TierDeveloper 6.1 Features
TierDeveloper is a Code Generation tool having features of template based code generation that enables you to generate business and data access objects. Below are some features of TierDeveloper 6.0 Have a look at them below:
Object Mapping Features
- Filtered Object Inheritance
- Map stored procedures to objects (New)
Objects
- Map to a single table or multiple tables
- Map to a view (read-only or in update mode)
- Define unmapped objects and create tables for them automatically
- Support for auto-generated keys (Identity keys and sequenced values)
- Select subset of table-columns as object attributes
- Support for formula (computed) fields in objects
- Support for NULL values (IsNull and SetNull)
- Name object attributes different from table-columns
- Support all the data types in target language including BLOB
- Data validation on attributes provided including range-checking, greater than, or less than checking
- Extendible field validation framework. Add your own custom field validation logic
- Required and optional field checking
- Save an object only if it is "dirty" (meaning data is changed in it)
- Serialization support for all objects
App GUI Designer Features (ASP.NET & Windows Forms)
- App GUI Wizard (New)
- Forms Designer
- List Pages Designer
- Ad Hoc Search Page Designer
- Menu Designer
Transaction Support
- Specify insert, update, delete, and single-row select operations
- Specify multiple insert and single-row update operations
- Specify bulk updates and deletes with custom where-clause
- Specify transactional characteristics of objects for COM+
- Full transaction support for non-COM+ components in a parent-child relationship
- Non-COM+ components can also be part of client initiated transactions
- Transaction isolation levels for each object
Queries
- Query Timeout
- Specify joins
- Select subset of object attributes for retrieval
- Specify custom where-clause with nested queries, UNIONs, and others
- Accept run-time parameters
- Return a collection of objects as the output of query
- Support GetCount and GetPartialRows behavior in queries
- Support SELECT DISTINCT on queries
- Return Typed DataSets as query results
- Automatically create queries based on indexes
Dynamic Queries
- Same as normal queries but with following additional features:
- Specify where-clause at run-time
- Output of dynamic query is a collection of objects (just like normal queries)
Relationships
- Re-architected support for 1-1, 1-n, and m-n relationships
- Added support for m-n relationships (thru a bridge table)
- Parent-child relationships support for 1-1, 1-n, and m-n
- Lazy loading of related objects in a relationships
- Cascaded updates and deletes for all relationships provided
- Automatically create relationships between objects
Parent/Child Relationships
- In case of 1-1, 1-n, and m-n specify a parent-child characteristic
- Parent object updates or deletes children as part of one transaction
- Parent object loads all children
Stored Procedure Calls Relationships
- Define methods in objects as calls to stored procedures
- Specify input, input/output, and output parameters
- Accept cursors as output of stored procedures
- Use it when a stored procedure has complex business rules
- Generate T-SQL stored procedures for all SQL used in objects
- Generate CLR stored procedures for all SQL used in objects
- TierDeveloper does this automatically and then generates objects code so it is calling these stored procedures
- Improves performance
- Use package syntax for generated Oracle stored procedures
Custom Hooks (safe code)
- Write custom hooks to be called by the generated code from within the methods of objects
- Custom hooks kept separate so objects code can be regenerated
- Generate skeletons and a test application for custom code to make it easy for you to write custom code and test it independently
Typed Datasets
- Support for Typed DataSets for all objects
- Generate .xsd files for all objects and define relationships in them as well
.NET Remoting Services
- Select one of more objects and one or more methods in them and generate web services for them
- Generates a Windows Forms remote client application
- TierDeveloper support RPC-style web services
Code Generation
- Support for Visual Studio 2008 and .Net Framework 3.0/3.5 (New)
- Support for Microsoft Enterprise Library Security Application Block (New)
- Support for WCF (New)
- .NET Remoting App
- Generate ASP.NET and Windows Forms application
- Now you can generate code through TierDeveloper that supports .Net Nullable types
- Complete re-architected template-based code generation engine
- Code templates based on JavaScript language and are customizable
- Customize names for classes, methods, and properties
- Generate .NET components in C# and VB.NET
- Generate either COM+ or non-GAC code
- Generate updatable Datasets
- Build .NET components as private or shared assemblies
WEB App Generation
- Ajax Support
- Generate a fully-working web application
- Web app contains pages to test each and every object behavior
- Generate web app with or without XML/XSLT
Schema Level View
- Quickly view object mappings against all tables in the schema
- Instantly view overlaps in objects on table-mapping
- Easily see which tables haven't been mapped
- Makes object design work very easy
SQL Query Tool
- Quick compile and run SQL before committing it to objects
- Invoke SQL Query Tool from query definition and stored procedure definition windows
- Output of the SQL shown in a multi-column list in bottom window
Generate Design Docs
- Generate meaningful design docs in HTML for generated objects
- Easily update design docs whenever you change objects
Database Servers
- Microsoft SQL Server 2000/2005/2008 (New)
- Oracle 8i/9i/10g
- IBM DB2 7.x, 8.1
- MS Access 2000 or later
- .NET code uses OleDb, SqlClient, and Oracle Client for database access
New TierDeveloper GUI
- Completely redesigned GUI for TierDeveloper (consistent with VS.NET)
- Stand-Alone and VS.NET integrated versions have identical GUIs
ASP.NET and Windows Forms
- Completely redesigned and easier-to-use GUI for generated ASP.NET app
- Support for Windows Forms application generation with a nice GUI layout
- Customize GUI layout for ASP.NET and Windows Forms apps
- GUI layout customization from within VS.NET and/or XML file
- Use drop-down controls with lookup values on forms
- Re-arrange fields on the form, change their sizes, change labels, and more
- Customize layout of list pages. Re-arrange column order, width, and titles
- 1-1, 1-n, and m-n relationships supported in forms and lists
- Support of partial classes
SQL Server Optimization
- Generate SQL API based object code
- Use Windows authentication for security
Oracle Optimization
- Generate Oracle Native Data Provider based object code