K-Lite Codec Pack Full 歷史版本列表
更新時間：2021-11-06
更新細節：
更新時間：2021-11-05
更新細節：
What's new in this version:
VSCode 1.62.0
Visual Studio Code for the Web - vscode.dev (Preview):
- This iteration, we released a preview of Visual Studio Code for the Web. Visual Studio Code for the Web provides a zero-install experience running entirely in your browser, allowing you to quickly and safely browse source code repositories and make lightweight code changes. To get started, go to https://vscode.dev in your browser.
- VS Code for the Web has many of the features of VS Code desktop that you love, including search and syntax highlighting, along with extension support to work on your codebase. In addition to opening repositories, forks, and pull requests from source control providers like GitHub and Azure Repos, you can also work with code that is stored on your local machine.
- Not all extensions can run when VS Code is in the browser. Extensions that are purely declarative, such as themes, snippets, or grammars, can run unmodified in the browser. However, extensions that need to run code must be updated by the extension authors. We'd like to say thank you to the extension authors that already have published their extensions as web extensions.
Workbench:
Settings editor accessibility:
We made various Settings editor accessibility improvements:
- The Settings editor scrolls back to the top after performing a search, so the user does not end up midway through the search results after each search.
- The settings scope switcher is accessible via keyboard.
- Deprecated setting text blocks display an icon. Previously, the deprecated text was distinguished from the rest of the setting text only by color.
- More UI elements within the Settings editor have the setting ID as their name.
Updated search icons:
- The search icons are now the same weight and the match whole word icon was updated to be more distinguishable from the rest.
Parameter hint highlight:
- VS Code now highlights the current parameter in the parameter hint and the color can be themed via editorHoverWidget.highlightForeground
Editor:
Improved bracket pair guides:
- We continued iterating on bracket pair guides. Horizontal lines now outline the scope of a bracket pair. Also, vertical lines now depend on the indentation of the code that is surrounded by the bracket pair.
- Bracket pair guides can be enabled by setting editor.guides.bracketPairs to true (defaults to false). We added a third option "active" to only show a bracket pair guide for the active bracket pair.
- The new setting editor.guides.bracketPairsHorizontal controls if and when to render horizontal guides (defaults to active).
- New themable colors editorBracketPairGuide.background{1,...,6} and editorBracketPairGuide.activeBackground{1,...,6} can be used to customize the color of bracket pair guides
Customizable bracket pairs:
- You can now configure bracket pairs for a specific programming language through settings. editor.language.bracketPairs can be used to configure which bracket characters should be matched. If set, editor.language.colorizedBracketPairs independently configures which bracket pairs are colorized when bracket pair colorization or bracket pair guides are enabled.
Display hovers above or below the current line:
- You can now choose between displaying IntelliSense hovers above (default) or below the current line. By setting editor.hover.above to false, hovers will render below the current line.
Unicode directional formatting characters:
- To address CVE-2021-42574, VS Code now renders Unicode directional formatting characters by default. Consider the following text snippet.
- The above text snippet contains two explicit directional formatting characters, U+202E (RIGHT-TO-LEFT OVERRIDE) and U+202C (POP DIRECTIONAL FORMATTING). These characters can influence Unicode's Bidirectional Algorithm and could be used to craft source code that renders differently than what compilers would execute.
- The special rendering of these directional formatting characters can be turned off by setting editor.renderControlCharacters to false. The setting editor.renderControlCharacters is now true by default.
Extensions:
Verified extension publishers:
- VS Code now shows if the domains of an extension publisher are verified by the Visual Studio Marketplace
- If you are an extension author, more details about how to become a verified publisher can be found in the Publishing Extensions topic
Terminal:
New default keybindings for special characters:
- The following keybindings were added that are typically supported in other terminals:
- ctrl+shift+2: Inputs the null character (0x00).
- ctrl+shift+6: Inputs the record separator character (0x1E).
- ctrl+/: Inputs the unit separator character (0x1F).
Languages:
- Configure how HTML completes attributes:
- There is a new setting html.completion.attributeDefaultValue that lets you choose how values are filled in when an HTML attribute is completed:
- doublequotes: The value is placed in double quotes (default)
- singlequotes: The value is placed in single quotes
- empty: The value is left empty
Emmet improvements:
- The new Emmet: Update Tag command (editor.emmet.action.updateTag) updates the placeholder with the HTML tag to be updated.
- The extension also activates now when one tries to run any Emmet command. This change should fix an issue where some commands were not found when run from the Command Palette, while also keeping the activation event list more precise so that Emmet does not start up unnecessarily, such as in an empty workspace.
- For multi-root workspaces, Emmet now sources snippets from all workspace folders, rather than just the first one. As a result, custom snippets from all workspace folders will be suggested when editing an applicable file in the workspace.
Notebooks:
Find and Replace supports capturing groups:
- The Find and Replace widget in the notebook editor now supports regular expression capturing groups
- In the short video below, replace uses the first (and only) captured text ('a')
Better selection of output renderers and mimetypes:
- Notebook cells can output multiple types of data (mimetypes) that can be rendered in different ways both by VS Code itself and extensions. Previously, VS Code had basic memoization (caching) of the selected renderer for a mimetype, and you could manually configure your preferred mimetypes using the notebook.displayOrder setting. However, VS Code wasn't particularly smart about picking the best renderer for a mimetype, and preferred mimetypes had to be updated manually.
- Now, preferred renderers are cached on a per-notebook type, level in the workspace. Additionally, if you switch to view a different mimetype, that preference will be updated in-memory for the VS Code session, and you can use the Notebook: Save Mimetype Display Order command to easily update the notebook.displayOrder setting to the working preference.
Contributions to extensions:
Jupyter:
- Kernels
- In order to make it easier to identify kernels, the Jupyter extension now groups kernels in the kernel picker.
- You can now filter the list of kernels displayed in the kernel picker, either globally or on a workspace basis. This is helpful if you have a large number of kernels installed but usually only work with a subset.
- To manage the list of kernels displayed, you can use the command Jupyter: Filter Kernels from the Command Palette.
Interactive Window:
- Automatic cell creation when running the last cells in an Interactive Window using Shift+Enter can now be configured via the setting jupyter.newCellOnRunLast. If you don't want the default behavior to add a new cell, you can set jupyter.netCellOnRunLast to false.
ESLint:
- A new version of the ESLint extension has shipped. Major improvements are:
- Extended support for ESLint version 8.x.
- The ability to define the rule set that is applied during code action on save and format via the setting eslint.codeActionsOnSave.rules.
GitHub Pull Requests and Issues:
- Work continues on the GitHub Pull Requests and Issues extension, which allows you to work on, create, and manage pull requests and issues. Check out the changelog for the 0.32.0 release of the extension to see the highlights.
Remote Development:
- Work continues on the Remote Development extensions, which allow you to use a container, remote machine, or the Windows Subsystem for Linux (WSL) as a full-featured development environment.
Feature highlights in 1.62 include:
- New setting remote.SSH.foldersSortOrder to sort SSH targets alphabetically or by recent use.
- Windows Subsystem for Linux indicator lets you quickly know whether you are using WSL 1 or WSL 2.
- Advanced container configuration videos covering how to persist bash history and work with monorepos.
Preview features:
TypeScript 4.5 support:
This update adds support for the upcoming TypeScript 4.5 release. The TypeScript 4.5 beta announcement post has more information about the new language and tooling features. Some tooling highlights:
- Method signature completions.
- JSX attribute completions.
- More accurate reference counts for the references CodeLens.
- To start using the TypeScript 4.5 nightly builds, install the TypeScript Nightly extension.
- Please share your feedback and let us know if you run into any bugs with TypeScript 4.5.
- Extension authoring:
- Emoji support in file decorations
- The file decorations API now supports emojis as badge texts.
MarkdownString.supportHtml:
- The new supportHtml property on MarkdownString enables rendering of a safe subset of raw HTML that appears inside the Markdown text.
- The supportHtml property defaults to false. When disabled, VS Code will strip out any raw HTML tags that appear in the Markdown text.
Engineering:
File watching changes:
- File watching in VS Code changed to a new library, thanks to the work of the Parcel team with their @parcel/watcher. We will gradually roll out this change to all users in the upcoming weeks. Linux users will be happy to learn that the files.watcherExclude now applies natively so that the number of file handles VS Code needs open for file watching can be greatly reduced.
- The existing files.legacyWatcher setting was changed to an enumeration with these values:
- on - The new file watcher will never be used.
- off - The new file watcher will always be used.
- default - The new file watcher will only be used when you open multi-root workspaces (via a .code-workspace file).
- You should not notice any difference in your day to day work, but if file watching is broken for you, please report an issue.
Progress for Electron sandbox support:
- As we continue to make the VS Code workbench ready for enabling Electron's sandbox, we made progress on moving Node.js file services out of the workbench window into a different process. The same is true for the file watcher that no longer forks from the workbench window, but from a background process. This change is enabled by default in VS Code Insiders and will be the default in Stable for our November release.
Notable fixes:
- 73061: Enumerable properties mixed with regular properties
- 130868: Emmet suggestions list missing entries after adding custom snippets.json
- 131966: Emmet unable to expand abbreviation with onclick attribute
- 135110: Support different border settings for vertical or horizontal layouts, for in-group editor splitting
VSCode 1.61.2
The update addresses these issues:
- Web: Handles may contain slashes at the end
- Focus of commit message textbox swaps when files are changed meanwhile
VSCode 1.61.1
Fixed:
- Process handles leaked by pty host on windows
- September 2021 Recovery Endgame
- High CPU Usage: Every VS Code window eats 5+% CPU, even idle, even in the background
- Empty HoverWidget is visible at startup
- New Telemetry Level should respect my prior settings
- Source Control bug when creating or changing branch in the workspace
VSCode 1.61.0
- Split editors within the same group - Quickly create side-by-side editors for the same file
- Locked editor groups - Select editor types to automatically lock in an editor group
- Better display of deleted and readonly files - Tab decorations highlight deleted and readonly files
- Bracket pair guides - Display vertical guides to link matching bracket pairs
- Fixed terminal dimensions - Set an active terminal's width and height
- Jupyter Notebook improvements - Table of Contents view, full debugging support
- Platform-specific extensions - Publish different extension versions for Windows, macOS, and Linux
- Virtual Workspaces extension guide - Learn how to update your extension for virtual environments
- Advanced container configuration - Tips, code samples, and videos to help configure development containers
VSCode 1.60.2
The update addresses these issues:
- The GitHub.codespaces extension gets activated twice when creating a new codespace
- Bundle TS 4.4.3
- ugust 2021 Endgame Recovery 2 endgame-plan
- Codespaces: Debugging is broken
- Automatic language detection overrides openTextDocument API language parameter
- Undo stops working after focusing webview
VSCode 1.60.1
Fixed:
- npm script not work in default terminal
- Context menu command "Open in Integrated Terminal" does not use Default Profile
- Go to Symbol in Workspace
- Allow also setting the language_info in a notebook
- Show Log from Container Creation Progress notification has no effect
- SSH Remote fails to connect
- Inline-suggestion appearing at previous cursor location
- August 2021 Endgame Recovery
- v1.60: "Auto language select" feature sets "CoffeeScript" language in "Git commit" files
- Powershell console opens every time I launch VS Code with a project
- Unable to save notebook when executing a long running cell
VSCode 1.60.0
- Automatic language detection - Programming language detected when you paste into VS Code
- Built-in fast bracket colorization - Fast bracket matching and colorization for large files
- Settings editor syntax highlighting - Rich syntax highlighting for setting description code blocks
- Custom terminal glyph rendering - Better display of box drawing and block element characters
- Set debugging Watch values - Change watched values during a debugging session
- Notebook improvements - Markdown link navigation, faster rendering of large outputs
- JavaScript/TypeScript inlay hints - Inline hints for parameter names and types, and more
- Locked editor group preview - Keep a preferred editor layout by locking the editor group
- Python extension testing updates - Better support for test discovery, navigation, and status
- Web extension authors guide - Learn how to update your extension for VS Code in the browser
VSCode 1.59.1
Fixed:
- Notebooks cannot be opened on 1.59
- Authentication decryption error
- tasks.onDidEndTaskProcess is called too many times in VS Code v1.59
- Perma-hang/crash on M1 MBP with universal build
- July 2021 Endgame Recovery
- Stdout generated raw data file not in expected format.
- Typing repeated dots in js expands to first suggestion
VSCode 1.59.0
- Extensions view improvements - Rich extension detail hovers, new runtime status tab
- Settings editor validation - Quickly find editing errors for object-based settings
- Drag and drop terminals - Move terminals across windows to both editor and panel areas
- Extended theme customization - Customize multiple color themes at once
- Built-in support for Jupyter notebooks - Open .ipynb files directly in VS Code
- Notebook UI improvements - Display first line of collapsed cells, Undo/Redo per cell
- Testing API finalized - Native support for running tests in VS Code with built-in Test Explorer
- Debug Disassembly view preview - Display disassembled C++ code in VS Code
- Live Preview extension - Live HTML preview within VS Code with JavaScript debugging support
- Remote - Containers devcontainer CLI - Command line interface for working with development containers
VSCode 1.58.2
Fixed:
- June 2021 Endgame Recovery 2
- Only acquire workspace storage locks on the remote extension host
- Remote extension will not work if it depends on a local UI one
- Terminal is tiny when extensions create and show them
- When multiple ghost text parts have line breaks, the first line of the ghost text gets deleted
- Using command line to open vscode causes code warning
- Trust and Continue dialog need two clicks on Continue to go away
- VS Code Terminal doesn't autofocus
- MacOS: Could not move terminal into editor area after first move
VSCode 1.58.1
The update addresses these security issues:
- Improves Git security with untrusted workspaces bug git important
- Don't use guessable nonces in webview
- Update distro hash
VSCode 1.58.0
- Terminals in the editor - Create or move terminals into the editor area
- Workspace Trust - Quickly customize Workspace Trust settings, disable Restricted Mode banner
- Editor scroll bar customization - Set bar visibility and width, click navigation behavior
- Markdown preview KaTeX support - Math support in the Markdown preview
- Settings editor improvements - Support for multiple checkboxes and enumeration dropdowns
- Sticky debug environment choice - Debugger remembers your previous environment choice
- Jupyter Interactive window - Run Jupyter code directly in an interactive window
- Jupyter notebook debugging - Debug Jupyter notebook code from within VS Code
- 'Open in VS Code' badge - Lets visitors quickly open your GitHub repo in VS Code
- Data Science tutorials - Learn about Jupyter Notebooks, PyTorch, and more
VSCode 1.57.1
- May 2021 Endgame Recovery
- Scrolling on mouse click
- macOS: restore Cmd+W closing the window when all tabs are closed
- 1.57.0 (macOS): window behaves different now (fullscreen & priority issues)
- "Open New External Terminal" doesn't work if no terminal settings are present
- Entire settings file got erased on new latest update. Just FYI
VSCode 1.57.0
- Workspace Trust - Extra security against code execution when browsing unfamiliar source code
- New Getting Started experience - Helps you quickly set up and learn about VS Code
- Remote Repositories - Browse and edit code without locally cloning repositories
- Terminal tabs - Tabs let you easily create, manage, and group multiple open terminals
- Edge browser debugging - Integrates the Microsoft Edge Developer Tools directly into VS Code
- JSDoc @link support - Add @link tags in your comments for fast symbol navigation
- Go to Definition for non-code files - Quickly jump to images and stylesheets
- Notebook API finalized - Notebook API for native notebook support in VS Code
- VS Code at Build 2021 blog post - Catch up with on-demand sessions featuring VS Code
VSCode 1.56.2
- C# syntax highlighting incorrect in 1.56
- Use shell/shellArgs over defaultProfile if specified
- HTML files now require an extension to run
- The default Monokai highlight color is displayed incorrectly
- No longer scaling toolbar icon
- On PC 'Delete' key not working on insiders for approx last week
- Version control icons became minuscule with latest update
VSCode 1.56.1
The update addresses these security issues:
- Do not invoke resolveWithInteraction over terminal settings
- Change grunt, gulp and jake task auto detection to be off by default
VSCode 1.56.0
- Improved hover feedback - Helps you quickly find clickable editor actions
- Terminal profile improvements - Create a custom default terminal profile
- Debugger inline values - Display variable values inline during debugging sessions
- Notebook KaTeX support - Math support in notebook Markdown cells
- Remote - Containers volumes view - Manage mounted volumes within Docker containers
- winget installation - VS Code is available via the Windows Package Manager
- New introductory videos - Videos for getting started with VS Code as well as working with C++
- Terminal tabs preview - Get a first look at managing open terminals with the new tabs view
VSCode 1.55.2
The update addresses these security issues:
- Limit set of allowed remote CLI commands bug important
- command: links should be only selectively enabled bug important
- Spawning php should use its complete disk path bug important
- Spawning npm should use its complete disk path bug important
- CSS should use variables when using editor.fontFamily bug important
- The http.proxy setting should use machine or application scope bug important
VSCode 1.55.1
- Proxy agent is hijacking requests and redirecting them to localhost
- Remote extensions are not installed automatically from devcontainer.json
- Bug Sur icons glitched on non-hidpi screens
- ECONNREFUSED debugging browsers in WSL2
VSCode 1.55.0
- Accessibility improvements - Multi-cursor support and increased line limit
- Updated icons for macOS Big Sur - Brand icons that match the visual style of Big Sur
- Improvements to breakpoints - Inline breakpoints menu, and more
- Editor status decorations - Editor tab status decorations are on by default
- Customize keyboard shortcuts editor - Resize columns in the keyboard shortcuts editor
- Improved remote ports management - Port forwarding autodetection, regex naming, and more
- Terminal profiles - Define profiles in terminal to conveniently launch non-default shells
- Notebook improvements - Multiple cell selection, and more customizable diff editor
- VS Code on Raspberry Pi - New topic explaining how to install VS Code on Raspberry Pi devices
VSCode 1.54.3
- February Recovery 3
- VS Code is unable to activate a debugger extension because of path casing discrepancies
VSCode 1.54.2
Fixed:
- Listener leak in Ports view
- Close terminal warning shows even if no terminal is open
- Command "View: Join all editor groups" not working after update
- Pick up TS 4.2.3
- Cannot find module 'worker_threads' using js debugger auto attach
- Completed tiles of "Getting Started" don't reopen
- List focus background needs proper migration
- Renaming a folder adds it to history
- FileSystemProvider extension: throwing a FileSystemError in readFile does not report to user
- Hide pty host unresponsive notification when it becomes responsive again
- Terminal pty host unresponsive after closing a VS Code window
- Prevent env var relaunch from extension owned terminals
VSCode 1.54.1
- The update addresses an issue with an extension dependency
VSCode 1.53.2
Fixed:
- TS Server fatal error: Cannot read property 'indexOf' of undefined
- <> in all files
- Minimap keeps disappearing
- Fresh install won't open any windows or allow me to open any windows
- First call to activeDebugConsole.appendLine() while debugging JavaScript doesn't appear in the debug console
- Cannot unset StatusBarItem background from errorBackground
- tasks.json npm script does not work with arguments since 1.53
- v1.53 creates debug.log automatically
- The default extension for untitled files is not .txt
- Emmet suggestions bug in SASS files
- VSCode emmet SASS snippets
- IME ON at Alt+` key, Focus ALT Menu
VSCode 1.53.1
Security issues:
- Bundle TypeScript 4.1.4
- Dragging files from explorer to terminal may execute a command
- Pick up new distro version and bump version
VSCode 1.53.0
- Wrap tabs - Wrap editor tabs in the workbench instead of having a scrollbar
- Configure tab decorations - Add editor tab status decorations
- Customize search mode - Use the Search view or open a new Search editor
- JavaScript debugging - Support for conditional exception breakpoints and Node.js worker_threads
- Notebook UX updates - Outline view for Notebook cells, and breadcrumbs for improved navigation
- Markdown preview image auto update - Preview automatically updates when images change
- Emmet improvements - Faster performance and supporting the latest features
- Extension guidelines - Documented best practices for extension authors
- Remote Development video series - Learn to create and configure container-based environments
VSCode 1.52.1
- November 2020 Recovery Endgame
- Check for all possible localhost string when checking if a tunnel already exists
- Can not set breakpoint in PHP files
- notebook status bar icon colors missing
更新時間：2021-11-05
更新細節：
What's new in this version:
- Updated MPC-HC to version 1.9.16.63
- Updated MPC Video Renderer to version 0.5.5.1781
更新時間：2021-11-05
更新細節：
更新時間：2021-11-05
更新細節：
What's new in this version:
- Fixed an issue where Effect Rack could crash when doing an offline render to a new sample rate with VST
- Fixed an issue where Effect Rack could produce an incorrect “out of automation slots” alert during an offline render
更新時間：2021-11-05
更新細節：
更新時間：2021-10-21
更新細節：
What's new in this version:
dotConnect for SQLite Professional 5.18.2001
- Visual Studio 2019 Preview support is discontinued
- The bug with throwing Devart.Common.LicenseException, when Devart.Data.MySql.dll is embedded into a single file application, is fixed
- The bug with applying .NET Standard licensing to .NET 6 projects is fixed
Entity Developer:
- The bug with launching Entity Developer after applying Windows 10 Update KB5006670 and Windows 11 Update KB5006674 is fixed
LinqConnect (formerly known as LINQ to MySQL):
- The bug with parsing TypeName values in XML mapping generated by Visual Basic template is fixed
Entity Framework support:
- Entity Framework Core 5.0.11 is supported
- Entity Framework Core 3.1.20 is supported
- The implementation of config.CodeFirstOptions.TruncateLongDefaultNames in EF6 .NET Standard compliant assemblies is improved: the generated names are constant, independent on a current domain and workstation
- The bug with using DateTime.Now, DateTime.UtcNow, DateTimeOffset.Now within LINQ query in EF Core 5 is fixed
dotConnect for SQLite Professional 5.18.1895
Entity Developer:
- The new property Validation Framework is implemented in the Data Transfer Object template for generating DataAnnotations attributes
- The Uri data type is supported in EF Core Model
- The new option "Save connection to" is implemented in Model Settings of EF Core Model to provide the ability to store the connection string in "Model file", "Entity Developer storage", "Environment variable"
- The new option "Enum Output" is added to the EF Core template to specify output for the generated enums
- The new property Generate UnitOfWork Repository Properties (by default, True) is implemented in the Repository and Unit Of Work template of EF Core Model for accessing the collections of entities
- The representation of one-to-one association with non-nullable properties on both ends is changed from 1 -> 1 to 0..1 -> 1 on a diagram in EF Core Model
- The bug throwing "Unknown property 'DoNotSerialize'.", when complex types and VB.NET template are used in EF Core Model, is fixed
- The bug with code generation for the Constrained option of Association Editor in the case of 0..1 -> 1 association in EF Core Model is fixed
Entity Framework support:
- Entity Framework Core 5.0.10 is supported
- Entity Framework Core 3.1.19 is supported
The following Code-First Migration operations are supported in EF Core 3 and EF Core 5 via recreating a table and copying the existing data:
- AlterColumn
- RenameColumn (SQLite 3.24 and below)
- DropColumn (SQLite 3.34 and below)
- AddForeignKey
- DropForeignKey
- AddPrimaryKey
- DropPrimaryKey
The SQL translation of the following class members used in LINQ query is supported in EF Core 3 and EF Core 5:
- static method IsNullOrWhiteSpace() of the String class
- static property Today and instance properties DayOfWeek, Ticks of the DateTime class
- static methods Max(), Min(), Sqrt(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan() of the Math class
- Mapping of System.Decimal to SQLite DECIMAL with specified precision and scale in EF Core 5 is supported
- Mapping of internet/intranet data type System.Uri to SQLite TEXT is supported in EF Core 3 and EF Core 5
- Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to SQLite TEXT is supported in EF Core 5
- The SQL translation of these static methods of the MathF class used in LINQ query is supported in EF Core 5: Abs(), Round(), Truncate(), Floor(), Ceiling(), Max(), Min(), Pow(), Sqrt(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan()
- The definition of System.ICloneable is removed from .NET Framework assembly EntityEFCore3Devart.Data.SQLite.Entity.EFCore.dll
dotConnect for SQLite Professional 5.17.1944
LinqConnect (formerly known as LINQ to SQLite):
- The new methods IsNotDistinctFrom() and IsDistinctFrom() are added to the Devart.Data.Linq.SqlMethods class
Entity Framework support:
- Entity Framework Core 5.0.8 is supported
- Entity Framework Core 3.1.17 is supported
- The bug with using Int16 as a data type of the Primary Key property in EF Core Migrations is fixed
dotConnect for SQLite Professional 5.17.1930
- Visual Studio 2019 version 16.11 Preview 2.0 is supported
- The sqlite3.dll library that is included into the installation package is updated to version 3.36.0
Entity Developer:
- The behavior of the Regenerate Storage and Mapping functionality in EF Core Model is changed: the NOT NULL attribute of the column is reset to undefined now; after that, the behavior depends on the Nullable attribute of the class property only
- The bug with applying the Default Precision and Default Scale values from Model Settings to the non-decimal data types by Update To Database Wizard in EF Core is fixed
Entity Framework support;
- Entity Framework Core 5.0.7 is supported
- Entity Framework Core 3.1.16 is supported
- The bug with comparing enum values in EF Core 3 and EF Core 5 is fixed
- The bug with .Contains and .Length in EF Core 3 and EF Core 5, when using NetTopologySuite spatial functionality, is fixed
dotConnect for SQLite Professional 5.17.1905
Entity Developer:
- The new extended property Use Generic DbContextOptions Constructor Argument is added to model properties of EF Core Model
- The new extended property Do Not Generate Constructor With DbContextOptions Argument is added to model properties of EF Core Model
- The bug with generating the Equals method for entities with Record Type=True by C# EF Core template is fixed
- The bug with cleaning values of Length and Precision/Scale column's attributes by Update From Database Wizard in EF Core Model is fixed
- The bug with ignoring template's Validation Error Messages values in the generated code, when class property's Validate Expression is initialized and Validate Format is set to a non-default value, is fixed
- The bug with creating app.config in Visual Studio .NET Framework projects, when the "Rewrite connection string during regeneration" option is turned off in Model Settings, is fixed
Entity Framework support:
- Entity Framework Core 5.0.6 is supported
- Entity Framework Core 3.1.15 is supported
- The EF6 provider registration used with .NET Framework compliant assemblies is improved: the [DbConfigurationType(typeof(SQLiteEntityProviderServicesConfiguration))] attribute set for DbContext descendant allows now calling the DbContext constructor, that accepts a connection string, with no need to register a custom IDbConnectionFactory implementation
dotConnect for SQLite Professional 5.17.1866
Entity Developer:
- The new hotkey Alt+E is implemented in Property Editor for opening Column Editor in EF Core Model
- The bug with throwing "bufferAdapter is not a VsTextDocData" when saving a model in .NET Core, .NET Standard, .NET 5, .NET 6 projects of Visual Studio 2019 is fixed
- The bug with missing .NET Framework, .NET Core 1, .NET Core 2 options for the Target Framework property in Model Settings of EF Core Model in a standalone Entity Developer is fixed
- The bug with preserving Target Framework=.NET Framework in Model Settings of EF Core Model in a standalone Entity Developer is fixed
dotConnect for SQLite Professional 5.17.1860
- Visual Studio 2019 version 16.10 Preview is supported
- The sqlite3.dll library that is included into the installation package is updated to version 3.35.3
- The bug with reading System.Byte[] instead of actual values of CHAR columns via SQLiteDataReader is fixed
Entity Developer:
- .NET 6.0 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings in EF Core, EF6, LinqConnect models
- The new extended property Record Type is added for classes in the case of C# EF Core template to generate records instead of classes in C# 9.0 or higher and .NET 5 or higher
- The new options "Private setter for store generated properties" and "Constructor parameter" are added to Model Settings in EF Core for controlling visibility of setter for store generated properties
- The new options "Don't show this message again" in the prompt window and "Prompt before generating code when there are model validation warnings" in the menu Options are implemented in a standalone Entity Developer to provide the ability not to stop code generation by warnings
- The new extended property Do Not Generate Default Constructor is added to EF Core Model for model, classes, and complex types
- The new extended property Do Not Generate Mapping is added to EF Core Model for class properties
The JSON (Newtonsoft.Json, Microsoft.Text.Json) and YAML (YamlDotNet) serializations are supported in EF Core (via EF Core template) and EF6 (via DbContext template):
- The new template property Serialization Library is added for specifying the library used for serialization
- The new template property Serialize Original Column Names is added for controlling the appearance of original column names in serialization
- The new template property Serialize Navigation Properties is added for controlling the appearance of navigation properties in serialization
- The new template property Serialize Null Value is added for managing the behavior of nullable properties
- The new extended property Do Not Serialize is added for properties and navigation properties to exclude them from serialization
- The new extended property Serialization Name is added for properties and navigation properties to set custom names in serialization
The Data Transfer Object template is improved:
- The new template property Serialization Library is added for specifying library used for serialization, possible values are Data Contract, JSON (Newtonsoft.Json), JSON (Microsoft.Text.Json), YamlDotNet
- The new extended property Do Not Serialize is added for properties and navigation properties to exclude them from serialization
- The new extended property Serialization Name is added for properties and navigation properties to set custom names in serialization
- The behavior is changed: WCF Data Contract Attributes is set to False by default now
The following properties are marked as obsolete:
- the Generate Data Contracts property of the EF Core template
- the Do Not Generate Data Contract Attribute extended property of navigation properties in EF Core Model
- the WCF Data Contract Attributes property of the DbContext and Data Transfer Object templates
- the WCF DataMember Attribute on Navigation Properties property of the DbContext and Data Transfer Object templates
- The bug with creating app.config in Visual Studio .NET Core projects is fixed
- The bug with detecting the existing classes with QueryType=True by Update From Database Wizard in EF Core Model is fixed
Entity Framework support:
- Entity Framework Core 5.0.4 is supported
- Entity Framework Core 3.1.13 is supported
dotConnect for SQLite Professional 5.17.1836
- The sqlite3.dll library that is included into the installation package is updated to version 3.34.1
- The new command line option /disablegac that disables adding assemblies to GAC is added
Entity Developer:
- The behavior is changed in Entity Developer embedded into Visual Studio: lower versions in the EF Core version property of Model Settings are not hidden any more
- The behavior is changed in EF Core Model: QueryType=True is set now for all classes without PK
- C# code generation is improved: the using directives are generated instead of full namespaces in the names of attributes for DataAnnotations, NHibernate Validator, and Enterprise Library validation frameworks
- Code generation is improved: OnModelCreating(modelBuilder) of the base class is invoked now if the Base Context Type property of EF Core Model is initialized
Entity Framework support:
- Entity Framework Core 5.0.3 is supported
- Entity Framework Core 3.1.12 is supported
- The bug with translating Enum.HasFlag to SQL in EF Core 3 and EF Core 5 is fixed
dotConnect for SQLite Professional 5.17.1812
- The bug with blocking thread during retrieving a connection from the pool, when connections from the same pool are used in several threads, is fixed
Entity Developer:
- The new attribute DisplayName is implemented for model objects' extended properties which are available via template properties
- The new options --ContextNamespace and --DefaultNamespace are added to the Create-Model command of Console Entity Developer
- The new extended model property Base Context Type is added for specifying a parent class for the generated context in EF Core Model
- The new extended properties Base Type for complex types and Base Complex Type for model are implemented in EF Core Model
- The %type name% keyword is supported in the Base Type extended property of entities and complex types, and in Base Complex Type, Base Entity Type, Base Context Type extended model properties for setting generic base type in EF Core Model
- Code generation is improved: RelationalIndexBuilderExtensions.HasDatabaseName is generated now instead of RelationalIndexBuilderExtensions.HasName in EF Core 5
- Display names of extended properties in EF Core Model are updated: Entity Base is renamed to Base Type in class properties, Entity Base is renamed to Base Entity Type in model properties, Context Base is renamed to Base Context Type in model properties
- The bug with setting additional keyboard mapping scheme via menu Options on Windows with German display language is fixed
LinqConnect (formerly known as LINQ to SQLite):
- The new property Local is added to the Table and Table classes to return a collection of the entities attached to the context
- The new method GetEntityState(object entity) is added to Table class and ITable interface to return one of the EntityState values
- The bug with throwing "Bad key member '...' in association '...' of type '...'." in runtime by .NET Standard compliant assemblies is fixed
Entity Framework support:
- Entity Framework Core 5.0.2 is supported
- Entity Framework Core 3.1.11 is supported
- The new metadata to describe autoincremental columns via annotations in EF Core Code-First Migrations are implemented
dotConnect for SQLite Professional 5.17.1792
Entity Framework support:
- Entity Framework Core 5.0.1 is supported
- The bug with creating savepoints in EF Core 5 is fixed
dotConnect for SQLite Professional 5.17.1782
- Visual Studio 2019 version 16.9 Preview is supported
- The sqlite3.dll library that is included into the installation package is updated to version 3.34.0
- The bug with using URI format with file path in the Data Source connection string parameter is fixed
- The bug with updating projects that reference EF6 provider assembly via Upgrade Wizard is fixed
Entity Developer:
The new features are supported in Entity Framework 5.0:
- TPT inheritance
- Many-to-many associations
- The new types of properties IPAddress and PhysicalAddress
- The Model Refactoring functionality is supported for classes in EF Core Model
- The behavior is changed in a standalone Entity Developer: by default the Target Framework model property in EF Core Model is set to .NET 5 instead of .NET Framework
- The bug with saving non-default value of Target Framework model property in EF6 model modified with a standalone Entity Developer is fixed
- The bug with adding new arguments at the end of argument list instead of actual position in method signature by Update From Database Wizard is fixed
Entity Framework support:
- Entity Framework Core 5.0 is supported
- Entity Framework Core 3.1.10 is supported
- The behavior is changed: EF Core 3 assemblies available via NuGet package are compiled for .NET Standard 2.0 instead of .NET Standard 2.1
- The behavior is changed: EF Core 2 assemblies are no longer available via NuGet package but created in the provider installation folder
- The bug with using another context's connection in DbContextOptionsBuilder.UseSQLite(connection) in EF Core is fixed
dotConnect for SQLite Professional 5.16.1759
- The bug with Visual Studio 2019 integration, when both v16.7 RTM and v16.8 Preview are installed on the same computer, is fixed
- The bug with missing Name and Owner properties of the SQLiteConnection class in .NET Standard compliant assemblies is fixed
Entity Developer:
- The bug with reading templates from *.edps by console Entity Developer is fixed
Entity Framework support:
- Entity Framework Core 3.1.9 is supported
- The bug with invalid attempt to load the SQLite extension library 'mod_spatialite', when .UseNetTopologySuite() is not used, in EF Core is fixed
dotConnect for SQLite Professional 5.16.1739
- Visual Studio 2019 version 16.8 Preview is supported
Entity Developer:
- EF Core 3 spatial data types support is improved: in addition to Geometry and Geography, specific .NET NetTopologySuite types like GeographyPoint, GeographyLine are now available property types
- The default mapping for spatial data types in Server's Options is updated
- The bug with throwing "EntityProperty does not contain a definition for IsSpatialType", when custom template from previous versions is used, in EF Core Model is fixed
- The bug with applying On Delete Action=Cascade set in Association Editor to the Generate Database Script functionality in EF Core Model is fixed
- The bug with reading settings from *.edps by console Entity Developer is fixed
Entity Framework support:
- The bug with throwing System.NullReferenceException by the Code-First CreateDatabase() / Code-First Migrations functionality in EF Core is fixed
dotConnect for SQLite Professional 5.16.1730
- The sqlite3.dll library that is included into the installation package is updated to version 3.33.0
- The SendCallStack property is added to the Devart.Common.DbMonitor class for possibility to turn off resource-demanding logging of CallStack
- The Filter property is added to the Devart.Common.DbMonitor class for possibility to choose events being logged
- The Devart.Common.DbMonitor class is improved: now values of the DateTime parameters sent to the dbMonitor tool are supplemented with milliseconds
- The bug with updating projects in folders below the main project by Upgrade Wizard is fixed
- The bug with using Microsoft DataSet Wizard is fixed
Entity Developer:
- The error message in console Entity Developer is improved: now the text includes the list of all available templates if the specified name of template was incorrect
- The bug with saving a new model, which has never been saved before, after some time of work in a standalone Entity Developer is fixed
- The bug with generating mapping for the properties with Shadow=True in EF Core Model is fixed
- The bug with using spatial types inside complex types in EF Core Model is fixed
Entity Framework support:
- Support for spatial data types in EF Core 3 is implemented
- Entity Framework Core 3.1.8 is supported
- The new NuGet package Devart.Data.SQLite.EFCore.NetTopolosySuite with a .NET Standard 2.1 assembly, that is compatible with .NET Core 3, is added
- The new EntityEFCore3Devart.Data.SQLite.Entity.EFCore.NetTopolosySuite.dll assembly compiled with EF Core 3.1 and .NET Framework 4.6.1 is added
- The SQLiteFunctions class, which allows using SQLite-specific functions in LINQ to Entities, is supported in EF Core
- The SQLiteTextFunctions class, which allows using SQLite full-text search functionality in LINQ to Entities, is supported in EF Core
dotConnect for SQLite Professional 5.15.1696
- The bug with throwing System.NullReferenceException when opening *.edmx with invalid associations is fixed
dotConnect for SQLite Professional 5.15.1686
- The sqlite3.dll library that is included into the installation package is updated to version 3.32.3
- LinqConnect (formerly known as LINQ to SQLite)
- The "Could not find element type in model" bug when loading XML mapping in .NET Standard LinqConnect assemblies is fixed
- The bug with using enums via .NET Standard compliant assemblies is fixed
Entity Framework support:
- The bug with incorrect SQL generation when using .Substring() in a .Select() statement in EF Core 2 is fixed
dotConnect for SQLite Professional 5.15.1666
- Visual Studio 2019 version 16.7 Preview is supported
- The sqlite3.dll library that is included into the installation package is updated to version 3.32.2
Entity Developer:
- .NET 5 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings in EF6, EF Core, LinqConnect models
- The new option "Execute procedures for result set detection" is added to Model Settings of EF Core Model to control obtaining metadata of a procedure or function result set
- The new option "Use NULL parameter values" is added to Model Settings of EF Core Model to specify whether NULL parameter values are used for stored procedure execution
- The new option "Add complex types to diagram" is added to Model Settings of EF Core Model to control behavior of Create Model Wizard and Update Model From Database Wizard
- The new option "Add new complex types to the current diagram" is added to Update Model From Database Wizard of EF Core Model
- The new Primitive Default Value Generation property is added to EF, EF Core templates to determine whether to generate initialization for a primitive property based on database DEFAULT column value
- The new property Collection Property Type is added to EF template "DbContext" and EF Core template "EF Core" to determine .NET type used as a property type for the Many end of associations
- The new property Collection Initialization Type is added to EF template "DbContext" and EF Core template "EF Core" to determine .NET type used for initialization of the Many end of association; if it is set to None, then no initialization is generated
- The new property "Nullable Reference Types" is added to C# templates of EF, EF Core models to specify whether C# 8 nullable reference types and non-nullable reference types must be generated
- The new partial method is added to the OnModelCreating(DbModelBuilder modelBuilder) method generated by DbContext template of EF model
- The EF Core model deserialization is improved: Entity Developer shows the full list of detected errors and tries to load the model with invalid elements or ignores such elements if their deserialization is not possible
Console Entity Developer improvements:
- Import of stored procedures and functions via Create-Model command is supported
- The new options --Procedures and --Functions are added to Create-Model command for filtering stored procedures and functions; by default all procedures/functions are imported
- The new option --Execute is added to Create-Model command for executing procedures/functions to get metadata from result set
- The asterisk symbol (*) is supported in --Tables and --Views parameters of Create-Model to include all objects
- The bug with opening connection via some supported providers is fixed
- The bug with enumerating values separated with comma and without whitespace in --Templates, --Schemas, --Tables parameters is fixed
- The DbProviderFactories registration is implemented in Create Model Wizard for EF6 models and .NET Framework provider assemblies
- The new property Target Framework is added to Create Model Wizard and Model Settings of EF6 models
- The compatibility issue with JetBrains ReSharper is fixed
- The behavior is changed: the definition of auto-implemented property is put now on the single line with
- C# DbContext template of Devart Entity Model when ImplementINotifyPropertyChanging=False and ImplementINotifyPropertyChanged=False and PropertyChangePartialMethods=False
- C# EF Core template of Devart EF Core Model when PropertyChangeNotifiers=False and PropertyChangePartialMethods=False
- The behavior for the new EF, EF Core models is changed: Primitive Default Value Generation is set to Literal now instead of LiteralOrExpression
- The behavior is changed: the names of system types are generated without "System." prefix now in EF Core models; for example, it is DateTime instead of System.DateTime
- The behavior is changed: only one confirmation for executing stored procedure is requested by Entity Developer when drag&drop-ing procedure from Database Explorer to Model Explorer or diagram surface
- The behavior is changed: now the EF Core template generates an additional partial class for the context class when "File Per Class" and "Generate Partial Class" are set to True
- The bug with detecting strings, being expressions, as string literals when generating initialization of string properties basing on database columns' default values in EF, EF Core models is fixed
- The bug with missing default value in the generated code basing on DEFAULT value in a database, when any of ImplementINotifyPropertyChanging, ImplementINotifyPropertyChanged, PropertyChangePartialMethods options of DbContext template in EF is turned on, is fixed
- The bug with code generation for zero-or-one to zero-or-one association in the EF6 model with the DbContext template (Fluent Mapping=True) is fixed
- The bug with generating .HasMany end of one-to-many association in EF Core Model is fixed
- The bug with generating TPH mapping in EF Core 3 model is fixed
- The bug with false appearing the "Table or view '...' has no primary key columns, and the entity key for the corresponding storage entity was calculated automatically from other fields." warning in the Error List window is fixed
- The bug with generating new Guid() with Primitive Default Value Generation=Literal in EF, EF Core models is fixed
LinqConnect (formerly known as LINQ to SQLite):
- The bug with materializing elements, the types of which are explicitly converted from non-nullable to nullable on the client side, is fixed
- The bug with incorrect detection of altered column comment in a many-to-many association join table by Update From Database Wizard is fixed
Entity Framework support:
- Entity Framework 6.4.4 is supported
- The translation of the DateTime.AddMinutes() method in LINQ query into SQL statement in EF Core is supported
- The bug with adding / subtracting DateTime and TimeSpan, DateTimeOffset and TimeSpan values in LINQ query in EF Core 3 is fixed
- The bug with SQL generation in EF Core 3, when enum values are used in CASE and COALESCE statements, is fixed
- The EF6 provider registration used with .NET Standard compliant assemblies is improved: the [DbConfigurationType(typeof(SQLiteEntityProviderServicesConfiguration))] attribute set for DbContext descendant allows now calling the DbContext constructor, that accepts a connection string, with no need to register a custom IDbConnectionFactory implementation
dotConnect for SQLite Professional 5.15.1612
LinqConnect (formerly known as LINQ to SQLite):
- The insert of the object, the type of which is an unmapped class inherited from a mapped class, is supported
- The bug with throwing System.NullReferenceException, when constructing the error saying that unmapped class is not supported, is fixed
Entity Developer:
- Command-line interface is implemented in a standalone Entity Developer
- The new property Context Name is added to Model Properties in EF Core Model
- The new property Target Framework is added to Model Properties in EF Core Model
- The provider registration is improved: requirement to put provider registration entry in the config file is not obligatory anymore
- Create Model Wizard is improved: now it allows installing multiple NuGet packages on the final step
- Model file tree in .NET Core / .NET Standard projects is improved: all generated code files and model files are nested under the same node in Solution Explorer
Entity Framework support:
- Entity Framework Core 3.1.3 is supported
- The .ToString() call for numbers, DateTime/DateTimeOffset properties and values in LINQ queries in EF Core is supported
- The call of Convert.ToString(value) in LINQ queries in EF Core is supported
- The bug with comparing milliseconds of DateTime properties is fixed
dotConnect for SQLite Professional 5.15.1583
- The SQLiteDataTable and SQLiteDataSet classes are supported in .NET Standard 2.0
- The behavior is changed: pool is automatically cleared when AppDomain is being closed
Entity Developer:
- The bug with returning multiple result sets in code generated by the EF Core template is fixed
Entity Framework support:
- Entity Framework Core 3.1.1 is supported
- The bug with using nullable enum properties with default mapping to integers in LINQ query in EF Core 3.1 is fixed
- The bug with using value converters detected automatically by .HasConversion() in EF Core 3 is fixed
- The bug with using NULL constant values in EF Core 3 is fixed
- The bug with using binary operators AND, OR in EF Core 3 is fixed
- The bug with setting a default value for DateTime and TimeSpan properties via EF Core Code-First Migrations is fixed
dotConnect for SQLite Professional 5.15.1541
- Visual Studio 2019 version 16.5 Preview is supported
- The bug with using Toolbox component SQLiteDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed
- The bug with enabling Devart DataSet Editor in Visual Studio 2017 and Visual Studio 2019 is fixed
- LinqConnect (formerly known as LINQ to SQLite)
- The bug with using Toolbox component DbLinqDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed
Entity Developer
- The bug with creating one-to-one association basing on an optional FK in EF Core Model is fixed
- The bug with code generation for oneOrZero-to-one and one-to-many associations based on an optional FK in EF Core Model is fixed
- The bug with generating a mapping for a unique constraint specified in owned type property of EF Core Model is fixed
Entity Framework support:
- Entity Framework 6.4 is supported
- Entity Framework Core 3.1 is supported
- The new EntityEFCore3Devart.Data.Oracle.Entity.EFCore.dll assembly compiled with EF Core 3.1 and .NET Framework 4.6.1 is added
- The config.DatabaseScript.ForeignKey.IndexCreation configuration option is supported in EF Core 1/EF Core 2/EF Core 3
- The bug with creating a unique constraint in the database via EF Core Code-First Migrations is fixed
- The bug with applying .ValueGeneratedOnAdd() to the string, guid, byte[] properties with .Key() and without .HasDefaultValueSql() in EF Core is fixed
- The bug with using bitwise operators And, Or, Xor with Int64 arguments in LINQ query is fixed
- The bug with detecting implicit database column type, when model mapping and migration mapping are different, via EF Core Code-First Migrations is fixed
- The bug with generating SQL when using explicit cast in LINQ queries in EF Core 1/EF Core 2 is fixed
- The bug with throwing the "Null TypeMapping in Sql Tree" error by methods in LINQ query in EF Core 3 is fixed
dotConnect for SQLite Professional 5.14.1519
- The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported by Devart DataSet Editor
Entity Developer:
- The Self-Contained Entity Configuration property is added to VB.NET version of EF Core template
- The Entities Configuration Output property is added to VB.NET version of EF Core template
- The code generation for the class properties with Alternate Key=True by VB.NET version of EF Core template is supported in EF Core model
- The bug with code generation, when Raw SQL Query is initialized in class properties, in EF Core 3 model is fixed
- The bug with generating .HasNoKey(), when Self-Contained Entity Configuration is set to True in properties of EF Core template, in EF Core 3 model is fixed
- The bug with generating alternate keys, when Self-Contained Entity Configuration is set to True in C# version of EF Core template, in EF Core model is fixed
Entity Framework support:
- The SQL generation in case of config.QueryOptions.UseCSharpNullComparisonBehavior=true in EF1/EF4/EF5/EF6 is improved
- The bug with using Scaffold-DbContext in EF Core 3 is fixed
- The bug with the redundant empty ORDER BY clause in a subquery, when paging is used, in EF Core 3 is fixed
- The bug with using .Contains within .Select of LINQ query in EF Core 2 is fixed
- The bug with generating invalid SQL when calling members of owned type in EF Core 2 is fixed
dotConnect for SQLite Professional 5.14.1504
Entity Developer:
- The DbContext template is improved: precision and scale for database types are generated now in EF4/EF5/EF6 models when Fluent Mapping=True and Mapping Generation Strategy=UseAttributes
- The bug with throwing the EntityFrameworkCoreVersion error in Create Model Wizard in a standalone Entity Developer is fixed
Entity Framework support:
- Entity Framework Core 2.2.6 is supported
dotConnect for SQLite Professional 5.14.1499
- The sqlite3.dll library that is included into the installation package is updated to version 3.30.1
- The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported by Devart DataSet Manager
Entity Developer:
The DbContext template is improved for using Entity Framework 6.3:
- The "Configuration Type Name" property, which specifies the descendant of DbConfiguration class that should be used for code-based configuration, is added
- The "Use DbConfigurationType Attribute" property, which determines whether to register the configuration type specified in the ConfigurationTypeName property of the DbConfigurationType attribute, is added
- The DbProviderFactories.RegisterFactory method is generated when UseDbConfigurationTypeAttribute=true and ConfigurationTypeName='%Default%'
- With UseDbConfigurationTypeAttribute=false, the static constructor for registering factory and the new partial method OnStaticConfigured are generated
- The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported
- The compatibility issue with JetBrains ReSharper is fixed
Entity Framework support:
- Entity Framework Core 3.0 is supported
- Entity Framework 6.3 is supported
- The lock for Microsoft.EntityFrameworkCore dependency is added to the NuGet package Devart.Data.SQLite.EFCore
dotConnect for SQLite Professional 5.13.1470
Entity Developer:
- Entity Framework 6.3 Preview 9 is supported for projects with target framework .NET Core 3 or .NET Standard 2.1
- The behaviour is changed: a plural form of names ending with "s" now has a longer version (for example, status -> statuses)
- The bug with applying the new Foreign Key's Delete Rule values SET DEFAULT and SET NULL by the Update Database From Model and Update Model From Database wizards is fixed (Entity Framework)
- The bug with copying a property with Primary Key=True / Entity Key=True to a complex type is fixed (Entity Framework)
- The bug with naming of a composing unique key by Create Model Wizard / Update From Database Wizard in EF Core is fixed (Entity Framework)
- The bug with invalid attempt to cast unsupported Visual Studio project to type 'VSLangProj.VSProject' is fixed
Entity Framework support:
- Entity Framework 6.3 Preview 9 is supported
- A new NuGet package Devart.Data.SQLite.EF6 with a .NET Standard 2.1 assembly, compatible with .NET Core 3, is added
- The bug with using the same database connection in several EF Core contexts is fixed
- The bug with applying a value converter to .Where expression with .Contains on nullable enum in EF Core 2 is fixed
dotConnect for SQLite Professional 5.12.1437
- The bug with throwing System.IndexOutOfRangeException when OracleParameter.Size=-1 is fixed
Entity Framework support:
- The bug with applying a value converter to a nullable column in EF Core 2 is fixed
- The bug with using the binary operator Add for the types 'System.String' and 'System.String' within LINQ query in EF Core 2 is fixed
dotConnect for SQLite Professional 5.12.1422
- The bug with throwing "Operation is not supported" by web providers, when the cookie is used, is fixed
Entity Developer:
- The ability to disable generation of the byte order mark (BOM) in the beginning of code files in a standalone Entity Developer is implemented
- The bug with design time copy/cut/paste functionality for entities is fixed
- The bug with invalid integer to enum conversion by a generated method, which is based on SQL query and returns a collection of entities, in EF Core 2 is fixed
Entity Framework support:
- The bug with applying a filter to the nullable property with implicit EnumToStringConverter via LINQ queries in EF Core 2 is fixed
- The bug with missing brackets around SELECT inside the generated CASE statement in EF Core 2 is fixed
- The bug with nullable parameters in EF Core 2 is fixed
- The bug with reopening connections in EF Core 2 is fixed
- The bug with incorrect exception message on opening connection, when ConnectionString is not set, by .NET Standard compliant assemblies is fixed
dotConnect for SQLite Professional 5.12.1402
- The sqlite3.dll library that is included into the installation package is updated to version 3.28.0
- Deprecated design-time Synchronous API calls are no longer used with Visual Studio 2019 and Visual Studio 2017
LinqConnect (formerly known as LINQ to MySQL):
- The bug with executing incorrect SQL request (cached during one of the previous calls), when a variable initialized with an empty collection participates in LINQ query, is fixed
Entity Framework support:
- Entity Framework Core 2.2.4 is supported
- The bug with closing database connection by context.Dispose() in the scope of a distributed transaction in EF Core 2 is fixed
- The bug with using a value converter, when the .NET data type remains the same, within the WHERE clause in EF Core 2 is fixed
dotConnect for SQLite Professional 5.12.1366
- Visual Studio 2019 is supported
- Entity Developer: the bug with processing DBNull returned by the function in EF Core is fixed
- Entity Framework support: the bug with using the "Generate Database from Model" wizard when working with Entity Framework 6 Tools is fixed
dotConnect for SQLite Professional 5.11.1357
- Visual Studio 2019 Release Candidate 4 is supported
- The sqlite3.dll library that is included into the installation package is updated to version 3.27.2
- The behavior is changed: reader.GetValue("text_column_with_nonstandard_typename") returns now the System.String object
- The bug with loss of changes, applied in different concurrent transactions, when journaling is not in the WAL mode, is fixed
LinqConnect (formerly known as LINQ to SQLite):
- The bug with using the System.Char argument as literal or variable in LINQ query is fixed
Entity Framework support:
- Entity Framework Core 2.2.3 is supported
- The SQL translation of the following method overloads, that accept the StringComparison argument and return bool, in the System.String class is supported in EF Core 2: Contains, StartsWith, EndsWith, Equals
- The bug with generating the COALESCE expression in EF Core is fixed
dotConnect for SQLite Professional 5.11.1328
- The sqlite3.dll library that is included into the installation package is updated to version 3.27.1
LinqConnect (formerly known as LINQ to SQLite):
- The bug with executing incorrect SQL request (cached during one of the previous calls), when .Contains() is invoked in the multithreaded application, is fixed
Entity Developer:
- The bug with generating fluent mapping for the one-to-one association by the DbContext template in EF4/EF5/EF6 is fixed
Entity Framework support:
- The translation of single-char literal into SQL statement in EF Core is supported
- The bug with throwing Devart.Common.LicenseException when using config.Workarounds.ProviderManifestToken in EF Core is fixed
- The bug with using a value converter for the property used in .Contains() in EF Core 2 is fixed
- The bug with translating String.IndexOf() into SQL statement in EF Core is fixed
- The bug with updating a null value of the concurrency check column with some non-null value in EF Core is fixed
dotConnect for Professional SQLite 5.11.1307
- The sqlite3.dll library that is included into the installation package is updated to version 3.26.0
- The bug with connecting to database with .NET Standard 1.3 compatible assemblies on .NET Framework 4.6.0 run-time is fixed
LinqConnect (formerly known as LINQ to SQLite):
- The new overload DataContext.Refresh(bool ignoreErrors, RefreshMode mode, object entity) is added for ignoring errors during refresh
- The existing overload DataContext.Refresh(RefreshMode mode, object entity) is improved: its check avoids the try to refresh the entity that is added to the context but not submitted to the database
- The type and text of the error generated by the DataContext.Refresh(RefreshMode mode, object entity) method, when the passed entity doesn't exist in database, is fixed
Entity Developer:
- The multiple select functionality in EF Core Model is improved: now it allows setting PrimaryKey, ValueGenerated, Concurrency for several properties simultaneously
- The bug with detecting order of columns in composite primary key with two or more columns by Update To Database and by Update From Database wizards in EF Core is fixed
- The bug with using ASP.NET Core Web Application (.NET Framework) and Azure Functions v1 (.NET Framework) projects in Visual Studio 2017 is fixed
Entity Framework support:
- Entity Framework Core 2.2.1 is supported
- The new extension method Database.IsSQLite() in EF Core 2 is implemented
- The bug with applying config.Workarounds.IgnoreSchemaName=true to the .ToTable() functionality in EF Core 2 is fixed
- The bugs with using the GuidToStringConverter, EnumToStringConverter, ValueConverter classes in EF Core 2 are fixed
- The bug with constructing the LIKE clause in EF Core 2 is fixed
- The bug with generating a subselect within the SELECT list in EF Core 2 is fixed
- The bug with applying an aggregate function to the result of a subselect in EF Core 2 is fixed
更新時間：2021-10-21
更新細節：
What's new in this version:
dbForge Studio for Oracle Enterprise 4.3.99
- The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update
- Fixed a critical error occurred when comparing data
dbForge Studio for Oracle Enterprise 4.3.97
Fixed:
- Issue with editing invalid objects
- Issue with connecting to Oracle 8 using the enabled Unicode option
dbForge Studio for Oracle Enterprise 4.3.93
Fixed:
- Issue with filtering in Database Explorer
- Error when establishing connection in the Direct modе
- Issue with the search operation in the view editor
- Improved processing of the error that occurred when executing cursor scripts
- Improved capabilities for opening a connection for users with limited permissions
- Improved behavior of the context menu on the Constraints tab of the table editor
- Error with the use of virtual columns
- Improved capabilities of work with the SQL*Plus DEFINE command
- Improved behavior of alias renaming for view columns
- Improved application of parameters when executing scripts by using the F5 and F8 commands
- Issue with cell focus in Data Editor
- Issue with parameter recognition during the execution of scripts
- Unexpected exception when importing data from an Excel file
- Error when restoring documents
- Unexpected exception when describing indexes during the generation of documentation
- Added processing of the circular dependency between the calculated column and the function
- Error while loading assemblies
- Mapping reset error during comparison with Custom Query
- Fixed processing of differences in NOT NULL values for the PRIMARY KEY columns
- Data comparison error that occurred when working with BYTE columns
- Fixed processing of errors that occurred as a result of multi-threading
- Issue with using Find and Replace in the object editor
- Issue with procedure text modification during debugging
- Issue with license verification on launch
- Issue with creating JOIN connections in Query Builder
- Added capability to set the time for input parameters of the DATE type in stored procedures
- Error that occurred when opening documents
dbForge Studio for Oracle Enterprise 4.3.34
New features and improvements:
- Activation of the tool via the command-line interface
- Improved working with virtual columns when comparing and synchronizing schemas
User-reported and internal bug fixes:
- Issue with synchronizing unique keys when modifying columns (T321087, T322045)
- Index analysis error when modifying a table (T324838)
- Working with index metadata is corrected
- Error when copying data from Data Editor (T319036, T319061, T319090, T319180, T319304, T320387, T320393, T320831, T321857, T323218)
dbForge Studio for Oracle Enterprise 4.2.34
- Complete server version for Oracle 18 and higher was detected incorrectly
- The 'SQL command not properly ended' error occurred with the delimiter character when executing the WITH clause (T312408)
- Behavior when copying the cell values from Data Editor is improved
- Issue with detecting the difference between tablespaces in constraints is eliminated
- Issue with the correct use of tablespaces in constraints when the Ignore Tablespaces option is enabled is eliminated (T306592)
- Error occurred with describing columns (T304630, T304631)
- A query that left-joined a table that was inner-joined with another table using parentheses to override the default precedence could not be formatted
- Formatting of a broken XLS file when exporting data to EXCEL is fixed
- Quoting when exporting data of the DATE format to EXCEL is improved (T313769)
- An error with closing the SQL document is eliminated
dbForge Studio for Oracle Enterprise 4.2.20
New features and improvements:
- Connectivity support for Oracle 20c is implemented
- New 'Reseed identity column' data sync option is added
dbForge Studio for Oracle Enterprise 4.1.94
Bugs fixed:
- Problem with the same name objects in documenter is fixed
- Problem with syntax highlight in .pkb file is fixed
- Problem with formatting long quoted multiline literals is fixed
- Problem with Hebrew Chars is fixed
- Other minor user reported bugs are fixed
dbForge Studio for Oracle Enterprise 4.1.48
Bugs fixed:
- Problem with lost synchronization script is fixed
- Problems with foreign keys comparing are fixed
- Other minor user reported bugs are fixed
dbForge Studio for Oracle Enterprise 4.1.43
New features and improvements:
- Brand New Application Skins
- Support for Oracle 19c
- AutoCommit Mode ON/OFF
- Improved Schema Comparison Performance
- Transaction Reminder and Execution Notifications
User reported bugs fixed:
- Problem with incorrect temporal table name is fixed
- Problem with wrong message in formatter is fixed
- Problem with ignore collation option is fixed
- Problem with Syntax Check is fixed
- Problem with Generate Fully Qualified Object Name option is fixed
- Problems with describe objects in Data Compare are fixed
dbForge Studio for Oracle Enterprise 4.0
Bugs fixed
- Problem with option "Generate fully qualified object names" is fixed
- Incorrect description of system properties is fixed
- Incorrect description of database object is fixed
- Problems in schema comparison wizard are fixed
- Problem with restoring *.dbd file is fixed
- Materialized view creation issue is fixed
- Data rows addition issue is fixed
- Problems with pressing "Refresh" button in "Breakpoints" window are fixed
- Problem with retrieving data from table is fixed
- Other user reported bugs are fixed
更新時間：2021-10-21
更新細節：
What's new in this version:
- Updated MPC-HC to version 1.9.16.46
- Updated LAV Filters to version 0.75.1-9-gde277
- Updated MPC Video Renderer to version 0.5.5.1767
更新時間：2021-10-21
更新細節：
What's new in this version:
Fixed:
- Table View - Fixed crashes that could occur when simply running queries or paging through results
- Migration from SQL - Fixed a crash that could occur when trying to edit the dataset properties of an array mapping