Skip to content

v6.0.0

Compare
Choose a tag to compare
@MarkMpn MarkMpn released this 10 Apr 08:16
14eff9b

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.