Alachisoft.com

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