[root]/SubSonic/SqlQuery
SqlGenerators
(0 files, 0 lines)

| Author | Changes | Lines of Code | Lines per Change |
|---|---|---|---|
| Totals | 135 (100.0%) | 1809 (100.0%) | 13.4 |
| canofunk | 79 (58.5%) | 1428 (78.9%) | 18.0 |
| robconery@gmail.com | 29 (21.5%) | 217 (12.0%) | 7.4 |
| robconery | 5 (3.7%) | 137 (7.6%) | 27.4 |
| adminjew | 2 (1.5%) | 15 (0.8%) | 7.5 |
| shawn.oster | 20 (14.8%) | 12 (0.7%) | 0.6 |
moving 2.x source to 2.0 folder
0 lines of code changed in 11 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.
5 lines of code changed in 2 files:
FIXED: SqlQuery - ANSISqlGenerator added duplicate DISCTINCT values resulting in malformed queries.
FIXED: SubStage - Slow performance with mapped network drives. Excluded network drives from SubStage file navigator. This greatly improves performance for some users.
FIXED: Test Data - Updated scripts to correctly reflect object dependencies and prevent errors on execution.
ADDED: Re-added SubSonicCentral and SubStage projects.
ADDED: SubSonic.Tests - Added missing SouthwindRepository generated files.
UPDATED: ComponentFactory.Krypton.Toolkit.dll, MbUnit.Framework.dll, MySql.Data.dll, QuickGraph.dll, QuickGraph.Algorithms.dll, Refly.dll, TestFu.dll
UPDATED: Global - Assembly versions changed to 2.2.1.0
CHANGED: Global - AutoProperties now used where possible.
CHANGED: Global - Object initializers now used where possible.
REMOVED: Sandbox Project
271 lines of code changed in 7 files:
FIXED: Google Issue 50 - boolean translation error with MySQL. Updates default to DbType.AnsiString when only a columnName is passed. This was default behavior for IsDeleted. Changed to lookup column in FromTables which solved this and I'm sure other issues.
9 lines of code changed in 1 file:
FIXED: Google Issue 28 - ExecuteJoinedDataSet parameters incorrectly set
1 lines of code changed in 1 file:
FIXED: Google issue 29 - using IN with Aggregates cause error
6 lines of code changed in 1 file:
Added Oracle Patch from runxc1
Fixes join and column issues
20 lines of code changed in 2 files:
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"
22 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
8 lines of code changed in 1 file:
Adding Distinct() to SqlQuery
7 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
10 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 "%"
44 lines of code changed in 1 file:
FIXED: AddParams() Does Not Set Stored Procedure Parameter Precision Value (Report #1). See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17428
FIXED: AddParams() Does Not Set Stored Procedure Parameter Precision Value (Report #2). See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17699
FIXED: SqlQuery.GetRecordCount() May Return "Specified Cast is not Valid". See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17813
FIXED: Query.SetSelectList Method Documentation Should Indicate Format of Parameter. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17584
FIXED: Generated VB Classes Do Not Properly Bind. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17723
FIXED: MySqlGenerator.SqlQuery.Paged() Generates Invalid SQL. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17687
1 lines of code changed in 1 file:
FIXED: SqlQuery.Select.Top() Generates Malformed SQL. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17546 and http://code.google.com/p/subsonicproject/issues/detail?id=24
FIXED: ANSISqlGenerator.BuildConstraintSQL() May Improperly Reuse Parameter Name. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17530
FIXED: ANSISqlGenerator.BuildConstraintSQL() May Not Correctly Set Parameter Type. See: http://code.google.com/p/subsonicproject/issues/detail?id=22
2 lines of code changed in 2 files:
FIXED: DropDown.Where Property is not Correctly Set. See: http://code.google.com/p/subsonicproject/issues/detail?id=6
FIXED: SqlQuery Does Not Properly Set ProviderName Property. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17435
FIXED: Generated Struct Members Should be Marked "readonly". See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17424 and http://code.google.com/p/subsonicproject/issues/detail?id=11
FIXED: AssemblyInfo.cs version issue introduced in revision 473 (Thanks Adam!)
CHANGED: MySql.Data.dll updated to version 5.2
CHANGED: System.Data.SQLite.DLL updated to version 1.0.52
CHANGED: EnterpriseLibrary assemblies updated to version 4.0
REMOVED: Old and unreferenced assemblies.
10 lines of code changed in 1 file:
FIXED: StoredProcedure.QueryCommand is not Properly Initialized. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17342
FIXED: Turkish Culture Issues in SqlQuery Aggregate Generation. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17356
FIXED: ManyManyList Controls do not Properly Set Checkbox State. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=12068
FIXED: LavaBlastManyManyList.BuildMappedElementCommand() Generates Improper SQL. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17361
CHANGED: Fixed minor code documentation issues.
CHANGED: Added signing to SubSonic.Migrations.
CHANGED: Minor changes to build configuration.
CHANGED: Updated help file builder configuration.
CHANGED: Updated assembly build versions to 2.1.1
2 lines of code changed in 1 file:
ADDED: Some basic release info to SubSonicCentral/Default.aspx
CHANGED: Added SubSonic.Migrations to SandCastle Help File Builder. Removed SubSonic.SubCommander.
FIXED: Namespace Parsing Error in CodeRunner.GetTypeName(). See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17264
FIXED: DB.Update() Doesn't Allow Multiple SETs. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=15768
1 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
2 lines of code changed in 1 file:
FIXED: DB.Save() Doesn't Insert Records if the PrimaryKey is not AutoIncrement. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17008
FIXED: DB.Save() Doesn't Insert Records When Primary Key is UNIQUEIDENTIFIER. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17187
FIXED: SubStage Doesn't Save Generated Code Language. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17041
ADDED: Patch for Improved Implementation of SqlQuery.GetRecordCount(). See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=17157
16 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
422 lines of code changed in 11 files:
(42 more)