Indice.Features.Messages.Core 8.18.2

There is a newer version of this package available.
See the version list below for details.
dotnet add package Indice.Features.Messages.Core --version 8.18.2
                    
NuGet\Install-Package Indice.Features.Messages.Core -Version 8.18.2
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Indice.Features.Messages.Core" Version="8.18.2" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Indice.Features.Messages.Core" Version="8.18.2" />
                    
Directory.Packages.props
<PackageReference Include="Indice.Features.Messages.Core" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Indice.Features.Messages.Core --version 8.18.2
                    
#r "nuget: Indice.Features.Messages.Core, 8.18.2"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package Indice.Features.Messages.Core@8.18.2
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Indice.Features.Messages.Core&version=8.18.2
                    
Install as a Cake Addin
#tool nuget:?package=Indice.Features.Messages.Core&version=8.18.2
                    
Install as a Cake Tool

Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

[8.17.3] - 2025-09-30

Added New column

ALTER TABLE [cmp].[Contact] 
    ADD [LastResolutionDate]     [datetimeoffset](7)      NULL
GO

[8.16.0] - 2025-09-19

Added New column

ALTER TABLE [cmp].[Contact] 
    ADD [Resolved]     bit      NULL
GO
CREATE NONCLUSTERED INDEX [IX_Contact_RecipientId_Resolved] 
    ON [cmp].[Contact] ([RecipientId] ASC, [Resolved] ASC)
GO
CREATE NONCLUSTERED INDEX [IX_Campaign_CreatedAt]
    ON [cmp].[Campaign] ([CreatedAt] ASC)
GO
CREATE NONCLUSTERED INDEX [IX_MessageEvent_Type]
    ON [cmp].[MessageEvent] ([Type] ASC)
GO
CREATE NONCLUSTERED INDEX [IX_MessageEvent_Channel]
    ON [cmp].[MessageEvent] ([Channel] ASC)
GO

[8.1.10] - 2025-08-05

Added support alias in Distribution list

ALTER TABLE [msg].[DistributionList] 
    ADD [Alias]     NVARCHAR (64)      NULL
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_DistributionList_Alias]
    ON [msg].[DistributionList]([Alias] ASC) WHERE ([Alias] IS NOT NULL);
GO

Added support to persist communication preferences for users.

Add Message type in template table for linking templates to message types and eventually preferences.

