N-Tier Layer Approach

WinFormsGen generates code in a 3-tier (n-tier) architecture. A presentation tier (winforms - the client), middle tier (business objects), data tier (data access objects), and the database scripts such as stored procedures or a-hoc/dynmamic sql. Code is separated in different layers, see below:

  1. Front End (UI - Presentation Layer) Windows Forms. See more

  2. Middle-Tier Class Files (Middle Layer). See more

  3. Data-Tier Class Files (Data Layer). See more

  4. SQL Scripts (Stored Procedures or Ad-Hoc/Dynamic SQL in Class Files). See more

The generated middle tier objects (and data tier objects) can be put in another project and consumed by other clients. Clients could be a web form (.aspx), a win form, or a web service (.asmx, wcf), etc.

The middle tier encapsulates all calls to the data access objects (data tier) so that calling a CRUD (create, retrieve, update, delete) and other operations are very easy and may only take one line of code for most parts. We made it even easier by generating and showing an example for each CRUD operation, for each table in your database, so you just copy and paste a call from your chosen client.

The data tier encapsulates all calls to the database. These could be calls to Stored Procedures or Dynamic SQL. Stored Procedures or Dynamic SQL are also generated so you don't have to worry about writing T-SQL commands.

Windows Forms 3-Tier

* Please see notes.