Bug when add new Entity "Cannot create a DbSet for 'ChatMessage' because this type is not included in the model for the context." #6226

4 Answer(s)

• 

  0

  ismcagdas created 5 years ago

  Support Team

  Hi,

  Could you share your Dbcontext class ?

  Thanks,

  Save Cancel
• 

  0

  trunglq created 5 years ago

  This is my DbContext class:

  using Abp.IdentityServer4;
  using Abp.Zero.EntityFrameworkCore;
  using CloudFramework.Authorization.Roles;
  using CloudFramework.Authorization.Users;
  using CloudFramework.Chat;
  using CloudFramework.DynamicFields;
  using CloudFramework.Customers;
  using CloudFramework.Editions;
  using CloudFramework.Friendships;
  using CloudFramework.MultiTenancy;
  using CloudFramework.MultiTenancy.Accounting;
  using CloudFramework.MultiTenancy.Payments;
  using CloudFramework.Storage;
  using CloudFramework.Templates;
  using Microsoft.EntityFrameworkCore;
  
  namespace CloudFramework.EntityFrameworkCore
  {
      public class CloudFrameworkDbContext : AbpZeroDbContext<Tenant, Role, User, CloudFrameworkDbContext>, IAbpPersistedGrantDbContext
      {
          /* Define an IDbSet for each entity of the application */
  
          public virtual DbSet<BinaryObject> BinaryObjects { get; set; }
  
          public virtual DbSet<Friendship> Friendships { get; set; }
  
          public virtual DbSet<ChatMessage> ChatMessages { get; set; }
  
          public virtual DbSet<SubscribableEdition> SubscribableEditions { get; set; }
  
          public virtual DbSet<SubscriptionPayment> SubscriptionPayments { get; set; }
  
          public virtual DbSet<Invoice> Invoices { get; set; }
  
          public virtual DbSet<PersistedGrantEntity> PersistedGrants { get; set; }
  
          //Cloud Invoice Section
          public virtual DbSet<Template> Templates { get; set; }
          
          public virtual DbSet<Customer> Customers { get; set; }
          public virtual DbSet<DynamicField> DynamicFields { get; set; }
  
  
          public CloudFrameworkDbContext(DbContextOptions<CloudFrameworkDbContext> options)
              : base(options)
          {
  
          }
  
          protected override void OnModelCreating(ModelBuilder modelBuilder)
          {
              base.OnModelCreating(modelBuilder);
  
  
              modelBuilder.Entity<BinaryObject>(b =>
              {
                  b.HasIndex(e => new { e.TenantId });
              });
  
              modelBuilder.Entity<ChatMessage>(b =>
              {
                  b.HasIndex(e => new { e.TenantId, e.UserId, e.ReadState });
                  b.HasIndex(e => new { e.TenantId, e.TargetUserId, e.ReadState });
                  b.HasIndex(e => new { e.TargetTenantId, e.TargetUserId, e.ReadState });
                  b.HasIndex(e => new { e.TargetTenantId, e.UserId, e.ReadState });
              });
  
              modelBuilder.Entity<Friendship>(b =>
              {
                  b.HasIndex(e => new { e.TenantId, e.UserId });
                  b.HasIndex(e => new { e.TenantId, e.FriendUserId });
                  b.HasIndex(e => new { e.FriendTenantId, e.UserId });
                  b.HasIndex(e => new { e.FriendTenantId, e.FriendUserId });
              });
  
              modelBuilder.Entity<Tenant>(b =>
              {
                  b.HasIndex(e => new { e.SubscriptionEndDateUtc });
                  b.HasIndex(e => new { e.CreationTime });
              });
  
              modelBuilder.Entity<SubscriptionPayment>(b =>
              {
                  b.HasIndex(e => new { e.Status, e.CreationTime });
                  b.HasIndex(e => new { e.PaymentId, e.Gateway });
              });
  
              modelBuilder.Entity<DynamicField>(C =>
              {
                  C.HasIndex(e => new { e.SystemType });
              });
  
              modelBuilder.ConfigurePersistedGrantEntity();
          }
      }
  }
  
  

  I must change CustomField to DynamicField, and comment Customer entity, the system works perfect like charm. This bug is really strange.

  Save Cancel
• 

  0

  ismcagdas created 5 years ago

  Support Team

  Hi @trunglq

  Yes, this is really strange and I couldn't make a connection between ChatMessage entity and the ones you are adding. If you can use your solution, we can close the issue.

  Save Cancel
• 

  0

  maliming created 5 years ago

  Support Team

  @trunglq

  I want to tell you, we found a solution, please see: https://github.com/aspnetzero/aspnet-zero-core/issues/2372#issuecomment-488954566

  Save Cancel