我正在使用EF Core与Postgres数据库进行C#项目。我需要将序列化数据从数据库发送到消息代理。数据将在每个月的特定时间发送。例如，有100条数据记录，它们今天发送。这些数据记录将具有cID（连续ID）从1到100。下个月，这100条记录将再次发送。但是然后cID应该从101到200开始。
这就是它应该的样子

的数据
下面是一个示例模型：

[Table("institutions")]
public partial class Institution
{
    public Institution()
    {
        InstitutionResources = new HashSet<InstitutionResource>();
    }

    [Key]
    [Column("id")]
    public int Id { get; set; }
    public int AddressId { get; set; }
    [Column("phone")]
    [StringLength(20)]
    public string Phone { get; set; }
    [Column("email_address")]
    [StringLength(255)]
    public string EmailAddress { get; set; }
    [ForeignKey(nameof(AddressId))]
    [InverseProperty("Institutions")]
    public virtual Address Address { get; set; }
    [InverseProperty(nameof(InstitutionResource.Institution))]
    public virtual ICollection<InstitutionResource> InstitutionResources { get; set; }
}

字符串
到目前为止，我已经给table编号了：

public List<InstitutionDataResult> FormInstitutionDataResult()
 {
     long cID = 1; // Here I want cID was continuous
     var institutions = _dbContext.Institutions
         .Select(s => new InstitutionDataResult
         {
             //CID = there should be an id
             Id = s.Id, // it is an id from the table
             NameKk = s.InstitutionResources.Where(l => l.LanguageId == 1).SingleOrDefault().Name,
             NameRu = s.InstitutionResources.Where(l => l.LanguageId == 2).SingleOrDefault().Name,
             Geoposition = s.Address.Geoposition.ToString(),
             Phone = s.Phone,
             Email = s.EmailAddress,
             Date = DateTime.Now.ToString("dd.MM.yyyy")
         }).ToList();
     // 
     foreach (var institution in institutions)
     {
         institution.CID = cID;
         cID++;
     }
     return crosswalks;
 }

型
有人暗示我可以使用postgres序列，但我不知道如何使用它们