ADO.NET Provider for LinkedIn Marketing Solutions

Build 26.0.9655

Changelog

General Changes

DateVersionSourceCategoryTypeDescription
2026-05-2826.0.9644LinkedIn Marketing SolutionsData ModelAdded
  • Added the TemplateName and LinkbackContext input parameters to the UploadVideo stored procedure.
2026-05-2726.0.9643GeneralConnectionRemoved
  • Removed the deprecated ReplaceInvalidTypesWithNull connection property. Use the ReplaceInvalidValuesWithNull property instead.
2026-05-1426.0.9630LinkedIn Marketing SolutionsData ModelRemoved
  • Removed the deprecated Account column from the Creatives, Campaigns, and CampaignGroups tables.
2026-05-1126.0.9627LinkedIn Marketing SolutionsData ModelAdded
  • In the Campaigns table, added a new option, MAX_QUALIFIED_LEAD, to the OptimizationTargetType enum.
  • Added the following metrics to the Analytics views: VideoWatchTime, AverageVideoWatchTime, EventViews, EventWatchTime, AverageEventWatchTime, CostPerEventView.
2026-05-1126.0.9627LinkedIn Marketing SolutionsData ModelChanged
  • In the BrandLiftTests table, renamed CampaignGroupURN column to CampaignGroups.
2026-05-0726.0.9623GeneralData ModelAdded
  • Added the ColumnCapabilities column to the sys_tablecolumns system table. This column is a bit mask denoting the column's write capabilities.
2026-05-0426.0.9620LinkedIn Marketing SolutionsData ModelChanged
  • The Posts table now returns only sponsored posts. Previously, the table also returned organic posts.
    • The FeedDistribution column is now read-only. Its value is always NONE.
2026-04-2826.0.9614ADO.NETConnectionAdded
  • 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-1526.0.9601GeneralQuery ExecChanged
  • String comparisons using GREATER, LESS, and CONTAINS operators are now case-insensitive by default.
2026-04-0826.0.9594LinkedIn Marketing SolutionsSecurityChanged
  • TLS 1.3 is now supported by default for HTTP connections.
2026-04-0326.0.9589LinkedIn Marketing SolutionsData ModelChanged
  • Changed the data type of the AverageDwellTime column in the Analytics view from long to decimal.
2026-04-0126.0.9587ADO.NETAdded
  • Added support for EFCore 10.
2026-03-0525.0.9560LinkedIn Marketing SolutionsQuery ExecAdded
  • Added support for multiple projections in the Analytics view.
    • FinderMethod Statistics now supports querying up to three dimensions.
    • FinderMethod Analytics allows up to two dimensions under certain conditions.
2026-01-2025.0.9516LinkedIn Marketing SolutionsAdded
  • Added support for INSERT operations to the ConversationCreatives and ConversationCreativeActions tables.
  • Added support for UPDATE operations to the ConversationCreativeActions table.
  • Added the DMPSegments table.
  • Added the EngagementRules view.
2026-01-1325.0.9509GeneralAdded
  • Added support for the REGEXP_REPLACE() string function.
2025-12-0525.0.9470GeneralAdded
  • Added support for the INSERT INTO SELECT statement, with driver-side execution for providers that do not support the operation natively.
2025-12-0225.0.9467LinkedIn Marketing SolutionsAdded
  • Added the SavedAudienceTemplates table.
2025-11-2025.0.9455LinkedIn Marketing SolutionsAdded
  • Added the PoliticalIntent column to the Campaigns table.
2025-11-0625.0.9441LinkedIn Marketing SolutionsAdded
  • Added the HiddenFields aggregate column in the Forms table.
2025-11-0325.0.9438LinkedIn Marketing SolutionsAdded
  • Added AccountURN and AssetName input parameters to the UploadImage and UploadVideo stored procedures.
2025-10-3125.0.9435LinkedIn Marketing SolutionsAdded
  • Draft posts (LifecycleState = DRAFT) are included in the results of SELECT queries on the Posts table.
2025-10-2725.0.9431LinkedIn Marketing SolutionsAdded
  • Added the Images and Videos tables.
  • Added the OrganizationRoleAssignments and Documents views.
  • Added the UploadDocument, UploadImage, UploadVideo, UploadVideoThumbnail, UploadVideoCaptions, and DownloadAsset stored procedures.
2025-10-2725.0.9431LinkedIn Marketing SolutionsChanged
  • Updated the default value of the Scope connection property to include the r_organization_admin scope.
