Migration Issue #6598

5 Answer(s)

• 

  0

  liangshiwei created one year ago

  Support Team Fullstack Developer

  HI,

  Is this working for you?

  builder.Entity<TempLayer>(b =>
  {
      b.ToTable(SGLLayerManagementConsts.DbTablePrefix + nameof(TempLayer));
      b.ConfigureByConvention();
      b.HasKey(e => e.Id);
      b.Property(e => e.Id).AutoGenerateGuidNpgSql();
  
      b.HasKey(e => e.TempLayerId);
      b.Property(e => e.TempLayerId).AutoGenerateGuidNpgSql();
  
      b.Property(e => e.LayerName)
          .IsRequired();
  
      b.Property(e => e.BoundX1)
          .IsRequired();
  
      b.Property(e => e.BoundX2)
          .IsRequired();
  
      b.Property(e => e.BoundY1)
          .IsRequired();
  
      b.Property(e => e.BoundY2)
          .IsRequired();
  
      b.Property(e => e.IsSync)
          .IsRequired()
          .HasDefaultValue(true);
  
      b.Property(e => e.IsQueryable)
          .IsRequired()
          .HasDefaultValue(true);
  
      b.HasMany(e => e.LayerFields)
          .WithOne(e => e.Layer)
          .HasForeignKey(e => e.LayerId);
      b.ApplyObjectExtensionMappings();
      
  
     b.Property(e => e.ExtraProperties).IsRequired(false);  add this line
  });
  

  Add&Apply new migration.

  Save Cancel
• 

  0

  dipak.z created one year ago

  HI,

  Is this working for you?

  builder.Entity<TempLayer>(b => 
  { 
      b.ToTable(SGLLayerManagementConsts.DbTablePrefix + nameof(TempLayer)); 
      b.ConfigureByConvention(); 
      b.HasKey(e => e.Id); 
      b.Property(e => e.Id).AutoGenerateGuidNpgSql(); 
   
      b.HasKey(e => e.TempLayerId); 
      b.Property(e => e.TempLayerId).AutoGenerateGuidNpgSql(); 
   
      b.Property(e => e.LayerName) 
          .IsRequired(); 
   
      b.Property(e => e.BoundX1) 
          .IsRequired(); 
   
      b.Property(e => e.BoundX2) 
          .IsRequired(); 
   
      b.Property(e => e.BoundY1) 
          .IsRequired(); 
   
      b.Property(e => e.BoundY2) 
          .IsRequired(); 
   
      b.Property(e => e.IsSync) 
          .IsRequired() 
          .HasDefaultValue(true); 
   
      b.Property(e => e.IsQueryable) 
          .IsRequired() 
          .HasDefaultValue(true); 
   
      b.HasMany(e => e.LayerFields) 
          .WithOne(e => e.Layer) 
          .HasForeignKey(e => e.LayerId); 
      b.ApplyObjectExtensionMappings(); 
       
   
     b.Property(e => e.ExtraProperties).IsRequired(false);  add this line 
  }); 
  

  Add&Apply new migration.

  I have to add this line for all entities & in all modules? its not like that in abp 5.2.1

  Save Cancel
• 

  0

  liangshiwei created one year ago

  Support Team Fullstack Developer

  Hi,

  I have to add this line for all entities & in all modules? its not like that in abp 5.2.1

  No, Usually ExtraProperties have a default value, which should not be null. I'm guessing this might have something to do with your code, but I don't know the details

  

  Save Cancel
• 

  0

  dipak.z created one year ago

  Hi,

  I have to add this line for all entities & in all modules? its not like that in abp 5.2.1

  No, Usually ExtraProperties have a default value, which should not be null. I'm guessing this might have something to do with your code, but I don't know the details

  

  i am using this for bulk insertdata and i am not passed extraproperties in this

  public async Task BulkInsert<TEntity>(IEnumerable<TEntity> entities, params string[] properties)
  {
      var dbcontext = await GetDbContextAsync().ConfigureAwait(false);
      using var connection = new NpgsqlConnection(dbcontext.Database.GetDbConnection().ConnectionString);
  
      var mapping = dbcontext.Model.FindEntityType(typeof(TEntity));
      const string schema = "public";// mapping.GetSchema();
      var tableName = mapping.GetTableName();
      string query = $"Insert into \"{schema}\".\"{tableName}\" ({properties.Select(p => "\"" + p + "\"").ToCSV()}) values ({properties.Select(p => "@" + p).ToCSV()})";
      _ = await connection.ExecuteAsync(query, entities).ConfigureAwait(false);
  }
  

  and its works fine in abp 5.2.1

  Save Cancel
• 

  0

  liangshiwei created one year ago

  Support Team Fullstack Developer

  and its works fine in abp 5.2.1

  Starting from 8.0, ABP supports Nullable reference types: https://learn.microsoft.com/en-us/dotnet/csharp/nullable-references That's why it doesn't work.

  You may consider manually assigning values ​​to ExtraProperties, or setting it to a nullable field

  Save Cancel