ALTER TABLE [#schema#].[Template]
	ADD [MessageTypeId]  UNIQUEIDENTIFIER  
ALTER TABLE [#schema#].[Template] WITH NOCHECK
    ADD CONSTRAINT [FK_Template_MessageType_MessageTypeId] FOREIGN KEY ([MessageTypeId]) REFERENCES [msg].[MessageType] ([Id]);
ALTER TABLE [#schema#].[Template] WITH CHECK CHECK CONSTRAINT [FK_Template_MessageType_MessageTypeId];

The following migration script is needed to add the ContactPreference and ContactCommunicationOption tables.

CREATE TABLE [#schema#].[ContactPreference] (
    [Id]                    UNIQUEIDENTIFIER   NOT NULL,
    [RecipientId]           NVARCHAR (64)      NOT NULL,
    [Locale]                NVARCHAR (16)      NULL,
    [ConsentCommercial]     BIT                NOT NULL,
    [ConsentCommercialDate] DATETIMEOFFSET (7) NULL,
    [DefaultChannels]       TINYINT            NULL,
    [UpdatedAt]             DATETIMEOFFSET (7) NULL,
    CONSTRAINT [PK_ContactPreference] PRIMARY KEY CLUSTERED ([Id] ASC)
);
GO

CREATE UNIQUE NONCLUSTERED INDEX [IX_ContactPreference_RecipientId]
    ON [#schema#].[ContactPreference]([RecipientId] ASC);
GO

CREATE TABLE [#schema#].[ContactCommunicationOption] (
    [ContactPreferenceId] UNIQUEIDENTIFIER   NOT NULL,
    [MessageTypeId]       UNIQUEIDENTIFIER   NOT NULL,
    [Channels]            TINYINT            DEFAULT (CONVERT([tinyint],(0))) NOT NULL,
    [UpdatedAt]           DATETIMEOFFSET (7) NULL,
    CONSTRAINT [PK_ContactCommunicationOption] PRIMARY KEY CLUSTERED ([ContactPreferenceId] ASC, [MessageTypeId] ASC),
    CONSTRAINT [FK_ContactCommunicationOption_ContactPreference_ContactPreferenceId] FOREIGN KEY ([ContactPreferenceId]) REFERENCES [#schema#].[ContactPreference] ([Id]) ON DELETE CASCADE,
    CONSTRAINT [FK_ContactCommunicationOption_MessageType_MessageTypeId] FOREIGN KEY ([MessageTypeId]) REFERENCES [#schema#].[MessageType] ([Id]) ON DELETE CASCADE
);
GO

CREATE NONCLUSTERED INDEX [IX_ContactCommunicationOption_MessageTypeId]
    ON [#schema#].[ContactCommunicationOption]([MessageTypeId] ASC);
GO

In case that you have used communication preferences in your project, you need to run the following migration script to populate the CommunicationPreference and CommunicationPreferenceMessageType tables.


CREATE TABLE #TempContactPreference
(
    [RecipientId] nvarchar(64) NOT NULL,
    [Locale] nvarchar(16) NULL,
    [ConsentCommercial] bit NOT NULL DEFAULT(0),
    [DefaultChannels] TINYINT NULL
);

INSERT INTO #TempContactPreference
    ([RecipientId]
    ,[Locale]
    ,[ConsentCommercial]
    ,[DefaultChannels])
SELECT RecipientId, Locale, ConsentCommercial,CommunicationPreferences
FROM (
    SELECT RecipientId, Locale, ConsentCommercial,CommunicationPreferences,
        row_number() over (partition by RecipientId order by [UpdatedAt] desc) as rn
    FROM [msg].[Contact]
    WHERE NULLIF(RecipientId,'') IS NOT NULL
) t
WHERE rn = 1 


INSERT INTO [msg].[ContactPreference]
    ([Id]
    ,[RecipientId]
    ,[Locale]
    ,[ConsentCommercial])
SELECT NEWID(),  RecipientId, Locale, ConsentCommercial
FROM  #TempContactPreference AS CT
WHERE NOT EXISTS (SELECT TOP 1 1 FROM  [msg].[ContactPreference] WHERE RecipientId = ct.RecipientId)


DROP TABLE #TempContactPreference    

The last step is to drop the prefernece columns from the Contact table.

ALTER TABLE [#schema#].[Contact] DROP COLUMN [CommunicationPreferences], COLUMN [ConsentCommercial], COLUMN [Locale];

[8.1.0] - 2025-06-15

For performance reasons, the following indexes were added to the media schema in cases db.


CREATE NONCLUSTERED INDEX [IX_MediaFile_FolderId]
    ON [media].[MediaFile]([FolderId] ASC);
GO

CREATE NONCLUSTERED INDEX [IX_MediaFile_Name]
    ON [media].[MediaFile]([Name] ASC);
GO

CREATE UNIQUE NONCLUSTERED INDEX [IX_MediaFile_Path]
    ON [media].[MediaFile]([Path] ASC);
GO

CREATE NONCLUSTERED INDEX [IX_MediaFolder_Name]
    ON [media].[MediaFolder]([Name] ASC);
GO

CREATE NONCLUSTERED INDEX [IX_MediaFolder_ParentId]
    ON [media].[MediaFolder]([ParentId] ASC);
GO

CREATE UNIQUE NONCLUSTERED INDEX [IX_MediaFolder_Path]
    ON [media].[MediaFolder]([Path] ASC);
GO

For performance reasons, the following indexes were added to the messaging schema in cases db.


CREATE NONCLUSTERED INDEX [IX_Campaign_AttachmentId]
    ON [#Schema#].[Campaign]([AttachmentId] ASC);
GO

CREATE NONCLUSTERED INDEX [IX_Campaign_DistributionListId]
    ON [#Schema#].[Campaign]([DistributionListId] ASC);
GO

CREATE NONCLUSTERED INDEX [IX_Campaign_TypeId]
    ON [#Schema#].[Campaign]([TypeId] ASC);
GO


CREATE UNIQUE NONCLUSTERED INDEX [IX_Contact_RecipientId]
    ON [#Schema#].[Contact]([RecipientId] ASC) WHERE ([RecipientId] IS NOT NULL);
GO


CREATE UNIQUE NONCLUSTERED INDEX [IX_Contact_RecipientId]
    ON [#Schema#].[Contact]([RecipientId] ASC) WHERE ([RecipientId] IS NOT NULL);
GO

CREATE UNIQUE NONCLUSTERED INDEX [IX_DistributionList_Name]
    ON [#Schema#].[DistributionList]([Name] ASC);
GO

CREATE NONCLUSTERED INDEX [IX_DistributionListContact_DistributionListId]
    ON [#Schema#].[DistributionListContact]([DistributionListId] ASC);
GO


CREATE NONCLUSTERED INDEX [IX_Hit_CampaignId]
    ON [#Schema#].[Hit]([CampaignId] ASC);
GO

CREATE NONCLUSTERED INDEX [IX_Message_CampaignId]
    ON [#Schema#].[Message]([CampaignId] ASC);
GO

CREATE NONCLUSTERED INDEX [IX_Message_RecipientId]
    ON [#Schema#].[Message]([RecipientId] ASC);
GO

CREATE NONCLUSTERED INDEX [IX_MessageSender_Sender]
    ON [#Schema#].[MessageSender]([Sender] ASC);
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_MessageType_Alias]
    ON [#Schema#].[MessageType]([Alias] ASC) WHERE ([Alias] IS NOT NULL);
GO

CREATE UNIQUE NONCLUSTERED INDEX [IX_MessageType_Name]
    ON [#Schema#].[MessageType]([Name] ASC);
GO


CREATE UNIQUE NONCLUSTERED INDEX [IX_Template_Alias]
    ON [#Schema#].[Template]([Alias] ASC) WHERE ([Alias] IS NOT NULL);
GO

CREATE UNIQUE NONCLUSTERED INDEX [IX_Template_Name]
    ON [#Schema#].[Template]([Name] ASC);
GO


[8.0.0-rc32] - 2025-05-25

  • Added support for logging message events.
CREATE TABLE [#Schema#].[MessageEvent](
	[Id] [uniqueidentifier] NOT NULL,
	[CampaignId] [uniqueidentifier] NOT NULL,
	[ContactId] [uniqueidentifier] NOT NULL,
	[MessageId] [uniqueidentifier] NULL,
	[Type] [nvarchar](64) NOT NULL,
	[Channel] [nvarchar](64) NOT NULL,
	[CreatedOn] [datetimeoffset](7) NOT NULL,
 CONSTRAINT [PK_MessageEvent] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

[8.0.0] - 2024-12-03

  • Added support for persisting User communication channel preferences, locale and Consent.
  • Campaign and Template define whether user communication preferences must be ingored if needed.
  • Send messages respects user communication preferences unless campaign specifies otherwise
ALTER TABLE [#Schema#].[Campaign]
ADD IgnoreUserPreferences BIT DEFAULT(0) NOT NULL;
GO
ALTER TABLE [#Schema#].[Contact]
ADD 
	CommunicationPreferences TINYINT DEFAULT(0) NOT NULL,
	ConsentCommercial		 BIT DEFAULT(0) NOT NULL,
	Locale					 VARCHAR(16);
GO
ALTER TABLE [#Schema#].[DistributionListContact]
ADD Unsubscribed BIT DEFAULT(0) NOT NULL;	
GO
ALTER TABLE [#Schema#].[Template]
ADD IgnoreUserPreferences BIT DEFAULT(0) NOT NULL;
GO
ALTER TABLE [#Schema#].[MessageType]
ADD Classification TINYINT DEFAULT(0) NOT NULL;		
GO

[7.27.0] - 2024-07-26

Added

  • Added support for persisting sample data for facilitating template rendering on message templates.
ALTER TABLE [cmp].[Template]
ADD [Data] [nvarchar](max) NULL
GO

[7.23.0] - 2024-05-16

Added

  • New column MediaBaseHref in DbCampaign
ALTER TABLE [cmp].[Campaign]
ADD [MediaBaseHref] [nvarchar](1024) NULL

[7.4.4] - 2023-10-04

Added

  • ContactRetainPeriodInDays option to keep in sync a contact with the identity system. After the configured period of time the system patches and updates the contact with the latest values.

[7.4.1] - 2023-09-22

Changed

  • CampaignId is returned in PushNotification data in property "messageId". Intentioanally added for naming consistency. external MessageId == internal CampaignId.

[7.3.8] - 2023-08-07

Added

  • Message Id is included in PushNotification data
  • Inbox service enhanced to return other channels also

[7.3.7] - 2023-08-02

Added

  • New entity DbMessageSender

Migration

CREATE TABLE [dbo].[MessageSender](
	[Id] [uniqueidentifier] NOT NULL,
	[Sender] [nvarchar](max) NULL,
	[DisplayName] [nvarchar](max) NULL,
	[Kind] [tinyint] NOT NULL,
	[IsDefault] [bit] NOT NULL,
	[CreatedBy] [nvarchar](max) NULL,
	[CreatedAt] [datetimeoffset](7) NOT NULL,
	[UpdatedBy] [nvarchar](max) NULL,
	[UpdatedAt] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_MessageSender] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (5)

Showing the top 5 NuGet packages that depend on Indice.Features.Messages.Core:

Package Downloads
Indice.Features.Messages.AspNetCore

Package Description

Indice.Features.Messages.Worker.Azure

Package Description

Indice.Features.Messages.Worker

Package Description

Indice.Hive.Core

Package Description

Indice.Hive.Server

Package Description

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
8.19.0 43 10/19/2025
8.18.3 184 10/10/2025
8.18.2 156 10/10/2025
8.18.1 224 10/8/2025
8.18.0 234 10/1/2025
8.17.3 239 9/30/2025
8.17.2 249 9/25/2025
8.17.1 220 9/25/2025
8.17.0 249 9/24/2025
8.16.1 272 9/22/2025
8.16.0 268 9/19/2025
8.15.0 431 9/16/2025
8.14.3 188 9/12/2025
8.14.2 217 9/11/2025
8.14.1 202 9/10/2025
8.14.0 205 9/10/2025
8.13.0 251 9/1/2025
8.12.0 231 8/29/2025
8.11.0 251 8/27/2025
8.10.0 307 8/5/2025
8.9.0 169 7/30/2025
8.8.0 142 7/29/2025
8.7.0 591 7/23/2025
8.6.0 581 7/23/2025
8.5.0 569 7/21/2025
8.4.0 230 7/17/2025
8.3.0 222 7/17/2025
8.2.0 904 6/26/2025
8.1.0 210 6/20/2025
8.1.0-rc04 240 6/18/2025
8.1.0-rc03 307 6/13/2025
8.1.0-rc02 306 6/13/2025
8.1.0-rc01 359 6/11/2025
8.0.1 456 6/5/2025
8.0.0 262 6/3/2025
8.0.0-rc32 229 5/27/2025
8.0.0-rc31 281 5/22/2025
8.0.0-rc30 237 5/20/2025
8.0.0-rc29 193 5/9/2025
8.0.0-rc28 270 5/7/2025
8.0.0-rc27 250 4/30/2025
8.0.0-rc26 256 4/24/2025
8.0.0-rc25 359 4/2/2025
8.0.0-rc24 242 3/27/2025
8.0.0-rc23 257 3/19/2025
8.0.0-rc22 378 3/6/2025
8.0.0-rc21 321 3/5/2025
8.0.0-rc20 199 2/27/2025
8.0.0-rc19 235 2/21/2025
8.0.0-rc18 196 2/20/2025
8.0.0-rc17 177 2/17/2025
8.0.0-rc16 195 2/11/2025
8.0.0-rc15 376 2/3/2025
8.0.0-rc14 198 1/30/2025
8.0.0-rc13 194 1/23/2025
8.0.0-rc12 170 1/20/2025
8.0.0-rc11 175 1/13/2025
8.0.0-rc10 215 1/3/2025
8.0.0-rc09 223 12/10/2024
8.0.0-rc08 185 12/6/2024
8.0.0-rc07 187 12/6/2024
8.0.0-rc06 188 12/6/2024
8.0.0-rc05 190 12/6/2024
8.0.0-rc04 174 12/4/2024
8.0.0-rc03 161 12/2/2024
8.0.0-rc02 140 12/1/2024
8.0.0-rc01 91 11/29/2024
7.47.0 677 11/28/2024
7.46.0 229 11/27/2024
7.45.0 233 11/26/2024
7.44.0 256 11/26/2024
7.43.4 243 11/25/2024
7.43.3 230 11/22/2024
7.43.2 264 11/22/2024
7.43.1 237 11/22/2024
7.43.0 219 11/22/2024
7.42.0 248 11/21/2024
7.41.0 248 11/15/2024
7.40.0 244 11/14/2024
7.39.0 236 11/6/2024
7.38.0 241 11/5/2024
7.37.0 233 11/1/2024
7.36.0 236 10/30/2024
7.35.0 247 10/30/2024
7.34.0 3,322 10/24/2024
7.33.0 249 10/23/2024
7.32.0 282 10/18/2024
7.31.0 310 10/3/2024
7.30.0 273 9/25/2024
7.29.0 406 9/10/2024
7.28.0 500 7/26/2024
7.27.0 224 7/25/2024
7.26.0 207 7/24/2024
7.25.0 484 7/12/2024
7.24.0 293 6/26/2024
7.23.1 279 6/26/2024
7.23.0 283 6/3/2024
7.22.5 669 5/13/2024
7.22.4 329 4/2/2024
7.22.3 304 3/21/2024
7.22.2 285 3/21/2024
7.22.1 314 3/21/2024
7.22.0 538 3/14/2024
7.21.0 307 3/12/2024
7.20.1 303 2/15/2024
7.20.0 399 2/8/2024
7.19.0 293 1/29/2024
7.18.0 351 1/9/2024
7.17.0 325 1/5/2024
7.16.0 292 1/4/2024
7.15.0 289 1/3/2024
7.14.0 372 12/15/2023
7.13.0 306 12/12/2023
7.12.0 337 12/11/2023
7.11.1 336 11/29/2023
7.11.0 288 11/27/2023
7.10.0 290 11/24/2023
7.8.0 286 11/17/2023
7.7.0 324 11/1/2023
7.6.4 313 10/20/2023
7.6.3 315 10/13/2023
7.6.2 312 10/12/2023
7.6.1 370 10/11/2023
7.6.1-beta-01 169 10/11/2023
7.6.0 330 10/10/2023
7.5.1 316 10/10/2023
7.5.0 317 10/5/2023
7.4.4 321 10/4/2023
7.4.3 347 9/28/2023
7.4.2 342 9/27/2023
7.4.1 314 9/22/2023
7.4.0 290 9/19/2023
7.3.24 312 9/15/2023
7.3.23 324 9/14/2023
7.3.22 305 9/12/2023
7.3.21 341 9/8/2023
7.3.20 318 9/6/2023
7.3.19 302 9/6/2023
7.3.18 324 9/5/2023
7.3.17 4,792 8/29/2023
7.3.16 345 8/24/2023
7.3.15 340 8/24/2023
7.3.14 303 8/23/2023
7.3.13 328 8/22/2023
7.3.12 342 8/14/2023
7.3.11 356 8/10/2023
7.3.10 353 8/10/2023
7.3.9 369 8/10/2023
7.3.8 379 8/9/2023
7.3.7 362 8/2/2023
7.3.6 382 7/24/2023
7.3.5 495 7/10/2023
7.3.4 359 7/10/2023
7.3.3 387 7/6/2023
7.3.2 369 7/5/2023
7.3.1 431 6/26/2023
7.2.0 454 5/29/2023
7.1.6 402 5/9/2023
7.1.5 381 5/8/2023
7.1.4 424 5/2/2023
7.1.3 443 4/24/2023
7.1.2 472 4/19/2023
7.1.1 465 4/19/2023
7.1.0 497 4/13/2023
7.0.9 481 4/12/2023
7.0.8 514 4/11/2023
7.0.7 495 4/6/2023
7.0.6 521 4/2/2023
7.0.5 527 3/30/2023
7.0.4 553 3/29/2023
7.0.3 504 3/27/2023
7.0.2 561 3/23/2023
7.0.1 412 3/23/2023
7.0.0 545 3/23/2023
6.12.3 596 3/22/2023
6.12.1 535 3/20/2023
6.12.0 581 3/17/2023
6.11.1 563 3/6/2023
6.11.0 542 3/3/2023
6.10.2 639 2/16/2023
6.10.1 637 2/15/2023
6.10.0 654 2/8/2023
6.9.0 644 2/6/2023
6.8.0 681 2/3/2023
6.7.0 645 2/2/2023
6.6.0 684 1/30/2023
6.5.0 669 1/24/2023
6.4.10 889 1/20/2023
6.4.9 624 1/20/2023
6.4.5 858 1/19/2023
6.4.0 901 12/22/2022
6.2.1 1,051 11/16/2022
6.2.0 878 11/15/2022
6.1.14 1,036 11/14/2022
6.1.13 1,064 11/11/2022
6.1.12 1,271 10/3/2022
6.1.11 1,302 9/30/2022
6.1.10 1,332 9/23/2022
6.1.9 1,310 9/13/2022
6.1.8 1,373 9/1/2022
6.1.7 1,330 9/1/2022
6.1.6 1,695 9/1/2022
6.1.5 1,410 8/25/2022
6.1.4 1,417 8/23/2022
6.1.3 1,573 8/12/2022
6.1.0-beta-08 498 4/28/2022
6.1.0-beta-07 448 4/27/2022
6.1.0-beta-06 416 4/27/2022
6.1.0-beta-05 440 4/21/2022
6.1.0-beta-04 433 4/21/2022
6.1.0-beta-03 441 4/19/2022
6.1.0-beta-02 449 4/18/2022
6.1.0-beta-01 285 4/18/2022