Covalentia Version 2.1 Release Candidate 1

As promised, I’ve uploaded a new release candidate, Covalentia Version 2.1 RC 1 to both Covalentia Community Portal and CodePlex site. This release includes:

• Covalentia.Core project source codes
• Removal of un-used methods and classes in both Covalentia and Covalentia.Core projects
• Upgrading Table and TableColumn Attributes and Attribute Handler classes, and Table Schema generation especially for foreign key support, maximum data length, default value and supports for all possible data type
• New database support for PostgreSQL 8.1 and Oracle 10g (Partial)
• Optimizing and bug-fixing Query Generator class
• Microsoft SQL/MySQL database structure optimizations which include the following:
  • Making data as small as possible for example using smallint and mediumint integer types
  • Declaring columns to be not null
  • Declaring Foreign Keys, Constraints and Indexes
    It is important to note here that since the InnoDB in MySQL database rejects any INSERT or UPDATE operation that attempts to create a foreign key value in a child table without a matching candidate key value in the parent table, only non-zero (or not null) columns may be declared as Foreign Keys.
• Renaming classes and methods to follow Microsoft’s Naming Covention
• Placing C# codes in separate files (for Web Form & Web User Control files) to increase readability
• Using UpdateProgress (Microsoft AJAX) to avoid pages from freezing upon post-back, especially during switching Tabs and Sub-Tabs back and forth
• Applying styles, themes and skins – small changes in the GUI
• Upgrading Tabs and Sub-Tabs for better performance and look
• Better documentations for codes, tooltips and help (partial – this is a lot of work)
• Discontinuation of Covalentia Template files (Covalentia.vsi) – with the release of Covalentia.Core project, it’s easier to copy and paste the whole solution folder when creating a new application

If you encounter any problems, don’t hesitate to e-mail me.
Enjoy ;)