namespace FrameworkDAL.Query.EIPConversation.EIPIdempotency
{
    // UNIQUE constraint UK_TEIPIDEMPOTENCYRECORD_IDEMPOTENCYKEY on (IDEMPOTENCYKEY) is the
    // atomic de-duplication guard — two concurrent inserts with the same key: the second
    // raises SqlException 2627, caught in EIPIdempotencyDAL.TryRecordAsync → returns false.
    public static class EIPIdempotencyQB
    {
        public const string TRY_RECORD = @"
            INSERT INTO TEIPIDEMPOTENCYRECORD
                (TENANTID, IDEMPOTENCYKEY, ACTIONNAME,
                 VERSION, STATUS, SORTORDER, SOURCETYPE,
                 CREATEDBYID, CREATEDON, MODIFIEDBYID, MODIFIEDON)
            VALUES
                (@TenantId, @IdempotencyKey, @ActionName,
                 0, 1, 9999, 5,
                 @UserId, GETDATE(), @UserId, GETDATE())";
    }
}