ADDED: SubStage - Internal scaffold support
463 lines of code changed in 7 files:
ADDED: Scaffold - New property: "UseEmbeddedStyles". When enabled (disabled by default) will emit a dynamic CSS at runtime that results in a more visually refined appearance for the scaffolds.
ADDED: Scaffold - New configurable CSS attributes, "DropDownCssClass" and "CheckBoxCssClass";
177 lines of code changed in 5 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.
972 lines of code changed in 17 files:
ADDED: SqlQuery - Support for multiple set operations in a single update query.
13 lines of code changed in 1 file:
CHANGED: Minor variable name and documentation changes...
94 lines of code changed in 7 files:
FIXED: SubStage - Crash on application exit.
CHANGED: SubStage - Set project to not use the Visual Studio hosting process.
5 lines of code changed in 2 files:
FIXED: OracleDataProvider - GetSelectSql() in OracleDataProvider Generates Invalid SQL. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=14887
CHANGED: Eliminated SubSonic.CodeGenerator namespace.
CHANGED: Minor performance optimizations to code generation template cleaning methods.
965 lines of code changed in 20 files:
ADDED: SubStage - Option to generate classes in VB.
ADDED: SubStage - Log window.
ADDED: SubStage - Description for provider properties.
FIXED: Issue with template generation in certain non-Western European language scenarios. See: http://forums.subsonicproject.com/forums/p/2506/10778.aspx#10778
CHANGED: Calendar Control - Potentially objectionable variable names.
591 lines of code changed in 12 files:
FIXED: VB.NET Templates - Several issues that resulted non-compiling classes being generated.
149 lines of code changed in 4 files:
CHANGED: When no primary key exists on the source table, ActiveRecord and Controller templates now output an inline comment indicating this condition.
438 lines of code changed in 6 files:
ADDED: SubStage - Support for SQLExpress attached database connection strings.
229 lines of code changed in 4 files:
FIXED: SubStage - Problem importing existing project if connection string did not already exist in the repository.
FIXED: QueryCommand - Provider neutrality issue with RETURN_VALUE parameter.
FIXED: GeneratedScaffoldCodeBehind templates - Class name not properly displayed when saving records.
CHANGED: QueryCommand - Improved performance of a parameter iterations.
42 lines of code changed in 5 files:
FIXED: Configuration issue in SubSonic.Tests.csproj that prevented MySql tests from building
2 lines of code changed in 1 file:
FIXED: Error in Oracle SP_SQL Code. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=9875
1 lines of code changed in 1 file:
ADDED: IsCreditCardAny unit test (Thanks Shawn!) See: http://forums.subsonicproject.com/forums/p/2492/10692.aspx#10692
35 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
1013 lines of code changed in 10 files:
Added contributions for tests
68 lines of code changed in 5 files:
CHANGED: SubStage - Importing Projects now scans existing connection strings in SubStage repository, and if it finds one with the same name and connection string value, and will use it rather than importing a duplicate from the config file.
18 lines of code changed in 1 file:
CHANGED: TableSchema - HasForeignKeys is now a property instead of a method
ADDED: TableSchema - HasPrimaryKey method.
ADDED: SubStage - Implemented property display pages for generated classes on Tables/Views (Classes) Columns(Properties) and Stored Procedures (including parameters).
ADDED: SubStage - Option to view the hierarchy of generated objects by either their generated class/property name.
CHANGED: Fixed Copyright date on the help project file.
727 lines of code changed in 6 files:
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.
3375 lines of code changed in 50 files:
ADDED: Code generation capabilities to SubStage.
429 lines of code changed in 4 files:
Set the repository class to partial
1 lines of code changed in 1 file:
Fixed Interface warnings and regenerated Test Bits
40 lines of code changed in 3 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
2157 lines of code changed in 27 files:
ADDED: Visual improvements to SubStage and other minor changes
617 lines of code changed in 7 files:
ADDED: MySQL Provider Enhancements. (Thanks ncichris!). See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=14758
167 lines of code changed in 4 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.
121 lines of code changed in 10 files:
FIXED: Under certain conditions, bad update SQL was generated if table contained ModifiedBy or ModifiedOn columns
102 lines of code changed in 3 files:
ADDED: SubStage can now import existing SubSonic Web.Config and App.Config files into the repository.
305 lines of code changed in 3 files:
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
155 lines of code changed in 13 files:
ADDED: SubStage now Invokes Providers and loads up trees of Tables, Views, and SPs
303 lines of code changed in 5 files:
ADDED: Configuration builder capabilities to SubStage
461 lines of code changed in 3 files:
CHANGED: More SubStage Enhancements
633 lines of code changed in 7 files:
CHANGED: More SubStage Stuff
476 lines of code changed in 6 files:
FIXED: Errors in VB_ClassTemplate. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=14724
3 lines of code changed in 1 file:
FIXED: Errors in SubStage repository file that caused crashes at launch.
62 lines of code changed in 1 file:
CHANGED: More progress on SubStage
CHANGED: Minor configuration changes to Help generator project file...
667 lines of code changed in 12 files:
CHANGED: More additions to SubStage shell.
437 lines of code changed in 9 files:
Fixed solution file.
1 lines of code changed in 1 file:
CHANGED: More work on SubStage.
ADDED: Reflection based Singleton class to SubSonic project (used by SubStage)
6144 lines of code changed in 20 files:
CHANGED: Excluded missing CodeRunner.cs which was preventing successful builds of SubCommander
ADDED: SubStage UI shell. More on this later....
328 lines of code changed in 14 files:
fixed transaxtion bug
25 lines of code changed in 1 file:
Added Select() for In and NotIn
Segregated tests for clarity
Added From<> for typed expressions
Added Query factory methods to CS_Structs Template (need to update VB as well)
Fixed SP templates (VB and C#) to include schema names
527 lines of code changed in 33 files:
FIXED: Many unit tests
FIXED: CROSS JOIN syntax issue in Query2
CHANGED: Updated Northwind build schemas to support unit test changes.
CHANGED: Unit tests now assume MySql user 'subsonic' for access to the Northwind database (instead of root)
CHANGED: Code reformatting for Query2
1332 lines of code changed in 18 files:
Tweaked Sugar/Strings.cs to properly return words based on spaces, not commas
Added InlineQuery to new Query tool - useful for excuting raw SQL.
Update Joins to use every join type
287 lines of code changed in 5 files:
Re-added Generated test bits using Northwind and Southwind (northwind for MySQL)
Added in tests for new query engine
86 lines of code changed in 2 files:
added InlineQuery, Delete
91 lines of code changed in 4 files:
changed project settings
7 lines of code changed in 1 file:
17 lines of code changed in 1 file:
Added method to TableSchema to return a delimited column list
28 lines of code changed in 1 file:
Added Insert and Update to new query bits
Refactored a ton
495 lines of code changed in 10 files:
CHANGED: Updated Copyright Date
FIXED: Minor XHTML compliance issue in SSC MasterPage.master
3 lines of code changed in 2 files:
Adding in first checkin of new query tool (tests to follow)
Added Object overrides for TableSchema
Added IAbstractList.cs
Added ParseAndRunSqlCommand to Query
Added ParseAndRunSqlFile to Query (for large scripts)
605 lines of code changed in 19 files:
FIXED: Record.Save() Should not Save Non-Dirty Fields when Updating (Re-Open). See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=14187
FIXED: StoredProcedure.CommandTimeout Value is Ignored. See: http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=11766
CHANGED: Obsoleted several methods in Utility.cs.
77 lines of code changed in 3 files: