[root]/SubSonic.Tests/SqlQuery

| Author | Changes | Lines of Code | Lines per Change |
|---|---|---|---|
| Totals | 63 (100.0%) | 616 (100.0%) | 9.7 |
| canofunk | 36 (57.1%) | 244 (39.6%) | 6.7 |
| robconery@gmail.com | 18 (28.6%) | 231 (37.5%) | 12.8 |
| shawn.oster | 4 (6.3%) | 83 (13.5%) | 20.7 |
| adminjew | 2 (3.2%) | 30 (4.9%) | 15.0 |
| robconery | 3 (4.8%) | 28 (4.5%) | 9.3 |
moving 2.x source to 2.0 folder
0 lines of code changed in 9 files:
FIXED: "ScriptData incorrect for unicode columns" See: http://code.google.com/p/subsonicproject/issues/detail?id=64
FIXED: "IsOnline() always returns true" See: http://code.google.com/p/subsonicproject/issues/detail?id=70
FIXED: "2.2 Doesnt seem to support SQL Server 2008 DateTime2 and Date" See: http://code.google.com/p/subsonicproject/issues/detail?id=74
FIXED: "In(...) and NotIn(...) throw "Failed to convert parameter value from a String to a ..." exception" See: http://code.google.com/p/subsonicproject/issues/detail?id=76
FIXED: "Using GetRecordCount() with DISTINCT and OrderBy" See: http://code.google.com/p/subsonicproject/issues/detail?id=78
FIXED: SQL Server 2008 SP1 Incorrectly Identified as SQL 2000.
FIXED: Build configuration issues and SubSonicCentral assembly references.
ADDED: "Get a cookie's subvalue" See: http://code.google.com/p/subsonicproject/issues/detail?id=72
CHANGED: SubStage forums tab now points to stackoverflow.com.
14 lines of code changed in 1 file:
FIXED: Google Issue 49 - using string value "null" sends NULL to the db. For reference - this was a requested enhancement and could be a breaking change.
38 lines of code changed in 1 file:
FIXED: Google Issue 36 - Paging doesn't work with SqlQuery and requires Select(). Patch applied from Jim Zimmerman (thanks dude!)
20 lines of code changed in 1 file:
FIXED: Google Issue 31 - Where Expression not formatting correctly with qualified column name
19 lines of code changed in 1 file:
FIXED: Google issue 59 - Rob broke the build; DB.Get<T> was failing.
15 lines of code changed in 1 file:
FIXED: Google issue 17 - LoadByParam would not set IsLoaded to false when no record present
10 lines of code changed in 1 file:
FIXED: Google issue 20 - if item not found in SubSonicRepository an empty object is returned (instead of null)
16 lines of code changed in 1 file:
FIXED: Codeplex 17617 - Added patch for Distinct Query values - thanks to GeoffAtDataGaard
FIXED: Patch applied from Jason Kealey for composite Primary Keys (Google issue 3)
FIXED: Patch applied from boyank for Scaffolding and composite keys (Google issue 9)
FIXED: Google issue 12 (Migration column/numberscale for decimals) - thanks to robbam
FIXED: Google issue 14 (Migration max length for char/non-int PKs) - thanks to robbam
ADDED: Initial rev of ActiveRecord T4 templates
REMOVED: Substage project - will added as "extra"
REMOVED: SubSonicCentral web site. Will add as "extra"
74 lines of code changed in 2 files:
Fixing error in last commit. Used Auto-Property instead of property with backing store so that it can build with the .NET 2.0 compiler
7 lines of code changed in 1 file:
Adding Distinct() to SqlQuery
23 lines of code changed in 1 file:
FIXED: SetColumnValue() Assigns CurrentValue System.DBNull Instead of "NULL". See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=14998
FIXED: Oracle Stored Procedure Output Parameters are not Properly Prefixed. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=18100
FIXED: GetSPSchemaCollection() Attempts to Assign Invalid Stored Procedure Schema Value Under Oracle Provider. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17986
FIXED: GetSPSchemaCollection() Attempts to Assign Invalid Stored Procedure Schema Value Under Oracle Provider (Second Report). See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17909
FIXED: Invalid SQL May be Generated When Attempting to Update a Record Where Values Have Not Changed. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=16626
FIXED: Invalid SQL May be Generated When Attempting to Update a Record Where Values Have Not Changed (Second Report). See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17866
13 lines of code changed in 1 file:
Added "StartsWith", "EndsWith", and "ContainsString" to augment LIKE statements.
Added Virtual Method on DataProvider called GetWildCar(), which defaults to returning a "%"
No overrides specified for other providers - each uses "%"
39 lines of code changed in 1 file:
FIXED: Aggregates With Where (Not Having) Creates bad SQL (testcase included). See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=16936
FIXED: Aggregates With Where (Not Having) Creates bad SQL (testcase included) - Updated Patch. (Thanks Geoff!) See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17245
FIXED: SqlDataProvider.GetSelectSql() - ORDER BY Columns Must be in SelectList When IsDistinct=true. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=11763
FIXED: ANSISqlGenerator.PAGING_SQL Contains Incorrect Paging Definition. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17075
24 lines of code changed in 1 file:
CHANGED: Global code clean up and reformatting
CHANGED: Updated System.Data.SQLite.DLL to 1.0.51.0
150 lines of code changed in 8 files:
CHANGED: Global update to many method signatures to improve automatic documentation.
21 lines of code changed in 1 file:
FIXED: SqlQuery.Paged() Does Not Work With MySql Provider. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=16326
FIXED: SQLiteDataProvider Paging is Off by One. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=15074
FIXED: MySqlDataProvider Paging is Off by One. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=15075
FIXED: ExecuteJoinedDataSet() Fails When Using an AddBetweenAnd Clause. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=16259
FIXED: SqlQuery InnerJoin Results in Null Reference Exception When DataProvider is not Set. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=16463
15 lines of code changed in 1 file:
Added ExecuteAsSingle<> to Select() (thanks to rimsystems for the idea)
8 lines of code changed in 1 file:
Added overload to the Select() constructor to take typed columns for safe column names. For example, you can use this query:
"Select(Northwind.Product.ProductIDColumn, Northwind.Product.ProductNameColumn).From<Northwind.Product>()"
To be sure that you have properly qualified column names.
7 lines of code changed in 1 file:
FIXED: Global - Several issues related to handling of non-standard column names, such as those with, uh, parentheses (ouch),
1 lines of code changed in 1 file:
(10 more)