2025-10-0625.0.9410GeneralAdded
  • Support for parsing datetime formats using ".S" and ",S" for milliseconds and nanoseconds.
2025-09-1225.0.9386GeneralAdded
  • Added the IsInsertable, IsUpdateable, and IsDeleteable columns to the sys_tables table.
2025-09-1025.0.9384GeneralChanged
  • All columns in statically defined Views are now reported as read-only.
2025-09-0325.0.9377GeneralChanged
  • 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-0125.0.9375GeneralAdded
  • Added support for using the CAST function with infinity values. This function can cast "inf" and "-inf" to DOUBLE, FLOAT, or REAL.
2025-08-2925.0.9372LinkedIn Marketing SolutionsAdded
  • Added the AccountUsers, PublisherRestrictionFiles, MessageCreatives, and BrandLiftTests tables as well as the IABCategories, ConversationCreativeActions, ConversationCreatives, TargetingEntities, and TargetingFacets views.
  • Added the URN column to the Accounts and CampaignGroups views.
  • Added the BlockedIABCategories, AllowedPublisherRestrictionFiles, and BlockedPublisherRestrictionFiles columns to the Campaigns table.
2025-08-2125.0.9364GeneralChanged
  • 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-1525.0.9358LinkedIn Marketing SolutionsChanged
  • Changed AdAccountId from a pseudocolumn to a column in the Creatives, Campaigns, and CampaignGroups tables.
2025-08-1525.0.9358LinkedIn Marketing SolutionsDeprecated
  • Deprecated the Account column in the Creatives, Campaigns, and CampaignGroups tables.
2025-08-1325.0.9356GeneralChanged
  • Changed the maximum number of pages held in memory from 15 to 5 for the page providers to decrease heap usage.
2025-07-2325.0.9335LinkedIn Marketing SolutionsAdded
  • Added support for INSERT statements for the Accounts, CampaignGroups, Campaigns, Creatives, Posts, Conversions, Forms, and ThirdPartyTracking tables.
  • Added support for UPDATE statements for the Accounts, CampaignGroups, Campaigns, Creatives, Posts, and Forms tables.
  • Added support for DELETE statements for the Accounts, CampaignGroups, Campaigns, Creatives, Posts, and ThirdPartyTracking tables.
  • Added the IsTest column to the Accounts table.
  • Added the OptimizationType and OptimizationTargetType columns to the Campaigns table.
  • Added the AutoAssociationType column to the Conversions table.
  • Added the Questions and Message columns to the Forms table.
  • Added the FeedDistribution column to the Posts table.
2025-07-2325.0.9335LinkedIn Marketing SolutionsRemoved
  • Removed the DomainID column from the Conversions table.
2025-07-2325.0.9335LinkedIn Marketing SolutionsChanged
  • Changed the datatypes of the Created, LastModified, and LastCallbackAt columns in the Conversions table from string to DateTime.
  • Changed the datatype of the Enabled column in the Conversions table from string to boolean.
2025-06-2525.0.9307GeneralRemoved
  • Removed the "ADLS Gen 1" value from the ConnectionType property.
2025-06-2025.0.9302GeneralAdded
  • 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-1825.0.9300GeneralChanged
  • The internal code for exception handling has been refactored. Exception messages returned during certain error conditions may now have different wording or formatting.
2025-05-2925.0.9280ADO.NETChanged
  • 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-2725.0.9278ADO.NETRemoved
  • 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-2725.0.9278GeneralRemoved
  • Removed the "Proprietary" enum option from ProxyAuthscheme.
2025-05-2725.0.9278LinkedIn Marketing SolutionsAdded
  • Added the Function and SuperTitle columns to the Titles view.
2025-04-0225.0.9223LinkedIn Marketing SolutionsAdded
  • Added the new metric column DocumentCompletions in the Analytics view.
2025-02-2125.0.9183LinkedIn Marketing SolutionsRemoved
  • Removed the CampaignInsights view, due to a deprecation in the LinkedIn Marketing API.
2025-02-1724.0.9179LinkedIn Marketing SolutionsAdded
  • Added two new metric columns in the Analytics view: AudiencePenetration, and AverageDwellTime.
2025-02-1524.0.9177GeneralAdded
  • 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-1624.0.9147LinkedIn Marketing SolutionsAdded
  • Added the following columns to the Campaigns view: ConnectedTelevisionOnly, TimeSpanDuration, TimeSpanUnit, and Frequency.
  • Added the Name column to the Creatives view.
  • Added the EventStage column to the Analytics view.
