v6.0.0

Changes:

• 14eff9b Merge pull request #171 from MarkMpn/variables
• ae85952 Added support for CommandBehavior flags in ExecuteReader
• d2bd398 Fixed clicking drop-down section of Convert button
• e90d7d3 Fixed bug using parameters in UPDATE SET clause
• 6c787b2 Fix bug with IN conditions
• 5c3134c Fold conditional query for IF/WHILE statements
• d3dcb8e Fixed setting parent after removing alias node
• 2b38105 Show join type in execution plan
• 43c0c5f Remove AliasNode from DML queries
• aefa5a6 Updated release notes

See More

• 58fef1f Added RuntimeIdentifiers
• c169be0 Standardise on .NET Framework 4.7.2
• 0067644 Restore packages on build
• 4bbf769 Updated README
• ac77b8d Prompt to save files before closing [ #157 ]
• 4a480df Fixed TDS Endpoint tests
• 32c4f21 Improved IN query folding
• 5983b11 Fixed case sensitivity on UPDATE statements
• aeac934 Generated plan is now never null
• dd1760a Show better name for selected node in SSMS properties window
• 2d248ec Use actual list of tables from TDS Endpoint to determine compatibility
• 3fbce8d Cache invalid entity names as well as valid details
• b7f582b Refactored connecting to TDS Endpoint to reusable method
• 8cbc579 Improved GetBytes/GetChars support
• 754a2ff Dataverse client update compatibility
• 05ec9cd Refactored Application Insights
• d77bd77 Keep Sql4CdsConnection open for each tab to preserve global variable values
• 43fe8b7 Preserve global variable values between multiple commands
• eaab8e6 Support folding queries using @@IDENTITY
• 9c805a9 Hide SourceExpression property from property grid
• e264d59 Simplified API for using multiple connections
• d748b0b More highlighting changes
• 1a0e942 Highlighting is hard
• 49d0bc9 GitHub highlighting test
• 254fffe Added note on use of supported APIs
• ed7e9c9 Fixed displaying null SqlEntityReference values
• 29d5969 Fixed error loading long string values into DataTable
• 16e61bd Handle scalar subqueries in VALUES list
• a6b9845 Allow using native SQL conversion when using FetchXML feature not supported by serializer
• b33235a Fixed type-specific display
• 917abae Simplify filters
• 40e9104 Do not add IsVariable attribute to serialized XML unless necessary
• 1bc70a6 Fixed retrieving multiple pages
• 199ab9a Improved variable folding
• c1dd3b0 Fixed setting available join operators
• d0b7c1a Fixed switching connections
• 0209755 Simplified filtering on virtual name & type columns
• 71b27a8 Removed backup files
• bc3f7da Check number of joins before adding more for virtual name attribute filter [ #158 ]
• cb4650f Fixed error trying to create new connections from SDK login control
• 380c8db Improved <> handling for nulls [ #167 ]
• 620b9ec Added not-null column checking to FilterNode
• a27c888 Fixed tests
• b2f6794 Expanded join folding
• a682926 Optimize order of hash join inputs
• 8a2f028 Fixed hash joins with keys of different types
• 6911749 Disable timeout in XTB
• 77482b1 Improved row count estimates
• 8949677 Only convert join to nested loop if inner filter can be folded
• 813089b Use nested loop for better perf when inner data set has only 1 row
• e7de177 Show estimated rows out
• da0da50 Improved estimated row count for metadata queries
• bb11804 Refactored type descriptor to reuse code between XTM and SSMS
• 69a4091 Updated alias handling
• 6178d61 Moved duplicate column name handling to UI
• 3abbff2 Improved error handling
• d582929 Delay autosizing columns until all data is loaded [ #162 ]
• d65dbe0 Added dedicated toolbar button to convert SQL to FetchXML
• dcf9464 Added option to show TDS Endpoint usage in estimated execution plans
• b0010ec Fixed SSMS error
• 4ef2ff3 Refactored IDataSetExecutionPlanNode to product IDataReader instead of DataTable
• 9b7d240 Show execution plans in SSMS
• 9ef4049 Disable use of RetrieveTotalRecordCount by default [ #159 ]
• 80af695 Exposed IQueryExecutionOption options via Sql4CdsConnection
• c23fd39 Moving IQueryExecutionOptions to internal progress
• 7e78cc6 Refactored cancellation
• 911a78c Revert "Refactored cancellation"
• 3ed8b04 Refactored cancellation
• 65c1a18 SSMS compatibility fixes
• 6f170c3 More SSMS work
• f4f1976 Initial SSMS compatibility changes
• c042cac Track focus in execution plan view
• b1ddba1 Flow control changes using GOTO
• 5577a11 Added PRINT support
• 75cc961 Clone nodes to avoid problems in WHILE loops or repeated executions of prepared plans
• 895ed3b Allow use of @@ROWCOUNT with TDS Endpoint within a complete SQL script
• 1d26340 Improved display of conditional nodes in execution plan
• 29b05f1 Refactored IF/WHILE into single Conditional node
• 6842126 Added IF and WHILE support
• 70ac8bb Refactored to hide internal methods
• 7a58203 Use new ADO components instead of ExecutionPlanBuilder directly
• 1265c88 TDS Endpoint usage improvements
• 51b1066 Improved TDS Endpoint support
• 9d1d8c9 Always need to pass through variables dictionaries
• 65db496 Type conversion improvements
• 58fa8b4 Added @@IDENTITY and @@ROWCOUNT support
• ed82670 Return raw values
• 0214747 ADO provider progress
• 8a5415e Fixed passing parameters to query
• a5620d9 Initial draft of ADO.NET provider
• 1ccb1cd Added support for setting initial variable value in DECLARE statement
• 60a6586 Merged from master
• 0eabe32 Store full SQL type information for parameters
• 73fb02b Initial variables work

This list of changes was auto generated.

v5.4.1

Changes:

• 1e2f5da Merge pull request #153 from MarkMpn/aggregate-fix
• a26dd62 Updated release notes
• 00875ab Avoid treating window functions as regular aggregates [ #150 ]
• 8aa9c0f Handle errors when paging results sorted by lookup column
• b182e8d Do not use FetchXML aggregates for DATEPART in UTC
• 4a21c00 Single threading fix
• 9ba77b6 Merge pull request #147 from MarkMpn/netcore
• ebaf7f9 Multi-thread partitioned aggregates
• 48525b5 Check for consistent sort order from CatchSource
• d9ecc51 Connection switcher improvements

See More

• 100959a Added display name
• 932a212 Reset paging on multiple executions

This list of changes was auto generated.

v5.4.0

Changes:

• 5a59af6 Merge pull request #145 from MarkMpn/netcore
• f3b0c49 Install updated version of NuGet for packaging readme
• 420d9bf Revert "Use DotNetCoreCLI for NuGet pack"
• 41b010e Merge pull request #144 from MarkMpn/netcore
• 2799ca8 Changed FetchXml project to shared project
• 89b11b5 Merge pull request #143 from MarkMpn/netcore
• f61b03c Use DotNetCoreCLI for NuGet pack
• 42dcd82 Merge pull request #142 from MarkMpn/netcore
• 30e0eb5 Refactored CompoundKey to DistinctEqualityComparer
• 1632760 Support TOP N WITH TIES

See More

• b5a66ab Added toolbar option to switch databases
• 4831a18 Fixed sizing of multiple result grids
• a52cb99 Use StreamAggregate for Distinct if input is already sorted
• be81e39 Aggregate performance refactoring
• f411029 Fixed tests
• 4a50ec9 Preserve sort ordering between nodes
• c93e385 Added Stream Aggregate
• 2a76ec5 Merge remote-tracking branch 'origin/master' into netcore
• 9d4b646 Made NodeSchema read-only to fix bugs with caching
• 475f07b Fixed use of non-FetchXML functions in WHERE clause
• 32e14d8 Allow use of query-derived tables containing aggregates
• 9482097 Performance improvement for generating query plan with lots of joins
• 2e1991d Added logging
• 0140229 Updated release notes
• dd4e9a6 Fixed DISTINCT with repeated attributes
• b23a046 Merged changes
• 674aa2b Fixed running queries with more than 10 joins
• 7bfb2d4 Fixed errors when using filters on party list fields
• b0bcff2 Fixed errors when using LIKE queries on non-string fields
• deb85d2 Fixed GROUP BY and ORDER BY on multi-select picklist fields
• 29529c2 Removed obsolete code
• 2277c9e Updated versioning for .NET Core build
• c0caa68 Fixed insert/delete listmember
• db7165c Initial .NET Core porting work
• ecab0e7 Merge pull request #139 from MarkMpn/aggregates
• d9a0313 Updated release notes
• 285d3d1 Added option to convert FetchXML to SQL using native conversion message
• 5caaff3 Fixed using quoted identifiers
• c2be4be Fixed retrieving file-type fields
• c812552 Added setting to control displayed date format
• cafcac1 Fixed GROUP BY & aggregates on virtual attributes
• d8b74f4 Fixed GROUP BY on listmember.entitytype attribute
• 6a78a0a Expose exception details in TryCatchNode
• f3a2b76 Grouping fix
• 284eb3c Merge remote-tracking branch 'origin/master' into aggregates
• e2a2843 Test fixes
• 2cc1e6c Include one attribute to prevent default of retrieving all attributes
• 0f217cc Handle partitioning AVG()
• a0c5b60 More partitioning work
• 022a4de Partitioning updates
• fc3bb3a Partitioning work
• 9f88d56 Initial partitioning work

This list of changes was auto generated.

v5.3.1

Changes:

• 9702d47 Merge pull request #134 from MarkMpn/type-conversion
• c8cdd35 Fixed #133
• 6c383d8 Merge pull request #132 from MarkMpn/type-conversion
• 90eb20f Fixed #131
• 8dbf354 Merge pull request #130 from MarkMpn/power-bi
• db89889 Merged from master
• 5bbf69b Merge pull request #129 from MarkMpn/regional
• 401e967 Updated release notes
• 482dba0 Merge remote-tracking branch 'origin/master' into power-bi
• a6ea8b7 Added missing comma

See More

• a640359 Fixed decimal number handling with non-English regional settings [ #128 ]

This list of changes was auto generated.

v5.3.0

Changes:

• 78e5e5f Merge pull request #127 from MarkMpn/cross-instance
• a4968ad Added missing tooltip
• 1d3b97f Merge pull request #125 from MarkMpn/cross-instance
• 51c6443 Updated release notes
• 0fef662 Fixed updating values to null literal using TDS endpoint [ #122 ]
• f397718 Improved display of DataSource properties
• 9fcc6a6 Improved intellisense for cross-instance joins
• 1234520 Expose CURRENT_USER as entity reference
• cce0318 Metadata intellisense improvements
• ba39040 Expose lookup values as links

See More

• e0e4c8c Improved autocomplete for joins on metadata tables
• 4c1c7a4 Added ISNULL function
• 2b62d11 Handle queries in parentheses
• e6739eb Handle virtual tables
• 94bffcb Updated release notes
• f9ba3d7 Fixed error using primary functions in GROUP BY clause
• ce1b85c Fixed intellisense for metadata columns
• a8c170a Merge pull request #123 from MarkMpn/cross-instance
• b815ac9 More build fixes
• 836b1ad Fixed build error
• c0072d2 Updated release notes
• 84abc07 Merge remote-tracking branch 'origin/master' into cross-instance
• b2d744d Fixed error executing DML commands
• 5ecac2a Support CURRENT_USER and other parameterless calls [ #121 ]
• 2b80f0e Improved cross-instance autocomplete
• e76aa4d Initial support for CURRENT_TIMESTAMP and CURRENT_USER parameterless functions
• bfd8c53 Fixed #120
• 5d9b62e Autocomplete improvements for multi-part table names
• 25f025f Initial cross-instance work
• 6750e69 Start of refactoring
• cdd28bc Merge pull request #119 from MarkMpn/power-bi
• 1be32ec Convert queries to M format for use in Power BI

This list of changes was auto generated.

v5.2.5

Changes:

• ef054bb Merge pull request #118 from MarkMpn/execution-plan
• d217fd6 Updated release notes
• adddae0 Merge pull request #117 from MarkMpn/execution-plan
• e6d1e63 Query metadata directly while cache is loading in background
• 7f7a80e Merge pull request #115 from MarkMpn/execution-plan
• fb435d9 Allow sending SQL as well as FetchXML from other tools
• 3698cad Fixed datetime formatting in FetchXML

This list of changes was auto generated.

v5.2.4

Changes:

• a6c6a38 Merge pull request #114 from MarkMpn/execution-plan
• 5daf332 Fixed integration from FetchXML Builder

This list of changes was auto generated.

v5.2.3

Changes:

• 1786510 Merge pull request #113 from MarkMpn/execution-plan
• 84cd0bf Handle errors getting a new CrmServiceClient instance

This list of changes was auto generated.

v5.2.2

Changes:

• ff65d2b Merge pull request #112 from MarkMpn/execution-plan
• 67a792f Fixed handling of multiple aliases for the same column
• a5ef49f Fixed "unknown column" errors when using metadata columns in calculations without fully qualified names
• b3e5b73 Updated release notes
• 90ff29e Improved containvalues handling [ #110 ]
• 73be796 Avoid locking while metadata cache is being loaded
• e2c5934 Merge pull request #108 from MarkMpn/execution-plan
• 2128bac Merge branch 'execution-plan' of https://github.com/MarkMpn/Sql4Cds into execution-plan
• 28cbffc Merge branch 'master' into execution-plan
• e9cc56f Updated release notes

See More

• 6d9e912 Add sorts to FetchXML aggregates to avoid issues with paging
• 6f7bb4d Merge pull request #107 from MarkMpn/execution-plan
• 221ed6d Updated minimum XrmToolBox version
• b64696c Merge branch 'execution-plan' of https://github.com/MarkMpn/Sql4Cds into execution-plan
• 778800e Added warning on INSERT to match UPDATE/DELETE
• c9180a0 Updated release notes & description
• 07076c0 Merge branch 'master' into execution-plan
• 2a6aad5 Handle "Aggregates are not supported" error from audit table
• 4b549de Merge branch 'execution-plan' of https://github.com/MarkMpn/Sql4Cds into execution-plan
• a5ad053 Use explicit OnConnectionRequested calls to differentiate between changing connection of current tab and adding connection to Object Explorer [ #103 ]
• d0d556c Limit the properties shown for connections to reduce blocking
• 347b31b Fixed IN queries on metadata [ #104 ]

This list of changes was auto generated.

v5.2.1

Changes:

• 8b08de2 Merge pull request #101 from MarkMpn/execution-plan
• 5fc7952 Merge branch 'master' into execution-plan
• 752a9c5 Allow opening FXB directly from selected FetchXML node in execution plan
• e396a1b Fixed folding additional criteria when reordering join
• e50a4ef Merge pull request #100 from MarkMpn/execution-plan
• 184153c Updated release notes
• 6806376 Add tracking token to docs links
• 52cd93b Updated check for metadata cache version
• f3bd172 Added FetchXML document type
• aa0cd5c Improved autocomplete of UPDATE/DELETE statements with no FROM

See More

• 8a446cf Refactored tests in preparation for FakeXrmEasy v2 [ #83 ]
• 14eb3c3 Do not use metadata cache from older versions of MscrmTools.Xrm.Connection
• e250f3c Added help links to settings dialog
• 562d9a0 Reorder inner joins to use N:1 joins to avoid paging issues
• 18b4063 Allow for scrollbar in datagrid sizing
• 4ebb614 Fixed COUNT(*) with IN subquery
• 456131a Generate better error when trying to insert values true or false
• e5602c7 Fixed NullReferenceException on tooltips when disconnected
• 1bd43c6 Restore previous session with new connection
• 8054eaa Save & restore session details [ #67 ]
• c661a37 Allow changing connections & disconnected tabs
• 02b5e75 Handle errors from the metadata cache
• c6a7093 Do not show autocomplete menu during Alt+Tab
• a42a9bd Added option to refresh metadata cache
• d2e10ef Use shared metadata cache from XrmToolBox where possible
• 717c40a Updated SDK assemblies to match XrmToolBox
• 0aa02e1 Use AllProperties where possible when folding SELECT * FROM metadata... queries
• 49f6f8e Made error details from inner exception/fault visible to help diagnose errors
• bf144fa Added Bypass Custom Plugins option
• 3a78b73 Disable affinity cookie for bulk data updates
• c3904f6 Updated package versions
• 0adee9d Removed duplicated method

This list of changes was auto generated.