2022-03-24

.NET 6 version

2021-07-08

• Download .NET 5. installer (Windows x64) from https://dotnet.microsoft.com/download/dotnet/thank-you/sdk-5.0.301-windows-x64-installer
• This is the first pre-release of the .NET 5 version
• Use Odp provider instead of OracleClient provider

v1.0.2

• Updating to version 1.0.2
• Updating nuget packages
• Fixing token iterator
• db request builder nullable parameters
• SegmentLinkedList
• extended stored procedures
• Eliminating GC monitor error
• Memory optimized read only list
• Collection extension methods
• Handling 'cancel command' exceptions
• Solving 'TKey = int' problem
• Retry pattern (experimental, similar to Polly)
• Updating SQL Server versions
• db query builder varchar(max), nvarchar(max)
• db query builder AddChar
• db query builder: handling size of nvarchar input parameters
• db query builder AddString (SQL NULL instead of default)
• Removing unused IProvider method ExecuteXmlReader
• Table editor: stringly typed table schema instead of DataSet
• Table editor: stringly typed table schema instead of DataSet
• Fixing undo/redo
• Undo/redo function (experimental)
• Fixing text box event handlers
• Replacing tab to 4 spaces before decreasing line indent
• Cleaning code
• Create C# Command/Query
• Fixed: QueryForm does not work in design mode
• TakeRanges extensions method
• Fixing DataSetResultWriter tableIndex
• ConnectionProperties repository
• ReadOnlyList enhancements for empty lists
• Adding SQL Server 2017
• Fixing Progress class
• Update README.md
• Indenting multiple lines
• Fixing SequenceCompare method
• Fixing single row reader
• IDataRecord extensions
• SqlStatementExtensions
• table node insert script generator moving commands to the end of the line
• Fixning db query builder
• join strings extension method
• CamelCase -> CamelHumps
• Preferring non-identity unique indexes in DataTableEditor for generating update/delete SQL scripts
• Faster startup with less frequent update checking
• How to build
• Exception handling in ExecuteNonQuery method
• JSON.NET friendly ReadOnlyList
• Refining command execution log messages
• Fixing log reader config namespace
• Upgrading to .NET Framework 4.7.2
• ReadOnly collections
• Progress class
• Providers solution folder
• Code cleanup
• Eliminating FoundationContract
• Eliminating FoundationContract references
• Moving readme
• Rolling back to prefixed assembly names
• Refactoring solution, code cleanup
• Refactoring solution
• Adjusting assembly boundaries
• Removing unused references
• Adjusting namespaces
• Rafactoring namespaces
• Removing unused dependencies
• Assertions -> Core
• Renaming Foundation project directories
• Removing empty xml comments
• Refactoring DotNetFrameworkVersionStore
• SQLite was ignored
• Adding missing files
• Drag & Drop file name from Visual Studio
  Refactoring directory structure (Isolating DataCommander and Foundation)
• DateRange
• DbRequestBuilder: xml parameter
• SqlParameterFactory
• namespace Foundation.Collections.ReadOnly
• Usings
• ReadOnlyCollection -> ReadOnlyList
• ReadOnlyCollection -> ReadOnlyList
• ReadOnlySortedList
• ReadOnlyList, ReadOnlyDIctionary
• IReadOnlySortedSet
• ReadOnlySortedSetArray
• ReadOnlySortedSet
• GetAppLock
• ThreadMonitor
• SortedArray
• Cleaning using sections
• Cleaning SmallDate, SmallDateInterval, SmallTime, adding MinuteSpan
• Adding Empty collections
• Fixing 'no column name' bug in db query builder
• Enhancing AppDomainMonitor assembly info with IsDynamic property
• GetDotNetFrameworkVersion, 4.7.2
• Moving font selection menu item into Options dialog.
• Fixing options menu item click event handler
• Changing default size of forms
• Fixing form designer auto property issue
• IQueryForm: reducing dependencies
• Moving ISerializer to Core
• Moving Foundation classes to Linq
• Moving Foundation classes to Core
• Removing redundant type specifications
• Removing unused usings
• Enhancing AppDomainMonitor WindowsVersionInfo
• Fixing logging configuration
• Separating Foundation assembly into multiple assemblies
• Isolating Foundation.Data assembly
• Moving MethodProfiler from Diagnostics into Data
• Isolating Foundation.Depoyment assembly
• Automatic Update
• Fixing updater bugs
• Query builder
• DbRequestBuilder
• Command/Query Builder
• Enhancing Query builder parameter handling (automatic SQL parsing instead of manual json configuration)
• Enhancing DbQueryParameter

v1.0.1