2024-11-2724.0.9097GeneralAdded
  • Added ThreadId to LogModule output. Logfile lines now include the Thread ID associated with the action being performed.
2024-09-0624.0.9015LinkedIn Marketing SolutionsAdded
  • In the Posts view, added the ContentLandingPage, IsDirectSponsoredContent, DirectSponsoredContentAdAccount, DirectSponsoredContentAdType, DirectSponsoredContentName, and DirectSponsoredContentStatus columns.
2024-08-2824.0.9006LinkedIn Marketing SolutionsAdded
  • Added the QualifiedLeads, CostPerQualifiedLead, MessagingAdvertSendCount, and MessagingAdvertOpenCount metrics to the Analytics view.
2024-07-2924.0.8976LinkedIn Marketing SolutionsAdded
  • Added 3 new columns in the Analytics view: PostClickRegistrations, PostViewRegistrations, and DownloadClicks.
2024-07-2624.0.8973LinkedIn Marketing SolutionsAdded
  • Added 3 new columns in the Creatives view: CallToActionLabel, CallToActionFormId, and RejectionReasons.
2024-06-1324.0.8930LinkedIn Marketing SolutionsAdded
  • Added "OAuthRefreshToken" output.
2024-05-2124.0.8907LinkedIn Marketing SolutionsRemoved
  • Removed support for the APIVersion connection property. The driver now automatically uses the latest API version for most entities and selects the appropriate version for unsupported entities.
2024-05-0924.0.8895GeneralChanged
  • The ROUND function previously did not accept negative precision values. That feature has now been restored.
2024-05-0924.0.8895LinkedIn Marketing SolutionsChanged
  • Changed the default **APIVersion** property value from *202401* to the latest version, which is **202404**.
2024-04-1123.0.8867LinkedIn Marketing SolutionsAdded
  • Added the GeoLocations view.
  • Added the ApproximateMemberReach column in the Analytics view.
2024-04-1123.0.8867LinkedIn Marketing SolutionsRemoved
  • Removed the CampaignRecommendations view.
  • Removed the Locations view.
  • Removed the ApproximateUniqueImpressions column from the Analytics view.
2024-04-1123.0.8867LinkedIn Marketing SolutionsReplaced
  • Replaced the Locations view with the GeoLocations view.
  • Replaced the deprecated ApproximateUniqueImpressions metric in favor of the new ApproximateMemberReach metric in the Analytics view.
2024-03-1523.0.8840GeneralAdded
  • 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-01-1823.0.8783ADO.NETAdded
  • Added support for EFCore 8.
2023-11-2923.0.8733GeneralChanged
  • The ROUND function doesn't accept the negative precision values anymore.
2023-11-2923.0.8733GeneralChanged
  • 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-2823.0.8732GeneralAdded
  • Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
2023-11-1523.0.8719ADO.NETChanged
  • NuGet license and icon are now embedded within the package itself, in compliance with the package authoring best practices.
2023-06-2023.0.8571GeneralAdded
  • Added the new sys_lastresultinfo system table.
2023-04-2523.0.8515GeneralRemoved
  • Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
2023-04-1923.0.8509ADO.NETRemoved
  • Removed support for EFCore 3.1.
2023-04-1823.0.8508ADO.NETRemoved
  • Removed support for SSRS 2012
2023-04-1823.0.8508ADO.NETAdded
  • Added support for SSRS 2022.
2023-02-2422.0.8455LinkedIn Marketing SolutionsRemoved
  • LinkedIn is no longer accepting access requests for the "r_member_social" scope due to resource constraints. We have removed "r_member_social" scope from default requested scopes during authorization process.
2022-12-1422.0.8383GeneralChanged
  • Added the Default column to the sys_procedureparameters table.
2022-11-0922.0.8348LinkedIn Marketing SolutionsAddedAdded support for the objectiveType field in the Campaigns table. It represents the campaign objective type and can have the values: "BRAND_AWARENESS,ENGAGEMENT,JOB_APPLICANTS,LEAD_GENERATION,WEBSITE_CONVERSIONS,WEBSITE_VISITS,VIDEO_VIEWS"
2022-11-0722.0.8346LinkedIn Marketing SolutionsAdded
  • Added ChildrenIndustries and ParentIndustries as columns to the Industries table. The table now exposes the newly added API which offers a hierarchical structure and returns more industries.
