| |
| Date | Version | Source | Category | Type | Description |
| 2026-06-04 | 26.0.9651 | Microsoft SharePoint | Data Model | Added | - Added the ListFilesFromFolder stored procedure to the REST schema.
|
| 2026-05-27 | 26.0.9643 | General | Connection | Removed | - Removed the deprecated ReplaceInvalidTypesWithNull connection property. Use the ReplaceInvalidValuesWithNull property instead.
|
| 2026-05-26 | 26.0.9642 | Microsoft SharePoint | Connection | Added | - Added the ExposedTableTypes connection property, which controls how lists and views are exposed as tables for the REST schema.
|
| 2026-05-15 | 26.0.9631 | Microsoft SharePoint | Connection | Removed | - Removed support for the SOAP schema with the SharePoint Online edition. Setting Schema=SOAP with SharePointEdition=SharePoint Online now throws an exception. Use the REST schema for SharePoint Online. The SharePoint On-Premises edition continues to support the SOAP schema.
|
| 2026-05-11 | 26.0.9627 | Microsoft SharePoint | Data Model | Added | - Added the UpdateAttachment stored procedure to the REST schema.
|
| 2026-05-07 | 26.0.9623 | General | Data Model | Added | - Added the ColumnCapabilities column to the sys_tablecolumns system table. This column is a bit mask denoting the column's write capabilities.
|
| 2026-05-04 | 26.0.9620 | Microsoft SharePoint | Connection | Removed | - Removed the deprecated SharePointOAuth option from the AuthScheme connection property.
|
| 2026-05-04 | 26.0.9620 | Microsoft SharePoint | Data Model | Removed | - In the REST schema, removed the AccessRequestListUrl, RequestAccessEmail, UseAccessRequestDefault, DescriptionTranslations, and TitleTranslations columns from the Subsites view.
|
| 2026-04-29 | 26.0.9615 | Microsoft SharePoint | Connection | Removed | - Removed the NONE enum value from the Scope connection property.
|
| 2026-04-28 | 26.0.9614 | ADO.NET | Connection | Added | - Added the following functions to the driver class. If you pass these functions an exception with no error records, an InvalidArgumentException is thrown.
- containsErrorSource: Returns true if the exception contains an error record for the provided source name, or false otherwise.
- getErrorCodeFromSource: Returns the numeric error code from the error record with the given source, or -1 if there is no error record from that source.
- containsErrorCode: Returns true if the exception contains an error record with the provided error code, or false otherwise.
- findErrorProperty: Returns the value of the property with the given name, or null if no property with that name is defined.
- formatErrorRecords: Returns a string containing all the exception's error records, including messages, codes, properties, and error locations.
|
| 2026-04-15 | 26.0.9601 | General | Query Exec | Changed | - String comparisons using GREATER, LESS, and CONTAINS operators are now case-insensitive by default.
|
| 2026-04-07 | 26.0.9593 | Microsoft SharePoint | Compatibility | Changed | - The value for the URI connection property must match the internal name (Sharepoint URL) of the drive being accessed, rather than the display name.
|
| 2026-04-01 | 26.0.9587 | ADO.NET | | Added | - Added support for EFCore 10.
|
| 2026-04-01 | 26.0.9587 | Microsoft SharePoint | Data Model | Changed | - When IncludeLinkedColumns is enabled, additional "Linked" columns are exposed. Previously, these were described as foreign key references, but they represent entire related rows. These columns no longer return reference values.
|
| 2026-02-23 | 25.0.9550 | Microsoft SharePoint | | Added | - Added the GetFileSensitivityLabel stored procedure to the REST schema.
|
| 2026-01-13 | 25.0.9509 | General | | Added | - Added support for the REGEXP_REPLACE() string function.
|
| 2025-12-05 | 25.0.9470 | General | | Added | - Added support for the INSERT INTO SELECT statement, with driver-side execution for providers that do not support the operation natively.
|
| 2025-12-04 | 25.0.9469 | Microsoft SharePoint | | Deprecated | - Microsoft will discontinue support for the NTLM, Basic, and SharePointOAuth authentication schemes in 2026. This change affects the SharePoint Online edition. NTLM and Basic authentication schemes remain supported for SharePoint On-Premises.
|
| 2025-11-14 | 25.0.9449 | Microsoft SharePoint | | Changed | - The data type of currency fields in SharePoint has been changed from float to decimal. This also applies when ResolveCalculatedTypes is set to true.
|
| 2025-11-06 | 25.0.9441 | Microsoft SharePoint | | Added | - Added the TableListTypes connection property. This property specifies which SharePoint list templates are exposed as tables.
|
| 2025-10-06 | 25.0.9410 | General | | Added | - Support for parsing datetime formats using ".S" and ",S" for milliseconds and nanoseconds.
|
| 2025-10-06 | 25.0.9410 | Microsoft SharePoint | | Changed | - REST: Exposed different operations related to files, folders, list items, and permissions, as follows:
- Added three new stored procedures that support asynchronous folder operations: CopyFolderJob, MoveFolderJob, and GetJobStatus.
- Implemented an internal polling mechanism for monitoring job completion when WaitJobToFinish=True. This mechanism supports up to 6 retries, starting at two-second intervals.
- By default, two of the new stored procedures (CopyFolderJob and MoveFolderJob) return job attributes required to query status using GetJobStatus.
|
| 2025-09-12 | 25.0.9386 | General | | Added | - Added the IsInsertable, IsUpdateable, and IsDeleteable columns to the sys_tables table.
|
| 2025-09-10 | 25.0.9384 | General | | Changed | - All columns in statically defined Views are now reported as read-only.
|
| 2025-09-09 | 25.0.9383 | Microsoft SharePoint | | Changed | - Changed the IsNullable attribute to true in the REST Data Model for dynamic list columns that SharePoint was previously reporting as non-nullable.
|
| 2025-09-03 | 25.0.9377 | General | | Changed | - Corrected the behavior when IN criteria with NULL values are used in the projection part. It now returns NULL instead of 0. For example, "NULL IN (1,2)" returns "NULL".
|
| 2025-09-01 | 25.0.9375 | General | | Added | - Added support for using the CAST function with infinity values. This function can cast "inf" and "-inf" to DOUBLE, FLOAT, or REAL.
|
| 2025-09-01 | 25.0.9375 | Microsoft SharePoint | | Added | - Added the ResolveCalculatedTypes property. This property controls whether SharePoint calculated columns use their actual data types instead of being treated as varchar (string). This applies to both the SOAP and REST schemas.
|
| 2025-08-29 | 25.0.9372 | Microsoft SharePoint | | Changed | - When using the REST schema, the Scope connection property now automatically uses the ".default" scope when the property is set to "None", or when you have not set a value for the property.
|
| 2025-08-21 | 25.0.9364 | General | | Changed | - Report behavior change:
- Fixed inconsistent string value comparisons in non-table queries.
- For example, "SELECT 'A' = 'a'" previously returned false, but it now returns true.
|
| 2025-08-13 | 25.0.9356 | General | | Changed | - Changed the maximum number of pages held in memory from 15 to 5 for the page providers to decrease heap usage.
|
| 2025-08-07 | 25.0.9350 | Microsoft SharePoint | | Added | - Added the FileExtension field to the Attachments table.
|
| 2025-07-18 | 25.0.9330 | Microsoft SharePoint | | Removed | - Removed the OAuthGrantType property. The grant type is now set implicitly through the 'AuthScheme' property. For example, you can use the 'OAuthPassword' AuthScheme instead of AuthScheme=OAuth with OAuthGrantType=Password.
|
| 2025-07-18 | 25.0.9330 | Microsoft SharePoint | | Changed | - The Lists view was updated from a dynamic view to a static view to account for a SharePoint inaccuracy that excludes dynamically returned fields from being used in queries. Any Lists columns that were previously returned dynamically, but are not included in the current static data model, are no longer returned.
|
| 2025-07-12 | 25.0.9324 | Microsoft SharePoint | | Changed | - The Table column in the CreateSchema stored procedure (SOAP schema) has been renamed to TableName.
|
| 2025-07-12 | 25.0.9324 | Microsoft SharePoint | | Removed | - The TableDescription, WriteToFile, SchemaFile, and Columns columns have been removed from the CreateSchema stored procedure (SOAP schema).
|
| 2025-07-12 | 25.0.9324 | Microsoft SharePoint | | Added | - The FileName column has been added to the CreateSchema stored procedure (SOAP schema).
|
| 2025-07-11 | 25.0.9323 | Microsoft SharePoint | | Added | - Added the AddUserToGroup and RemoveUserFromGroup stored procedures to the REST schema.
|
| 2025-07-09 | 25.0.9321 | Microsoft SharePoint | | Added | - Added the AddPage stored procedure to the REST schema.
- Added the Id column to the Groups and Roles tables.
- Added the OwnerId column and OwnerName and DefaultUserLoginName pseudocolumns to the Groups table.
- Added the RoleName mirror column to Groups table.
|
| 2025-07-09 | 25.0.9321 | Microsoft SharePoint | | Changed | - Changed the ID column to Id in the Users table.
- Changed the Group and Role filter pseudocolumns in the Users table to GroupName and RoleName mirror columns.
- Changed the UserName and GroupName filter pseudocolumns in the Roles table to UserLoginName and GroupName mirror columns.
- Changed the UserName filter pseudocolumn in the Groups table to UserLoginName mirror column.
- Replaced the UPDATE statements in the Roles and Groups tables with the UpdateRole and UpdateGroup stored procedures.
|
| 2025-07-09 | 25.0.9321 | Microsoft SharePoint | | Removed | - Removed DefaultLogin and OwnerLogin columns from the Groups table.
|
| 2025-07-04 | 25.0.9316 | Microsoft SharePoint | | Removed | - Removed the UseIdURL connection property because it has been deprecated.
|
| 2025-06-25 | 25.0.9307 | General | | Removed | - Removed the "ADLS Gen 1" value from the ConnectionType property.
|
| 2025-06-20 | 25.0.9302 | General | | Added | - Created the following functions:
- TEXT_ENCODE: encodes a string into a different charset (UTF8 → UTF7 and returns a binary array as the result).
- TEXT_DECODE: takes a binary array and decodes it back into a string when provided the charset.
- BASE64_ENCODE: takes a binary array and encodes it as a base64 string (varchar).
- BASE64_DECODE: takes a base 64-encoded string and decodes it into a binary array.
|
| 2025-06-18 | 25.0.9300 | General | | Changed | - The internal code for exception handling has been refactored. Exception messages returned during certain error conditions may now have different wording or formatting.
|
| 2025-06-10 | 25.0.9292 | Microsoft SharePoint | | Changed | - Changed MaxLength input type from string to integer in the AddListColumn and UpdateListColumn stored procedures in the SharePoint SOAP schema.
|
| 2025-05-29 | 25.0.9280 | ADO.NET | | Changed | - We have improved our implementation of the ADO.NET DbDataReader.GetDataTypeName so that it now returns database data type names, such as varchar, tinyint, and datetime. Previously we returned the fully-qualified name of the column’s .NET type, in a format like "System.String, System.Private.CoreLib, Version=6.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e".
|
| 2025-05-29 | 25.0.9280 | Microsoft SharePoint | | Added | - Added the CheckPermissions stored procedure to the SharePoint REST schema, which verifies the effective permissions of a specific user or group on a SharePoint list or list item.
|
| 2025-05-27 | 25.0.9278 | ADO.NET | | Removed | - Removed support for the C# implementation of SQLite. Features that previously used this implementation by default, such as AutoCache and EF6 schema caching, now require the native SQLite driver.
|
| 2025-05-27 | 25.0.9278 | General | | Removed | - Removed the "Proprietary" enum option from ProxyAuthscheme.
|
| 2025-03-27 | 25.0.9217 | Microsoft SharePoint | | Added | - In tables or views whose corresponding OData entity is marked with hasStream:true in its API metadata responses, the MediaReadLink column is added to the table or view metadata. When present, this column displays the link to the OData entity's media stream.
|
| 2025-03-25 | 25.0.9215 | Microsoft SharePoint | | Added | - Added the AllPages and AllEvents views.
|
| 2025-02-28 | 25.0.9190 | Microsoft SharePoint | | Added | - Added the following views to the REST schema: AllFiles, AllLists, and Sites.
- Added the ChunkSize column to the UploadDocument stored procedure in the REST schema.
|
| 2025-02-15 | 24.0.9177 | General | | Added | - Added support for converting unsigned integer types to the nearest signed data type that has enough precision to hold the unsigned value.This is done for JDBC only because it does not have support for unsigned data types.
|
| 2025-01-27 | 24.0.9158 | Microsoft SharePoint | | Added | - Added a new stored procedure, AddImage, to the REST schema.
|
| 2025-01-06 | 24.0.9137 | Microsoft SharePoint | | Added | - Added the SiteURL input parameter to the CreateFolder stored procedure in the REST schema.
|
| 2024-12-05 | 24.0.9105 | Microsoft SharePoint | | Added | - Added support for chunked file uploads in the SOAP Data Model UploadDocument stored procedure.
|
| 2024-12-02 | 24.0.9102 | Microsoft SharePoint | | Added | - Added the Comments view to the REST schema.
|
| 2024-11-27 | 24.0.9097 | General | | Added | - Added ThreadId to LogModule output. Logfile lines now include the Thread ID associated with the action being performed.
|
| 2024-11-21 | 24.0.9091 | Microsoft SharePoint | | Added | - Added a new view, ListItems, to the SharePoint REST schema. It includes the most common fields found across various SharePoint lists.
|
| 2024-11-08 | 24.0.9078 | Microsoft SharePoint | | Added | - Added a new column, ItemURL, to the Attachments view in the SharePoint REST schema. This column provides a link that allows users to open the attachment directly in their browser.
|
| 2024-10-31 | 24.0.9070 | Microsoft SharePoint | | Added | - Added a new column, PrincipalType, to the Users view in the Rest schema. It defines the type of principal using bitwise values: None=0, User=1, Distribution List=2, Security Group=4, SharePoint Group=8, and All=15.
|
| 2024-10-25 | 24.0.9064 | Microsoft SharePoint | | Added | - Added the following support group name fields to the Groups view in the REST schema based on document reference: LoginName, Title, IsHiddenInUI, and PrincipalType.
|
| 2024-10-10 | 24.0.9049 | Microsoft SharePoint | | Added | - Added a new connection property, GetColumnsMetadata, to control how column metadata is retrieved in the REST schema.
|
| 2024-10-03 | 24.0.9042 | Microsoft SharePoint | | Added | - Added a new connection property, IncludeLookupDisplayValueColumns, which is only applicable for the REST schema.
|
| 2024-08-19 | 24.0.8997 | Microsoft SharePoint | | Changed | - In the Roles table (SOAP schema), changed the data type of the Permissions field from long to string.
|
| 2024-08-12 | 24.0.8990 | Microsoft SharePoint | | Added | - Added the following stored procedures to the REST schema: AddRoleAssignment, BreakRoleInheritance, and RemoveRoleAssingment.
|
| 2024-07-16 | 24.0.8963 | Microsoft SharePoint | | Changed | - The RoleDefinitionBindings view now has a composite key consisting of both Id and PrincipleID. Formerly it had a primary key.
|
| 2024-06-14 | 24.0.8931 | Microsoft SharePoint | | Changed | - Changed AzureAD to the default AuthScheme.
|
| 2024-06-14 | 24.0.8931 | Microsoft SharePoint | | Deprecated | - Deprecated the OAuth AuthScheme. AzureAD, AzurePassword, or AzureServicePrincipalCert should be used instead.
|
| 2024-06-13 | 24.0.8930 | Microsoft SharePoint | | Added | - Added the PrincipalType column to the RoleAssignmentMember view in the REST data model.
|
| 2024-06-13 | 24.0.8930 | Microsoft SharePoint | | Changed | - In the Attachments view in the REST data model, changed the Updated column from varchar to datetime.
- In the Attachments view in the REST data model, changed the ItemId column from varchar to int.
- In the Files view in the REST data model, changed the Size column from varchar to long.
- In the Files view in the REST data model, changed the TimeCreated and TimeLastModified columns from varchar to datetime.
- In the RoleAssignments view in the REST data model, changed the ItemId column from varchar to int.
- In the RoleAssignmentMember view in the REST data model, changed various columns from varchar to int, datetime, or boolean.
- In the RoleDefinitionBindings view in the REST data model, changed various columns from varchar to int, long, or boolean.
|
| 2024-06-12 | 24.0.8929 | Microsoft SharePoint | | Deprecated | - Deprecated the OAuthJWT AuthScheme.
|
| 2024-06-12 | 24.0.8929 | Microsoft SharePoint | | Added | - Added AzureServicePrincipalCert to the supported AuthSchemes.
|
| 2024-06-11 | 24.0.8928 | Microsoft SharePoint | | Removed | - Removed the KeepFieldUserResources field from the SubSites view in the REST schema.
|
| 2024-06-08 | 24.0.8925 | Microsoft SharePoint | | Changed | - Changed the data type of the Updated column in the RoleAssignments view from varchar to timestamp in the REST schema.
|
| 2024-06-08 | 24.0.8925 | Microsoft SharePoint | | Removed | - Removed the duplicate PrincipalId column with the varchar data type from the RoleAssignments view in the REST schema.
|
| 2024-05-24 | 24.0.8910 | Microsoft SharePoint | | Changed | - Changed data type of Users.Id, Users.GroupId, and Groups.Id from varchar to integer.
|
| 2024-05-09 | 24.0.8895 | General | | Changed | - The ROUND function previously did not accept negative precision values. That feature has now been restored.
|
| 2024-04-09 | 23.0.8865 | Microsoft SharePoint | | Added | - Added the AddList, AddListColumn, DeleteList, and DeleteListColumn stored procedures to the REST Schema.
|
| 2024-03-27 | 23.0.8852 | Microsoft SharePoint | | Added | - Added the MaxSelectLength hidden connection property to control the maximum number of characters allowed in the OData $select query option. If the limit is exceeded we will make multiple requests to the endpoint for the corresponding entity where each request contains a subset of the columns and we will perform a self join client-side as a final step to get the full data. This is useful in cases when the user is reading data from lists, libraries, or other entities exposed in our data model that have many columns and where the generated URL might hit an API limit (too long) or may not work correctly.
|
| 2024-03-15 | 23.0.8840 | General | | Added | - Created a new SQL function called STRING_COMPARE that provides java's String.compare() ability to SQL queries. Returns a number representative of the compared value of two strings
|
| 2024-03-11 | 23.0.8836 | Microsoft SharePoint | | Added | - Enabled the ShowPredefinedColumns connection property for the REST schema. The property behaves similarly to the SOAP schema. If set to false, all columns derived from a base type will be removed from the column listing.
|
| 2024-02-23 | 23.0.8819 | Microsoft SharePoint | | Changed | - Renamed the UploadDocument and CopyDocument outputs using standard names. _dlc_DocId and _dlc_DocIdUrl have been renamed to DocumentId and DocumentIdUrl respectively.
|
| 2024-02-23 | 23.0.8819 | Microsoft SharePoint | | Removed | - Removed the ReturnID input for the UploadDocument and CopyDocument stored procedures. The document metadata will be returned by default.
- Removed the MetadataName# and MetadataValue# inputs. The operations initiated by these inputs can be called by using UPDATE and SELECT queries with the outputted Id of the document.
- Removed the vti_author and vti_etag outputs.
|
| 2024-02-19 | 23.0.8815 | Microsoft SharePoint | | Changed | - Changed the endpoint for file retrieval. The ID column in the Files view is updated to show the document GUID.
|
| 2024-01-22 | 23.0.8787 | Microsoft SharePoint | | Changed | - Changed the default behavior of including linked columns. Linked columns are used to facilitate deep inserts which is not valuable for SharePoint lists, so linked columns are not included by default.
|
| 2024-01-19 | 23.0.8784 | Microsoft SharePoint | | Changed | - Reimplemented the UseDisplayNames feature for the REST schema due to the many differences between the OData metadata and the API that is used to retrieve the display names. Column data types may change to match the OData metadata since the OData standard is used for all list operations.
- Enabled the ShowHiddenColumns connection property for the REST schema. Hidden columns are not shown by default, to match the behavior of the SOAP schema. An extra call is needed to achieve this which may affect performance. Set ShowHiddenColumns to true to switch to the old behavior.
|
| 2024-01-18 | 23.0.8783 | ADO.NET | | Added | - Added support for EFCore 8.
|
| 2024-01-17 | 23.0.8782 | Microsoft SharePoint | | Added | - Added the Permanently parameter to the DeleteDocument stored procedure (REST schema) for triggering different behaviors. Enabling it deletes the document specified permanently, whereas disabling it moves the document to the recycle bin instead (default behavior).
|
| 2024-01-17 | 23.0.8782 | Microsoft SharePoint | | Removed | - Removed the RelativeURL and DocumentName parameters from the DeleteDocument stored procedure (REST schema).
|
| 2024-01-17 | 23.0.8782 | Microsoft SharePoint | | Replaced | - Replaced the RelativeURL and DocumentName parameters of the DeleteDocument stored procedure (REST schema) with the Path parameter.
|
| 2023-12-12 | 23.0.8746 | Microsoft SharePoint | | Changed | - Added Success as a standard output for all stored procedures to indicate whether the execution was successful or not. The output is a boolean and replaces the Result and Status outputs.
|
| 2023-11-29 | 23.0.8733 | General | | Changed | - The ROUND function doesn't accept the negative precision values anymore.
|
| 2023-11-29 | 23.0.8733 | General | | Changed | - The returning types of the FDMonth, FDQuarter, FDWeek, LDMonth, LDQuarter, LDWeek functions are changed from Timestamp to Date.
- The return type of the ABS function will be consistent with the parameter value type.
|
| 2023-11-28 | 23.0.8732 | General | | Added | - Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
|
| 2023-11-15 | 23.0.8719 | ADO.NET | | Changed | - NuGet license and icon are now embedded within the package itself, in compliance with the package authoring best practices.
|
| 2023-10-24 | 23.0.8697 | Microsoft SharePoint | | Changed | - The default value for the hidden connection property IncludeReferenceColumn for the REST data model has changed to false and the ParentReference columns is no longer listed by default.
|
| 2023-06-30 | 23.0.8581 | Microsoft SharePoint | | Changed | - Enabled the UseDisplayNames connection property for the REST schema. Enabling this property returns the display name as the column name and may affect performance and change the column data type.
|
| 2023-06-20 | 23.0.8571 | General | | Added | - Added the new sys_lastresultinfo system table.
|
| 2023-04-25 | 23.0.8515 | General | | Removed | - Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
|
| 2023-04-19 | 23.0.8509 | ADO.NET | | Removed | - Removed support for EFCore 3.1.
|
| 2023-04-18 | 23.0.8508 | ADO.NET | | Removed | - Removed support for SSRS 2012
|
| 2023-04-18 | 23.0.8508 | ADO.NET | | Added | - Added support for SSRS 2022.
|
| 2023-03-01 | 22.0.8460 | Microsoft SharePoint | | Added | - Added the ServerRelativeUrl column to the Lists view.
|
| 2023-01-19 | 22.0.8419 | Microsoft SharePoint | | Added | - Added the links on the Connecting to REST API page under Sharepoint Online and Sharepoint OnPremise sections.
|
| 2022-12-22 | 22.0.8391 | Microsoft SharePoint | | Added | - Added the RenameAttachmentOrDocument and MoveAttachmentOrDocument stored procedures to the SOAP and REST schemas.
|
| 2022-12-21 | 22.0.8390 | Microsoft SharePoint | | Changed | - Changed the data type of the PertainingToTerm column from boolean to string in the GetValidTerms view.
|
| 2022-12-19 | 22.0.8388 | Microsoft SharePoint | | Added | - Added support for the ReadTimeout option to the download stored procedures in the REST schema. ReadTimeout can be used to force a download to fail after a certain time, unlike Timeout which only triggers if the download stalls for that amount of time.
|
| 2022-12-14 | 22.0.8383 | General | | Changed | - Added the Default column to the sys_procedureparameters table.
|
| 2022-12-08 | 22.0.8377 | Microsoft SharePoint | | Added | - Added the WriteToFile parameter for the CreateSchema stored procedure in the SOAP schema. This defaults to true and must be disabled to write the schema to FileStream or FileData.
|
| 2022-12-08 | 22.0.8377 | Microsoft SharePoint | | Removed | - Removed the SchemaDirectory parameter from CreateSchema stored procedure in the SOAP schema. Instead, the Location connection property path is used to create the schema.
|
| 2022-11-30 | 22.0.8369 | Microsoft SharePoint | | Added | - Added the UseEntityTypeName property to determine if the table name should be EntityTypeName instead of the title in the REST schema.
|
| 2022-10-25 | 22.0.8333 | Microsoft SharePoint | | Added | - Added the FileStream input attribute to add outputstream and FileData output attribute to print the response in DownloadAttachment, DownloadDocument stored procedures in SOAP and REST schema.
- Added the FileStream input attribute to add outputstream and FileData output attribute to print the response in CreateSchema stored procedure in SOAP schema.
- Added the Content input attribute to add inputstream in AddAttachment, UploadDocument stored procedures in SOAP and REST schema.
|
| 2022-09-30 | 22.0.8308 | General | | Changed | - Added the IsPath column to the sys_procedureparameters table.
|
| 2022-07-29 | 22.0.8245 | Microsoft SharePoint | | Removed | - Removed the Germany enum value from AzureEnvironments, as Microsoft has retired its Germany-based cloud.
|
| 2022-06-08 | 22.0.8194 | ADO.NET | | Removed | - Removed support for VS2010.
|
| 2022-05-24 | 22.0.8179 | Microsoft SharePoint | | Changed | - Changed provider name to Microsoft SharePoint.
|
| 2022-05-19 | 22.0.8174 | ADO.NET | | Removed | - Removed support for .NET 2.0.
|
| 2022-05-19 | 22.0.8174 | Microsoft SharePoint | | Deprecated | - OAuthGrantType has been deprecated. Use the AuthScheme connection property instead.
|
| 2022-04-27 | 22.0.8152 | ADO.NET | | Removed | - Removed support for EFCore 3.0 and EFCore5.0.
|
| 2022-03-15 | 21.0.8109 | Microsoft SharePoint | | Added | - Added a new Id column for the Users view in the REST Schema.
|
| 2022-03-14 | 21.0.8108 | Microsoft SharePoint | | Added | - Added the ItemId column to get RoleAssignments, RoleAssignmentMember, RoleDefinitionBindings.
|
| 2021-09-02 | 21.0.7915 | General | | Added | - Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
|
| 2021-08-23 | 21.0.7905 | Microsoft SharePoint | | Added | - Added the CreateFolder, UploadDocument, DeleteDocument, CopyDocument, CheckInDocument, CheckOutDocument, DiscardCheckOutDocument, AddAttachment, DeleteAttachment stored procedures to the REST Schema.
|
| 2021-08-10 | 21.0.7892 | Microsoft SharePoint | | Added | - Added new AuthScheme "SharePointOAuth" to support client credentials flow using SharePoint App.
|
| 2021-08-07 | 21.0.7889 | General | | Changed | - Added the KeySeq column to the sys_foreignkeys table.
|
| 2021-08-06 | 21.0.7888 | General | | Changed | - Added the new sys_primarykeys system table.
|
| 2021-08-05 | 21.0.7887 | Microsoft SharePoint | | Removed | - Removed the Permissions view from the REST schema.
|
| 2021-08-05 | 21.0.7887 | Microsoft SharePoint | | Replacements | - Replaced Permissions with the RoleAssignments, RoleAssignmentMember, and RoleDefinitionBindings views in the REST schema.
|
| 2021-07-29 | 21.0.7880 | Microsoft SharePoint | | Added | - Added the LoginName, Title, and IsHiddenInUI columns to the Users view in the REST schema.
- Added the Id column to the Groups view in the REST schema.
|
| 2021-07-28 | 21.0.7879 | Microsoft SharePoint | | Added | - Added support for the Attachments, Permissions, and SubSites views in the REST schema.
|
| 2021-07-27 | 21.0.7878 | Microsoft SharePoint | | Added | - Added support for OAuth Authentication without JWT cert for Client Credentials by when using a SharePoint App.
|
| 2021-07-23 | 21.0.7874 | General | | Changed | - Updated the Literal Function Names for relative date/datetime functions. Previously, relative date/datetime functions resolved to a different value when used in the projection as opposed to the predicate. For example: SELECT LAST_MONTH() AS lm, Col FROM Table WHERE Col > LAST_MONTH(). Formerly, the two LAST_MONTH() methods would resolve to different datetimes. Now, they will match.
- As a replacement for the previous behavior, the relative date/datetime functions in the criteria may have an 'L' appended to them. For example: WHERE col > L_LAST_MONTH(). This will continue to resolve to the same values that were previously calculated in the criteria. Note that the "L_" prefix will only work in the predicate - it not available for the projection.
|
| 2021-06-16 | 21.0.7837 | Microsoft SharePoint | | Added | - Added support for the PingFederate identity provider in the Sharepoint Online SOAP schema.
|
| 2021-06-07 | 21.0.7828 | ADO.NET | | Added | - Added support for the DbCommand.CommandTimeout property.
|
| 2021-06-05 | 21.0.7826 | Microsoft SharePoint | | Added | - Added support for the AzureServicePrinciple authentication scheme only using a JWT certs instead of the OAuthClientSecret.
- Added support to authenticate submitting JWT certs instead of the OAuthClientSecret for the AzureServicePrinciple, OAuth, and AzureAD authentication schemes.
|
| 2021-05-29 | 21.0.7819 | ADO.NET | | Removed | - Removed support for SSRS 2008.
|
| 2021-04-25 | 21.0.7785 | General | | Added | - Added support for handling client side formulas during insert / update. For example: UPDATE Table SET Col1 = CONCAT(Col1, " - ", Col2) WHERE Col2 LIKE 'A%'
|
| 2021-04-23 | 21.0.7783 | General | | Changed | - Updated how display sizes are determined for varchar primary key and foreign key columns so they will match the reported length of the column.
|
| 2021-04-16 | 21.0.7776 | ADO.NET | | Changed | - Separated the ADO.NET Provider assembly and Entity Framework Core 5 Nuget packages.
- Single precision floating point numbers are now reported as with the Data Type Name as "real". Double precision floating point numbers now have their Data Type Name reported as "float". This change does not impact the actual data types of these columns - only the reported data type name.
- Separate EFCore 3.0, 3.1 and EFCore 5 dlls are now shipped with the driver. The 2.0 and 2.1 EFCore dlls are removed.
|
| 2021-04-16 | 21.0.7776 | General | | Added | - Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
|
| 2021-04-16 | 21.0.7776 | General | | Changed | - Reduced the length to 255 for varchar primary key and foreign key columns.
|
| 2021-04-16 | 21.0.7776 | General | | Changed | - Updated implicit and metadata caching to improve performance and support for multiple connections. Old metadata caches are not compatible - you need to generate new metadata caches if you are currently using CacheMetadata.
|
| 2021-04-16 | 21.0.7776 | General | | Changed | - Updated index naming convention to avoid duplicates.
|
| 2021-04-15 | 21.0.7775 | General | | Changed | - Kerberos authentication is updated to use TCP by default, but will fall back to UDP if a TCP connection cannot be established.
|
| 2021-03-31 | 21.0.7760 | Microsoft SharePoint | | Deprecated | - The UseSSO connection property is deprecated. Select the preferred SSO scheme directly from the AuthScheme property instead.
- The URNAddress is deprecated. This property is used inside the SSOProperties and it should be specified when authenticating to ADFS on Sharepoint On-Premise. Instead RelyingParty should be used, as in other drivers.
|
| 2020-11-03 | 20.0.7612 | Microsoft SharePoint | | Added | - Added support for retrieving information regarding the current logged in user via the GetCurrentUser stored procedure.
|