• Updating nuget packages
• How to build
• Exception handling in ExecuteNonQuery method
• JSON.NET friendly ReadOnlyList
• Refining command execution log messages
• Fixing log reader config namespace
• Upgrading to .NET Framework 4.7.2
• ReadOnly collections
• Progress class
• Providers solution folder
• Code cleanup
• Eliminating FoundationContract
• Eliminating FoundationContract references
• Moving readme
• Refactoring solution, code cleanup
• Adjusting assembly boundaries
• Removing unused references
• Removing unused dependencies
• Assertions -> Core
• Renaming Foundation project directories
• Removing empty xml comments
• Refactoring DotNetFrameworkVersionStore
• Drag & Drop file name from Visual Studio
• Refactoring directory structure (Isolating DataCommander and Foundation)
• DateRange
• DbRequestBuilder: xml parameter
• SqlParameterFactory
• namespace Foundation.Collections.ReadOnly
• ReadOnlyCollection -> ReadOnlyList
• ReadOnlySortedList
• Update README.md
• ReadOnlyList, ReadOnlyDictionary
• IReadOnlySortedSet
• ReadOnlySortedSetArray
• ReadOnlySortedSet
• GetAppLock
• ThreadMonitor
• SortedArray
• Cleaning SmallDate, SmallDateInterval, SmallTime, adding MinuteSpan
• Adding Empty collections
• Fixing 'no column name' bug in db query builder
• Enhancing AppDomainMonitor assembly info with IsDynamic property
• GetDotNetFrameworkVersion, 4.7.2
• Moving font selection menu item into Options dialog.
• Fixing options menu item click event handler
• Changing default size of forms
• Fixing form designer auto property issue
• IQueryForm: reducing dependencies
• Moving ISerializer to Core
• Moving Foundation classes to Linq
• Moving Foundation classes to Core
• Removing redundant type specifications
• Removing unused usings
• Enhancing AppDomainMonitor WindowsVersionInfo
• Fixing logging configuration
• Separating Foundation assembly into multiple assemblies
• Isolating Foundation.Data assembly
• Moving MethodProfiler from Diagnostics into Data
• Isolating Foundation.Depoyment assembly
• Automatic Update
• Fixing updater bugs
• Query builder
• DbRequestBuilder
• Command/Query Builder
• Enhancing Query builder parameter handling (automatic SQL parsing instead of manual json configuration)
• Enhancing DbQueryParameter
• Creating Options dialog, moving color theme to options dialog
• New version checking
• Fixing ORM parameter parsing bug
• Enhancing SqlParser
• ElementPair
• Isolating Log and DefaultLog and InternalLog
• InternalLogFactory
• XmlSerialization
• Displaying query result name in query result tab page header
• Migrating to .NET Standard 2.0

2018-04-13

• Target framework: 4.7.1
• Adding DataCommander.Providers.Tfs-15.0.0.0
• Adding Windows version info to about form
• Updating year from 2017 to 2018 in assembly info files and "about" message.
• Updating nuget packages
• Removing code contracts
• Refactoring IAsyncDataAdapter: BeginFill -> ctor + Start
• GCSettings logging
• Cleaning code

.NET Standard 2.0

• Migrating Foundation assembly to .NET Standard 2.0
• packages.config -> PackageReference

ORM

• Displaying query result name in query result tab page header
• Enhancing DbQueryBuilder header with Using
• Enhancing DbQueryBuilder parameters
• Enhancing OrmBuilder with JSON header info
• Extracting ValueReader class from Database class
• Removing obsolete data access classes
• Migrating to new data access classes
• Adding transaction handling to CreateCommandRequest and ExecuteReaderRequest
• IDataReader extensions

Foundation

• DbColumn -> FoundationDbColumn
• DateTimeConstants
• ReadOnlyArray
• EmptyEnumerable
• CQRS, Domain-driven design (experimental)
• SmallDate enhancements
• Cleaning ThreadMonitor
• TemporalIntervalRelations (experimental)
• Do not append unnecessary spaces to the end of last column of string table

2017-05-28

• IMPORTANT: DataCommander.Foundation assembly has been renamed to Foundation. After upgrading to this release the DataCommander.Foundation.Configuration element must be renamed to Foundation.Configuration in the %AppData%\Roaming\Data Commander\ApplicationData.xml file.
• IMPORTANT: SqlServer2005 provider has benn renamed to SqlServer. After upgrading to this release SqlServer2005 must be replaced in the the %AppData%\Roaming\Data Commander\ApplicationData.xml file.
• ORM: building POCO classes and Read methods. See them in the log file (%TEMP%\DataCommander*.log).
• Color themes: Dark color theme is the default. The light color theme can be enabled in the App.config file.
• References: SQL Server and TFS shared assemblies are necessary for building the application. Unpack the attached References.7z to the root folder of the repository.

2017-04-10

• Upgrading to Visual Studio 2017
• Disabling code contracts with #if
• Using var
• Upgrading to .NET Framework v4.6.2

2017-02-28

• Drag and drop file content as hex string

2016-11-11

• Upgrading projects to .NET 4.6.2
• Fixing code completion after = operator
• Increasing ShortStringSize in App.config
• Fixing AboutForm
• Fixing DbColumn

2016-05-31

• Fixing SegmentedCollection GetEnumerator bug
• Extremum class
• Fixing TfsDataReader schema table
• Cleaning code
• Enhancing FoundationContract
• Fixing DbColumn