Be the first to post a text review of BizBlox ORM. Rate and review a project by clicking thumbs up or thumbs down in the right column.

• Code committed

  eorlingas committed revision 146 to the BizBlox ORM SVN repository, changing 2 files

  posted by eorlingas 427 days ago

• Code committed

  eorlingas committed revision 145 to the BizBlox ORM SVN repository, changing 18 files

  posted by eorlingas 427 days ago

• Code committed

  eorlingas committed revision 144 to the BizBlox ORM SVN repository, changing 1 files

  posted by eorlingas 427 days ago

• Code committed

  eorlingas committed revision 143 to the BizBlox ORM SVN repository, changing 3 files

  posted by eorlingas 427 days ago

• Code committed

  eorlingas committed revision 142 to the BizBlox ORM SVN repository, changing 5 files

  posted by eorlingas 436 days ago

• bizblox BizBlox 1.6.2.0 file released: BizBlox2.0-1_6_2_0.exe

  ************************************* BizBlox Release Notes ************************************* KEY: ==================================== +: Added/updated functionality x: Bugfix !: Important release note 1.6.2.0 ____________________________________ +: In BizBlox Builder, only update files if their core content has changed. 1.6.1.0 ____________________________________ +: Added implicit Find() call if Find() is not previously called on a DOCollection and an attempt is made to access an Object +: Change SqlBuilder Join methods to only add a Join to the query once, regardless of how often an attempt is made to add it. +: AddWhereIn() overloads, accepting arrays of strings and GUIDs +: AddWhere(),AddWhereGT(),AddWhereLT(),AddWhereGTE(),AddWhereLTE() overloads which allow comparison between columns in the query 1.6.0.3 ____________________________________ +: Changes to increase performance - Added Fetch() methods to DOCollection +: Added Average() and Sum() methods to DOCollection x: Fixed a missing Dispose() call on iDbConnection in the DataAccess class. 1.6.0.0 ____________________________________ !: 1.6 is a fundamental version step from the previous version. To use this version, DataObjects must have a new constructor added. This is due to a major change to the platform to accommodate much better performance in non-random data access of collections. The BizBloxBuilder has been updated to support the new DataObject constructor so it should be a painless exercise. +: DOCollections now support Fetch and FetchRange methods which perpopulate the collection. +: Passing SQLBuilder directly to a Find (or any method in a DOCollection other than SetCurrentQuery) has now been made obsolete and will cause warnings. x: Fixed bug in C# code generation with regions !: Code Injection: There are now special meta comments around every element in the code generated by the BizBlox Builder. This allows you to change the value of $DoNotModify variable such that you can set up specific properties to have custom behaviour and continue to use the builder to update your classes. // ##Start CodeSegment // $Identifier = LunchOrderID // $DoNotModify = True private System.Guid m_LunchOrderID; public System.Guid LunchOrderID{ get { return m_LunchOrderID; } set { ...add some code anywhere here which will not be replaced by subsequent passes of the BizBlox Builder... this.Touch(); m_LunchOrderID = value; } } // ##End CodeSegment Note that the $Identifier value MUST be one generated by (or compatable with) the BizBlox Builder. You cannot create arbitrary identifiers, they will be deleted. 1.5.0.1 ____________________________________ +: Added 'Launch BizBlox Builder' to installer finish screen x: Fixed bug with UNIQUE constraints being parsed as Primary Keys in SQL Server 2005-generated scripts x: Updated the install script for less (!) .Net support - useless carry over x: Fixed long standing file association bug, BBX files are now associated correctly. x: Fixed bug with default values not working for DateTime mapping and BoundsCheck project options 1.5.0.0 ____________________________________ +: Added Builder back to SourceForge code +: Removed Registration from Builder +: Cleaned up .NET 1.1 and 2.0 directory structures +: Allowed Builder to process SQL Scripts generated by SQL Server 2005 Management Studio +: Incorporated previous changes to project files to make them XML +: Incorporated previous changes to registration validation to remove DPAPI functions ____________________________________ 1.4.0.0 ____________________________________ +: Added .Net 2.0 and ADO 2.0 support x: Changed some enumerated type values to be CLS 2.0 compliant, namely in the SQLGrouper and SearchBuilder (See Knowledge Base for details) +: New transactional handling in .Net 2.0 version (see knowledge base for details) x: Fixed References in Unit Tests ____________________________________ 1.3.0.0 ____________________________________ +: Added AddWhere overloads for integers and floating point !: Unreleased... :( ____________________________________ 1.2.1.0 ____________________________________ +: Added C# and VB.NET example projects to installation package. +: Added ResetCurrentQuery() method to DOCollection. +: Improved API documentation for SQLBuilder and DOCollection classes. +: Added help file for BizBlox Builder. ____________________________________ 1.2.0.1 ____________________________________ x: Fixed bug in DOCollection.BindDataSource when binding to WinForms controls. ____________________________________ 1.2.0.0 ____________________________________ +: Added support for comparison operators in WHERE clauses (<,<=,>,>=) +: Added support for LEFT, RIGHT and FULL OUTER JOINS IN SELECT queries. +: Added support for >= and <= date operators in WHERE clauses +: Added support for using SearchBuilders against multiple concatenated columns. +: Updated unit tests for the new SQL functionality ____________________________________ 1.1.0.0 ____________________________________ +: Added support for sequential INNER JOIN using columns over more than two tables +: Added support for DISTINCT clause in SELECT query. +: Updated unit tests for the new SQL functionality ____________________________________ 1.0.0.2 ____________________________________ x: EULA Bugfix! Legal wording on some sections amended. Worthwhile reading it. ____________________________________ 1.0.0.1 ____________________________________ x: minor updates to registration process x: minor updates to C# unit tests x: cosmetic updates to the installer ____________________________________ 1.0.0.0 ____________________________________ +: Added support for locked files (partial code generation fails) ie: source control compatible +: Added double click support to BizBloxBuilder project files +: Added Drag and drop support to BizBloxBuilder +: Added BizBloxBuilderCMD to allow command line execution of builds +: Added GetTop, SetTop and TopCount to the SQLQueryBuilder +: Added renderCount to SQLQueryBuilder -: Removed addTop method from SQLQueryBuilder +: Changes to the way the DOCollections work; you can use them as before where the finder method would set the SQLBuilder at the time of performing a find. To allow DOCollections to maintain a query context without PERFORMING a query, we added a SetSQLBuilder and GetSQLBuilder method and added a Find(), Delete() and Count() methods which would use the context rather than needing the context set. This allows for better performance performing some operations such as a 'count' will not need the find to be performed to provde the resulting count for the find method. + Added LIMIT emulation to DOCollection using the FindRange() method. + Added GUID addWhere methods to the SQLBuilder ____________________________________ 0.9.9.1 ____________________________________ +: Added AddRawSQL command to the DOTransaction +: Added ActiveFind and Delete to the DOCollection x: Fixed the BizBloxTests_.config (renamed to correct name in installer package) ____________________________________ 0.9.9.0 ____________________________________ !: Ready for a version step... updated, rebuilt and tidied all documentation +: Added foreign key 'order by' statement in SQLBuilder API ____________________________________ 0.9.8.3 ____________________________________ x: Found a memory leak in DOCollection. It has been changed to be iDisposable. This is a big deal - read below... !: From MSDN on iDisposable: It is a version breaking change to add the IDisposable interface to an existing class, as it changes the semantics of the class. !: All code using DOCollections must ensure they are DISPOSED! CG will not release the allocated resources effectively. I have added a call to dispose from the finalize() call to attempt to smooth any transitional problems with this symantic change - however be aware that these objects should be disposed of before finalization. ____________________________________ 0.9.8.2 ____________________________________ +: Added some raw SQL access methods to the DataAccess class which allow leveraging the BizBlox connection for plain old DataSets. This gets around some limitations where GroupBy and Distinct is unavailable in the SQLBuilder API. +: Improved documentation in DOTransaction and DOFactory ____________________________________ 0.9.8.1 ____________________________________ x: CPUID required elevated permissions to run in the ASP.Net user context so I have used a different hardware locking mechanism. BizBlox now creates a SHA1 Hash from the system name. !: If you have created encrypted connection strings with 0.9.8 they will need to be updated. !: If you change the name of the system (server) the connection string will have to be updated. ____________________________________ 0.9.8 ____________________________________ +: Added named connection strings to the config. You can now add Pixolut.BizBlox.EncryptedConnectionString.MyName and then use Pixolut.BizBlox.ActiveConnection="MyName" to set which string is to be used. +: Encryption uses HardwareID.CPUID to create the connection string. Example ASPX page which can be used to get the Hardware ID for the purpose of creating connection strings on hosted servers. !: Old encrypted connection strings must be RE-ENCRYPTED with the correct server's hardware ID. +: Added GetHardwareID.aspx to the API distribution directory. !: Run this ASPX page on the hosted server you intend to deploy on to get the HardwareID you require for the BizBlox encryption dialog. !: Removed enumerated connection strings as they proved too slow! Replaced with named connection strings. See unit test .config file for example. ____________________________________ 0.9.7 ____________________________________ +: Added enumerated connection strings to the config. You can now add Pixolut.BizBlox.EncryptedConnectionString.1 .. Pixolut.BizBlox.EncryptedConnectionString.9 to your config file for a set of database connection strings which will progressively fail over until the correct connection is found. !: This approach will slow the first request in an appDomain however connection string is cached for rapid performance after this. ____________________________________ 0.9.6.2 ____________________________________ +: Improved encryption UI x: Minor imports tool updates ____________________________________ 0.9.6 ____________________________________ +: Added secure connection string to DSNManager. See API docs for more info +: Added DSN encrypter dialog to the builder tool under the 'tools' menu. +: Updated unit tests +: Added verbosity configuration to DOException for security. Unset or false will suppress SQLexceptions and SQL source. ____________________________________ 0.9.4/5 ____________________________________ x: Bugfix in AcceptTO() to allow unset fields in the transfer object to not kill the creation process. +: More documentation +: Updated unit tests ____________________________________ 0.9.3 ____________________________________ +: Updated DOFactory to provide Update from TO method +: Added isolation level to DOTransactions (default to read committed) x: Updated documentation ____________________________________ 0.9.2 ____________________________________ x: Updated AcceptTO() behaviour to NOT override the existing UID of the DO which is accepting. +: Added Retrieve functions to the DOFactory +: Added DOFactory tests ____________________________________ 0.9.1 ____________________________________ x: Project save bug fixed ____________________________________ 0.9.0 ____________________________________ x: Remove DAO extension - amended the architectural approach to the usage of DAO/Business Objects +: Updated the project file format to R3 +: Updated the Builder tool to handle selective output +: Can output Transfer Objects based directly on SQL instead of independant script +: Added TOTests to test Suite ____________________________________ 0.8.0 ____________________________________ +: Added DOTO Class +: Added GetTO() and AcceptTO() to DataObject +: Added ToArray() to DOCollection +: Cleaned up the Inhertiance interface for DO's +: Updated the Builder tool to generate TOs and the new DO inhertiance. !: Old DO's need to be regenerated with the new Builder tool. !: Old VOs need to be updated to TOs to work with the TransferObject design pattern. ____________________________________ 0.7.2 ____________________________________ x: Builder would append VO to filename of Value Objects but not the class x: Assembly info of the unit tests was out of date ____________________________________ 0.7.1 ____________________________________ x: Updated the test suite x: Fixed null reference in BoundsCheck() under certain situations x: Fixed code injection bug with some legacy BizBlox code ____________________________________ 0.7.0 ____________________________________ +: Added BoundsCheck() method to setter properties and code generation +: Added GetBy method to code generation x: Completely overhauled the builder tool ____________________________________ 0.6.4 ____________________________________ x: SQLScript for the tests was out of date with the test suite being used. +: Added IsNull() function for dates and guids to allow recognition ____________________________________ 0.6.3 ____________________________________ x: Retrieve of a null GUID would cause invalid cast exception since GUID has no reference type, now fills the guid with an empty GUID (00000000-0000-0000-0000-000000000000). !: Note than the converse is also the case - a System.Guid of 00000000-0000-0000-0000-000000000000 will create a NULL in the SQL database; not a zero's guid. x: Fixed handling of all mapped NULL values from the database. +: Added test scenario for the NULL value retrieval issue. ____________________________________ 0.6.2 ____________________________________ x: Refactored SQLBuilder date query management to handle date datatypes instead of parsing arbitrary strings !: Code which uses date queries will need to be refactored to be in Date (DateTime) format. +: Added AddWhereNull to SQLBuilder; the change to overloading AddWhere to handle booleans and strings more precisely in 0.6.1 added the effect of making a NULL query impossible. Added this case to the tests... +: More tests added to the fixture. +: Updated the builder tool UI with new logo and icons. x: Improved null handling in DataObjects (in both directions) +: ++Performance in the handling of property reads - reduced the amount of reflection based calls. ____________________________________ 0.6.1 ____________________________________ +: Added nUnit framework with the release to demonstrate the code x: Refactored the complete transaction layer ++performance. x: Fixed many problems with dates and regionalisation x: Date typecast bug fixed +: Optimised DataAccess layer and the provider factory. The provider factory remains open ended to allow MySQL capabilities in the near future. +: Updated the Search Engine natural language searching. ____________________________________ 0.5.0 ____________________________________ x: Big problems with reflection in using the DataObject and DOCollection fixed +: Changed everything from 'string' based to using the columns enumerated type for referring to a column name when using the DOCollection classes. This allows you to retrieve them from autocomplete within the IDE. ____________________________________ 0.4.0 ____________________________________ +: Updated API to use an enumeration of column names for DataObjects instead of strings in the DOCollection +: Added versioning information to the generated code +: Updated the BizBloxBuilder to support the new code generation requirements +: Updated the installer to make VisualStudio display BizBlox in the references dialog +: Updated the installer to perform advanced .NET installation if not present. ____________________________________ 0.3.1 ____________________________________ x: Script output bug changed Integer to use System.Int32 +: Added script comments using the ; ____________________________________ 0.3 ____________________________________ +: Big UI update +: Added ability to script property objects +: More help - just use HELP! x: Changed internal variables of the business objects to use correctly types variables instead of variants. ____________________________________ 0.2 ____________________________________ +: Added Transactions +: Import Tool Loads and Saves projects (src and target path) ____________________________________ 0.1 ____________________________________ x: Found a problem with subclassing the DataObject - fixed +: UI updates and some SKELETON docs in the help of the SQL Import Tool ____________________________________ 0.0.1 ____________________________________ Intial release - no docs. uh oh. ___________________________________

  posted 436 days ago

• File released: /bizblox/BizBlox 1.6.2.0/BizBlox2.0-1_6_2_0.exe

  posted 436 days ago

• Code committed

  eorlingas committed revision 141 to the BizBlox ORM SVN repository, changing 3 files

  posted by eorlingas 483 days ago

• Code committed

  eorlingas committed revision 140 to the BizBlox ORM SVN repository, changing 6 files

  posted by eorlingas 512 days ago

• bizblox BizBlox 1.6.1.0 file released: BizBlox2.0-1_6_1_0.exe

  1.6.1.0 ____________________________________ +: Added implicit Find() call if Find() is not previously called on a DOCollection and an attempt is made to access an Object +: Change SqlBuilder Join methods to only add a Join to the query once, regardless of how often an attempt is made to add it. +: AddWhereIn() overloads, accepting arrays of strings and GUIDs +: AddWhere(), AddWhereGT(), AddWhereLT(), AddWhereGTE(), AddWhereLTE() overloads which allow comparison between columns in the query

  posted 514 days ago