2022-10-2422.0.8332LinkedIn Marketing SolutionsAdded
  • Added support for the new versioning feature of the LinkedIn Marketing API. The API version can be controlled by the APIVersion connection property. The changes that come with this are forced because LinkedIn plans to sunset the unversioned (legacy) API on February 2023. The biggest changes have been made to the Creatives and UGCPosts tables.
  • The following columns have been added to the Creatives table: Account, CreatedBy, and LastModifiedBy.
  • The following columns have been added to the Posts table: Commentary, Content, IsReshareDisabledByAuthor, PublishedAt, and Visibility.
  • Added the ApproximateUniqueImpressions metric to the Analytics table.
2022-10-2422.0.8332LinkedIn Marketing SolutionsRemoved
  • Removed the UGCPosts table.
  • The following columns have been removed from the Posts table: LastModifiedActor, LastModifiedTime, CreatedActor, CreatedTime, Origin, UGCOrigin, VersionTag, and PersonId.
  • The following columns have been removed from the Creatives table: Status, Type, Version, ReviewRejectionReason, Reference, CreativesClickUri, Data, ProcessingState, and ServingStatuses.
2022-10-2422.0.8332LinkedIn Marketing SolutionsReplacements
  • The new Posts table replaces UGCPosts.
  • For the Posts table: CreatedAt replaces CreatedTime and LastModifiedAt replaces LastModifiedTime.
  • For the Creatives table: IntendedStatus replaces Status, IsServing and ServingHoldReasons replace ServingStatuses, and Content replaces Reference/Data.
2022-09-3022.0.8308GeneralChanged
  • Added the IsPath column to the sys_procedureparameters table.
2022-09-1822.0.8296LinkedIn Marketing SolutionsAdded
  • Added support for the AdFormResponses view.
2022-06-2422.0.8210LinkedIn Marketing SolutionsAdded
  • Added nine new metrics for the Analytics table. These are reach metrics that correspond to the last 1, 7, or 30 days based on the date range and include data about the average reach, impressions, and spend on ads.
2022-06-0822.0.8194ADO.NETRemoved
  • Removed support for VS2010.
2022-05-2422.0.8179LinkedIn Marketing SolutionsChanged
  • Changed provider name to LinkedIn Marketing Solutions.
2022-05-1922.0.8174ADO.NETRemoved
  • Removed support for .NET 2.0.
2022-05-1222.0.8167LinkedIn Marketing SolutionsAdded
  • Added support for paginating the Accounts, Campaigns, CampaignGroups, and Creatives tables. The API throws '400 Bad Request' error in case the response returns more than a specific number of results. The maximum number of results returned for one page is controlled by the PageSize connection property.
2022-04-2722.0.8152ADO.NETRemoved
  • Removed support for EFCore 3.0 and EFCore5.0.
2021-12-0921.0.8013LinkedIn Marketing SolutionsAdded
  • Added ReviewRejectionReason, Data, ProcessingState, IsTest, and ServingStatuses as columns for the Creatives table.
2021-12-0721.0.8011LinkedIn Marketing SolutionsAdded
  • Added the OLAP properties Dimension, Hierarchy and OLAPType as extra columns to sys_tablecolumns.
2021-09-0221.0.7915GeneralAdded
  • Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
2021-08-0721.0.7889GeneralChanged
  • Added the KeySeq column to the sys_foreignkeys table.
2021-08-0621.0.7888GeneralChanged
  • Added the new sys_primarykeys system table.
2021-07-2321.0.7874GeneralChanged
  • 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-0721.0.7828ADO.NETAdded
  • Added support for the DbCommand.CommandTimeout property.
2021-05-2921.0.7819ADO.NETRemoved
  • Removed support for SSRS 2008.
2021-04-2521.0.7785GeneralAdded
  • 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-2321.0.7783GeneralChanged
  • 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-1621.0.7776ADO.NETChanged
  • 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-1621.0.7776GeneralAdded
  • Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
2021-04-1621.0.7776GeneralChanged
  • Reduced the length to 255 for varchar primary key and foreign key columns.
2021-04-1621.0.7776GeneralChanged
  • 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-1621.0.7776GeneralChanged
  • Updated index naming convention to avoid duplicates.
2020-12-2920.0.7668LinkedIn Marketing SolutionsAdded
  • Added support for refreshing the OAuth Access Token.
2020-10-0820.0.7586LinkedIn Marketing SolutionsRemoved
  • Removed the deprecated columns TotalBudgetAmount, TotalBudgetCurrency and TotalBudgetEndsAt from the Accounts view. All budget and run date information should be queried from the CampaignGroup view via the columns: TotalBudgetAmount, TotalBudgetCurrencyCode and ScheduleEndTime.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655