UPDATE: A potentially serious bug was discovered in RC 1. It is now fixed, but please see this post if you downloaded either the installer or source code prior to 10:05 AM EST on June 5th.

Another release, another blog post... Man, I'm slacking...

We're pleased to announce the immediate availability of Release Candidate 1 of SubSonic 2.1. Nothing new or snazzy to announce in this build, just a good old pile of bug fixes for a code base that's looking pretty damn solid.

If you've been holding off on the 2.1 releases until things calmed down a bit, I urge you to finally take the plunge. This release is far more solid than the production 2.0.3 build. So dig in, and as always, keep the Work Items coming!

Download SubSonic 2.1 Release Candidate 1

Release Candidate 1 Fix/Feature List

Work Item 11506 - InvalidCastException When Using Nullable Boolean Types in MySql (Re-Opened)
Work Item 12946 - SQL Stored Procedures Don't Set Scale or Precision
Work Item 15073 - QuickTable Incorrectly Calculates Paging Values
Work Item 15074 - SQLiteDataProvider Paging is Off by One
Work Item 15075 - MySqlDataProvider Paging is Off by One
Work Item 15169 - MarkOld() Should Set IsLoaded="true"
Work Item 15844 - Wrong Database Object Name Generated in SqlQuery Select Clause When Using Table Joins
Work Item 16101 - MySqlInnoDBProvider - Alias Casings do not Match in MANY_TO_MANY_CHECK_ALL and MANY_TO_MANY_FOREIGN_MAP_ALL
Work Item 16110 - SqlQuery Aggregate Operations Inappropriately Replace WHERE with HAVING
Work Item 16165 - CS_ViewTemplate.ascx Does Not Escape SchemaName Setting
Work Item 16180 - Template Generated Code Wraps When "namespace" is Encountered Anywhere in Output
Work Item 16181 - QuickTable Improperly Qualifies Column Names When Where Clauses are Used
Work Item 16257 - VB_ClassTemplate.aspx Hasn't Been Updated to Reflect RepositoryRecord Changes
Work Item 16259 - ExecuteJoinedDataSet() Fails When Using an AddBetweenAnd Clause
Work Item 16326 - SqlQuery.Paged() Does Not Work With MySql Provider
Work Item 16392 - QuickTable Improperly Prefixes WHERE Clauses
Work Item 16424 - Nullable INT Values Not Properly Converted With Oracle Provider
Work Item 16429 - DB.Update() Does Not Set IsLoaded="true" (Duplicate)
Work Item 16463 - SqlQuery InnerJoin Results in Null Reference Exception When DataProvider is not Set
Work Item 16468 - DB.Update() Does Not Set IsLoaded="true"
Work Item 16513 - Empty or Null Lists Passed to Query.IN() Should Return No Results
Work Item 16532 - ExecuteSingle<T>() Leaves Open DataReader
Work Item 16547 - Where() Operations on Collections Do Not Support Comparision.In and Comparison.NotIn
Work Item 16548 - ExecuteJoinedDataSet() Improperly Performs JOINs on 1-to-1 PK/FK Relations
Work Item 16573 - DB.Update() Does Not Set IsLoaded="true" (Patch)
Work Item 16746 - SqlDataProvider/SqlCEProvider Incorrectly Translates VARCHAR Types to NVARCHAR
Work Item 16847 - DB.Insert(of T)(Row) Always Returns "0"
Work Item 16859 - Turkish Character-Set Issue in TableSchema.SetValue()
Work Item 16869 - Globalization Issues in SugarTests.Numbers_IsNumeric() and QueryTest.Query_OR_Between()
Work Item 16871 - Query Fails When Used With More Than One OrderBy Condition
Work Item 16874 - DataProvider.GetDbCommand() Doesn't Convert QueryParameter to DBParameter Before Adding to DBCommand Collection
Work Item 16894 - SQL Stored Procedures Don't Set Scale or Precision (Duplicate)
Work Item 16897 - Query.NOT_IN Is Not Handled Properly
Work Item 16898 - ExecuteJoinedDataSet Fails When Using IN/NotIN Clause
Work Item 12090 - Migration (Rails)
Work Item 16226 - 2.1 Feature Request: ExecuteAsSingle