Id property not being autopopulated with document Id

[weirdyang]

When I tested it, if i declare a property Id on my Entity, YESSQL auto populates it with the document id, however when I tried it again on another project, the Id populated, what causes this?

Here is my working sample:
https://github.com/weirdyang/Cms.Web

Here is the code which is having the issue of Id not being populated:

    public class MqttProfile : Entity
    {
        public const string Collection = "MqttProfile";

        // this will be automatically set to the document id
        public long Id { get; set; }
        public string HostName { get; set; } = "test.mosquitto.org";

        private string? _clientName;

        public string ClientName
        {
            get => string.IsNullOrWhiteSpace(_clientName) 
                ? Path.GetRandomFileName().Replace('.','-')
                : _clientName;
            set => _clientName = value;
        }

        public MqttQualityOfServiceLevel Qos { get; set; } = MqttQualityOfServiceLevel.AtLeastOnce;

        public string ClientId { get; set; } = Guid.NewGuid().ToString("N");
        /// <summary>
        /// client cert
        /// </summary>
        public string? ClientCertFile { get; set; }
        public string? ClientCertFileName { get; set; }
        /// <summary>
        /// client key file
        /// </summary>
        public string? KeyFile { get; set; }
        public string? KeyFileName { get; set; }
        /// <summary>
        /// server cert file
        /// </summary>
        public string? CaFile { get; set; }
        public string? CaFileName { get; set; }
        /// <summary>
        /// key file password
        /// </summary>
        public string? KeyFilePassword { get; set; }

        public AuthType Auth
        {
            get => !string.IsNullOrEmpty(ClientCertFile) ? AuthType.X509 : AuthType.Basic;
        }
        public string? Username { get; set; } 
        public string? Password { get; set; }
        public int KeepAliveInSeconds { get; set; } = MqttSettings.Default_KeepAliveInSeconds;
        public bool CleanSession { get; set; } = MqttSettings.Default_CleanSession;
        public int TcpPort { get; set; } = MqttSettings.Default_TcpPort;
        public bool UseTls { get; set; } = MqttSettings.Default_UseTls;

        public bool ValidateCerts { get; set; } = MqttSettings.Default_ValidateCerts;

        public bool Disconnected { get; set; } = true;

        public string TopicString { get; set; } = string.Empty;
        public List<string> Topics()
        {
            return string.IsNullOrWhiteSpace(TopicString)
                ? new List<string>()
                : TopicString.Split('|').Select(x => x.Trim()).ToList();
        }

        public bool RetainFlag { get; set; } = false;
        public MqttSettings ToMqttSettings()
        {
            return new MqttSettings(HostName)
            {
                ClientId = ClientId,
                ClientName = ClientName,
                CaFile = CaFile,
                ClientCertFile = ClientCertFile,
                KeyFilePassword = KeyFilePassword,
                KeyFile = KeyFile,
                CleanSession = CleanSession,
                KeepAliveInSeconds = KeepAliveInSeconds,
                TcpPort = TcpPort,
                UseTls = UseTls,
                ValidateCerts = ValidateCerts,
                Username = Username,
                Password = Password,
                Qos =Qos,
                RetainFlag = RetainFlag,
            };
        }
    }
    public class MqttProfileIndexProvider : IndexProvider<MqttProfile>
    {
        public MqttProfileIndexProvider() => CollectionName = MqttProfile.Collection;

        public override void Describe(DescribeContext<MqttProfile> context) =>
            context.For<MqttProfileIndex>()
                .Map(profile =>
                {
                    return new MqttProfileIndex
                    {
                        ClientName = profile.ClientName,
                        ClientId = profile.ClientId,
                    };
                });
    }
    public class MqttProfileIndex : MapIndex
    {
        public string? ClientName { get; set; }
        public string? ClientId { get; set; }
        
    }
    public sealed class Migrations : DataMigration
    {
        public int Create()
        {
             SchemaBuilder.CreateMapIndexTable<MqttProfileIndex>(table => table
                .Column<string>(nameof(MqttProfile.ClientName), column => column.Unlimited())
                .Column<string>(nameof(MqttProfile.ClientId), column => column.Unlimited()),
                collection: MqttProfile.Collection);

             SchemaBuilder.AlterIndexTable<MqttProfileIndex>(table => table
                .CreateIndex("IDX_ProfileIndex_DocumentId",
                    "DocumentId",
                    "ClientName",
                    "ClientId"
                    ),
                collection: MqttProfile.Collection
            );

            return 1;
        }
    }

The only difference is the OC version, the non-working code is using OC 1.4

[weirdyang]

The issue is the document id property type has changed from int to long in newer versions, for older version of OC (before 1.7) need to set type int for Id for it to be autopopulated.

OrchardCore/src/docs/releases/1.7.0.md

Line 7 in f0b0d3b

The database identity columns' size is now configurable. This applies to both the `Id` column in all tables and the `DocumentId` column in all index tables.