.Net Code Generation with VicSoft.GenerationX

We know the story. Having gathered the requirements and designed your data driven web application, we now have the task of spinning out the code. After implementing our data model in a relational database, we start to write the stored procedures and data access code to populate the forms and pages of our application. But hang on - you might think as a developer - the majority of this code is standard stuff that we have to implement again and again for every application. Wouldn't it be nice to have the essential but time consuming grunt work (the create, retrieve, update and delete code for each of the tables in your database) on a plate so that we can get on with the interesting stuff that gives real value to our applications.

Enter GenerationX. These powerful code generation libraries will scan your SQL Server database and produce 60% to 70% of your business and data access layer code in seconds including:

  • Stored procedures including all basic CRUD operations as well as 'gets' by foreign keys.
  • Business object classes. Easy to use, strongly typed objects with full data binding support that make for robust and maintainable UI and client code.
  • A Data Access Layer including an object relational mapper which seamlessly translates your business objects to your database tables and fields with full transaction support.
  • A Business Facade which provides the business tier interface for your UI and client code. Also provides placeholder functions in which to implement your business rules.
  • A set of User Controls for displaying and maintaining your application data. Just drag and drop onto your web forms.

Features

  • All generated .Net code is fully extensible using inheritance and partial classes.
  • Code generated for C# or VB.Net to suit your preferred development language.
  • .Net 1.1 and .Net 2.0 supported.

Prices

  • From £30 per database table (back-end code only). Includes 2 repeat generations on minor database modifications.
  • User Controls for rapid UI web development from £10 per database table.
  • Prices for full project life-cycle support available on request.
  • Consultancy, database design and development services also available to help you get the best from your GenerationX application framework. Please contact to discuss requirements.
  • Licences available for the GenerationX .Net code generator with and without source code. Please apply for details.

Try it

Download a sample based on the Northwind SQL Server sample database and try it yourself.

Instructions:

  • Unzip the contents of the zip file.
  • Attach the Northwnd.mdf file (found in /database directory) to your SQL Server installation.
  • Run the SQL script Northwind_Stored_Procs.sql (found in /sql directory) against the Northwind database to create the GenerationX generated stored procedures.
  • Start a new ASP.Net 2.0 web site project in Visual Studio.
  • Set up a connection string to the Northwind database in project web.config file with the name "Northwind".
  • Set references in your project to Microsoft.ApplicationBlocks.Data.dll and VicSoft.Objects.dll (found in /helper directory).
  • Add the files in the /code/C# or the /code/VB directory depending on your programming language to the project App_Code directory.
  • Create an instance of the VicSoft.Northwind.Business.NorthwindBusinessFacade class in your web page code and you are good to go!
  • Alternatively bind the objects returned by the business class directly to your web controls.

Or send me your database schema

Send me your database SQL script and I will supply a sample for evaluation based on a subset of your database tables.

! Warning !

GenerationX is not an 'application in a box' service. It is a means of saving time and expense and provides a robust N-Tier, Object Orientated framework for your application.

 

   
Client Links