DataCommander

.NET 6 version

• 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

• 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

• 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

• 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

• 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.

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

• Drag and drop file content as hex string

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

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

• Changing naming convention: data source -> database
• Enhancing PostgreSQL provider (object explorer, code completion)
• Reading .NET framework version from registry
• Updating assembly info to 2016
• StringTable.ToString(): newline is not necessary after the last line

• Enhancing connection string handling with IDbConnectionStringBuilder
• Enhancing PostgreSQL provider (object explorer, code completion)
• AsyncDataAdapter field count
• Selection -> TypeDictionary + switch
• Cleaning code
• Adjusting namespaces
• C# 6.0: expression bodied properties

• Updating nuget packages
• PreOrderTreeTraversal
• Fixing navigation to results after 'schema only' execution
• LogResultWriter: adding logging of schema table
• Fixing navigation to results after singe row execution
• Mouse middle button closes resultset tab page

• Moving input paramerer of IResultWriter.BeforeExecureReader to IResultWriter.Begin
• Executing command from line
• Fixing endFill, writeEnd callback handling
• Changing order of tab pages from (Messages, Results) to (Results, Messages)
• Enhancing text result writer tabpage
• OpenAsync

• FOUNDATION_4_6
• Using ReadOnlyCollection
• Fixing ReadOnlySortedList
• Enhancing SQL messages
• BinarySearch
• Removing workingset from AboutForm
• Upgrading nuget packages
• Target framework in AboutForm
• Performance tuning
• Upgrading to .NET Framework 4.6
• C# 6.0
• Showing managed memory on main form status bar
• IfNotNull for structs
• Eliminating compiler warnings
• Cleaning code
• Removing obsolete ExecuteReader methods
• SystemTime -> UniversalTime
• DateTimeKind in logging
• IDateTimeProvider
• EmptyArray
• GetValueOrDefault -> IfNotNull
• Updating Visual Studio version in AboutForm
• StringBuilderReader

• IndexOfExtremum method
• Enhancing SqlError.ToLogString method
• Fixing scripting of SqlServer2005 triggers
• Cleaning code
• Fixing minor bugs
• Fixing SQL Server view select statement
• SQL Server version info
• Upgrading nuget packages
• Tfs-14.0.0.0 provider
• string interpolation
• Fixing log file per day
• Fixing code completion bug
• Fixing hex string in insert script

• Fixing AboutForm log file
• Fixing memory status logging
• Fixing AboutForm bug
• Logging memory and GC status
• Enhancing log file
• IDateTimeProvider
• Removing LazyCollection, LazyList
• Removing WorkerThread.Current
• Fixing timer rowcount bug
• Merge branch 'SQLite' into Experimental
• Fixing timer rowcount bug
• IDateTimeProvider
• Enhancing memory management by enhancing AsyncLogFile with ConcurrentQueue
• Enhancing memory management by disposing objects
• Immutable
• SegmentedArrayBuilder
• Binary search
• ReadOnlyNonUniqueSortedList
• EmptyReadOnlyList
• ReferenceEquals
• Sorting csproj itemgroup compile items
• Fixing SelectPreviousAndCurrent
• Cleaning solution
• LinearSearch.IndexOf method
• Renaminig to ReadOnlyNonUniqueSortedList
• PreviousAndCurrent
• Fixing SQL Server nvarchar column length issue
• Cleaning code
• Refining binary search
• SQL Server version description
• Speeding up Data Commander startup
• Code analysis
• Open SQL script file
• Adding WaitCursor to connection open
• Removing Ctrl+Alt+S hotkey
• Adding PreviousAndCurrentItem extension method
• Fixing TFS provider default parameter handling
• Adding SegmentedListBuilder
• Adding ReadOnlyListSegment
• Adding ReadOnlySortedList class
• FIXED: Ctrl+F4 does not close the MDI child window.
• Fixing DataReader

• Implementing IDataRecordExtensions...
• Implementing DataReader...
• Removing obsolete methods
• Implementing IDbTransactionScope...
• ConnectionDefinition
• Implementing DataReader...
• How to log CallerInformation
• Implementing PostgreSQL provider...

• Implementing MySQL provider
• Fixing data source column in connection form
• Updating nuget packages
• Updating SQL Servers versions
• Fixing code contracts settings of Tfs-11.0.0.0 provider.
• Removing Ctrl+H shortcut key
• Fixing datetime format in InsertScriptFileWriter
• Renaming 'database' to 'data source' in menu items
• Fixing 'Create insert statements' method
• AccessViolationException on ToolTip that faults COMCTL32.dll - .NET 4.0

Adding Tfs-11.0.0.0 provider