SqlGenerators
(0 files, 0 lines)
[root]/SubSonic/Query2
SqlGenerators
(0 files, 0 lines)
| Author | Changes | Lines of Code | Lines per Change |
|---|---|---|---|
| Totals | 97 (100.0%) | 4150 (100.0%) | 42.7 |
| canofunk | 41 (42.3%) | 2506 (60.4%) | 61.1 |
| robconery | 38 (39.2%) | 1551 (37.4%) | 40.8 |
| shawn.oster | 4 (4.1%) | 93 (2.2%) | 23.2 |
| robconery@gmail.com | 14 (14.4%) | 0 (0.0%) | 0.0 |
moving 2.x source to 2.0 folder
0 lines of code changed in 14 files:
CHANGED: Swapped big if... then... else block in BuildSqlStatement with more efficient switch.
69 lines of code changed in 1 file:
ADDED: A few additional DataProvider overloads to SqlQuery constructors.
23 lines of code changed in 3 files:
FIXED: SqlQuery.And() and Or() were also affected by aggregate naming issue. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=15354
ADDED: Tests to validate that passing a single aggregate to SqlQuery methods works.
2 lines of code changed in 1 file:
CHANGED: SqlQuery generator classes are now broken out by type (all inheriting from ANSISqlGenerator).
ADDED: DataProviders - NamedProviderType property to allow for lightweight type identification (used by SqlQuery).
29 lines of code changed in 2 files:
FIXED: Where() with single Aggregate produces bad SQL. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=15354
22 lines of code changed in 2 files:
FIXED: Incorrect ProviderName when using Multiple Providers. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=15188
FIXED: SqlQuery Ignores non-Default DataProviders. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=15332
FIXED: BindingListEx Should be Marked as Serializable. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=15326
23 lines of code changed in 2 files:
CHANGED: SubSonic.Tests - Adjusted tests to align with current code and values from the default Northwind database (Thanks Shawn!)
CHANGED: SubSonic.Tests - Changed GeneratedCode folder structure and regenerated all classes
CHANGED: SubSonic - Refactored the way that QualifiedName properties are created to provide more consistent, fully qualified SQL generation
15 lines of code changed in 1 file:
FIXED: Global - Several issues with data type awareness. This should address several issues relating to the use of Scaffold, M2Ms, and SqlQuery commands with non-SQL Server providers.
23 lines of code changed in 3 files:
FIXED: Query2/Scaffold - Numerous cases of incorrect provider/provider type being set when working with multiple/heterogeneous providers.
FIXED: Scaffold - Incorrect handling of Boolean data types under MySQL.
FIXED: Scaffold - Better handling of FK values when FK table cannot be located.
FIXED: MySqlDataProvider - Unclosed connections (Thanks Shawn!)
15 lines of code changed in 4 files:
FIXED: SubSonic.RecordBase is not marked as serializable. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=15104
FIXED: VB AllStructs Template Patch. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=15203
FIXED: Bug/Error with /Query2/SQLQuery.cs : BuildTypedResult<T> : On Line 1328 : Rev 310. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=15197
2 lines of code changed in 2 files:
Disabled Migrations for beta
Added Shawn Oster's Aggregate tests
Fixed Stdev issue
Set LoadDropDown to take ListControl instead of DropDownList
7 lines of code changed in 1 file:
Added IEquatable to RepositoryRecord and ReadOnlyRecord
Updated SelectTests to include Shawn Oster's SQL NOT IN tests
12 lines of code changed in 2 files:
ADDED: Scaffold - New property, ScaffoldType. Default is "Normal", but when set to "Auto" will add AutoScaffold functionality, with drop downs that allow user to select a provider and table. Note: For the moment, AutoScaffold.aspx is still a separate entity, but very shortly will be move to use the standard Scaffold control with ScaffoldType set to Auto.
ADDED: Scaffold - New property, AutoGenerateManyToMany. Default is "true". If no tables are set in the property ManyToManyMap and AutoGenerateManyToMany is set to true, the scaffolds will automatically add M2M checkboxes in the bottom of the edit form for any related tables identified as part of generation-time identification of M2M objects.
ADDED: SqlQuery/Insert - Value(column, value) method which allows insert statements to be set individually rather than only as part of a entire array of all columns/values.
ADDED: Utility - New IsMappingTable() overload that takes only a TableSchema as parameter.
CHANGED: Scaffold - Largely rewritten, now uses SqlQuery rather than inline SQL, which should provide better support across providers.
CHANGED: Global - Eliminated the SubSonic.Controls namespace, which was housing only the WebUIHelper class.
CHANGED: Query/ExecuteJoinedDataSet - Method now automatically adds an additional independent PKValue field in column[0] if the first column is also a foreign key. This addresses an issue in current Scaffold funtionality that prevented successful direct editing of mapping tables that don't have independent PK values in as their first column.
CHANGED: SubStage - Improved toggling between Database View/Generated Object View so that tree is no longer fully rebuilt and current node expansion state is preserved.
CHANGED: SubStage - Re-enabled embedded web server and improved error handling.
45 lines of code changed in 1 file:
CHANGED: Minor variable name and documentation changes...
19 lines of code changed in 1 file:
ADDED: SubStage - Embedded Web Server
FIXED: Malformed SQL Generated for IsNull and IsNotNull Comparisons. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=14853
FIXED: Multiple Columns in One OrderBy are not Separated by Commas. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=14852
15 lines of code changed in 1 file:
CHANGED: SubStage - Refactored tree navigation code.
CHANGED: Multiple - Added comment stubs and headers to several new class files.
ADDED: SubStage - Connection string testing.
ADDED: SubSonicCentral - Base class configuration parameters to ConfigBuilder.
1322 lines of code changed in 10 files:
Restructured ActiveRecord Core to allow for Repository Pattern
Depricated AbstractRecord
Moved ActiveRecord to inherit from ReadOnlyRecord (with only change being the ability to Persist)
Added RepositoryRecord class
Added Repository functionality to Struct template (C# and VB)
Created initial CRUD test set for Repository
Added method to Utility to determine if a type is a SubSonicType (IsSubSonicType())
Fixed Shawn Oster's Neep bug :p
Added NorthwindRepos provider to test SetConfig
Fixed bug where ExecuteReader was firing twice
Added IRecordBase and IRepositoryRecord interfaces
39 lines of code changed in 2 files:
ADDED: New build configuration options: Release (SQL Server Only) and Debug (SQL Server Only). When enabled, project excludes other providers from compilation, creating a SubSonic.dll that can referenced without the inclusion of the other provider dll's.
4 lines of code changed in 1 file:
Updated VB Structs template to have Query factory
Tweaked Query factory bits in structs to use generics and enforce better coding (no strings)
Added generics to all Query bits. You can use this: Select.AllColumnsFrom<Northwind.Product>() and Insert().Into<Northwind.Product>(...) for type safety.
Updated Tests
Fixed MySQLInnoDB boolean set issue
50 lines of code changed in 3 files:
(7 more)