Extending the IdentityUser Object with Enum property #994

10 Answer(s)

• 

  0

  nick.coleman created 3 years ago

  Did I ask this question incorrectly?

  If there is no answer to this can you close so I can claim my question back please

  Save Cancel
• 

  0

  gterdem created 3 years ago

  Senior .NET Developer

  Hello nick.coleman, sorry for late response.

  It seems you have misconfiguration here:

  user.AddOrUpdateProperty<Title>( UserConsts.TitleName, options => { options.Attributes.Add(new RequiredAttribute()); options.UI.OnTable.IsVisible = false; } );

  Type should be enum instead of Title

  user.AddOrUpdateProperty<enum>( UserConsts.TitleName, options => { options.Attributes.Add(new RequiredAttribute()); options.UI.OnTable.IsVisible = false; } );

  Which should result like this:

  Save Cancel
• 

  0

  nick.coleman created 3 years ago

  Hi,

  Thanks but this doesn't compile for me?.

  Invalid expression term 'enum'

  Thanks

  Nick

  Save Cancel
• 

  0

  gterdem created 3 years ago

  Senior .NET Developer

  Hello,

  I am sharing the configuration I tried to reproduce below:

  Title.cs file under Domain.Shared:

  public enum Title
  {
      Mr = 0,
      Mrs = 1,
      Ms = 2,
      Dr = 3
  }
  

  MyProjectNameModuleExtensionConfiguratior.cs under Domain.Shared: <br>

  public static class BookStoreModuleExtensionConfigurator
  {
      private static readonly OneTimeRunner OneTimeRunner = new OneTimeRunner();
  
      public static void Configure()
      {
          OneTimeRunner.Run(() =>        {
              ConfigureExistingProperties();
              ConfigureExtraProperties();
          });
      }
  
      private static void ConfigureExistingProperties()
      {
      }
  
      private static void ConfigureExtraProperties()
      {
          ObjectExtensionManager.Instance.Modules()
              .ConfigureIdentity(identity =>            {
                  identity.ConfigureUser(user =>                {
                      user.AddOrUpdateProperty<Title>(
                          "Title",
                          options =>                        {
                              options.Attributes.Add(new RequiredAttribute());
                              options.UI.OnTable.IsVisible = false;
                          }
                      );
                  });
              });
      }
  }
  

  <br> Your configuration is correct, my apologies. However i failed to reproduce the problem. I created two different usersvia New User modal under Administration->Identity Management->Users page. <br>

  When creating the UI to manage the user I get the following error...

  Can you explain more about this? Are you replacing Identity Management -> Users list/create/edit pages? If that is the case, you can check how extended properties are shown in User Create Modal.

  Save Cancel
• 

  0

  nick.coleman created 3 years ago

  Hi,

  Thanks for the quick response... Im not replacing the UI.

  I think it maybe due to the way i have the value configured in the DB? The modal works when the title is null in the DB but as soon as i save a user with a value for 'Title' field i can no longer open the modal for that user and i receive the error above.

  Here is the EF configuration ; ObjectExtensionManager.Instance .MapEfCoreProperty<IdentityUser, string>( UserConsts.TitleName, (entityBuilder, propertyBuilder) => { propertyBuilder.HasMaxLength(UserConsts.TitleLength); } );

  Does this look ok?

  I can actually create users fine, I have managed to create users but as soon as i try and edit them i get the error... are you able to try this in your example?

  Thanks

  nick

  Save Cancel
• 

  0

  gterdem created 3 years ago

  Senior .NET Developer

  It seems there is a problem with your EfCore configuration;

  Here is my configuration under EntityFrameworkCore project: <br>

  public static class BookStoreEfCoreEntityExtensionMappings
  {
      private static readonly OneTimeRunner OneTimeRunner = new OneTimeRunner();
  
      public static void Configure()
      {
          BookStoreGlobalFeatureConfigurator.Configure();
          BookStoreModuleExtensionConfigurator.Configure();
  
          OneTimeRunner.Run(() =>        {
              ObjectExtensionManager.Instance
                  .MapEfCoreProperty<IdentityUser, Title>(
                      "Title",
                      (entityBuilder, propertyBuilder) =>                    {
                          propertyBuilder.HasConversion<string>(); // If you want your Title to be seen as string
                      }
                  );
          });
      }
  }
  

  This is the created migration under EntityFrameworkCore.DbMigrations project: <br>

  public partial class Added_EfCore_Mapping : Migration
  {
      protected override void Up(MigrationBuilder migrationBuilder)
      {
          migrationBuilder.AddColumn<string>(
              name: "Title",
              table: "AbpUsers",
              type: "nvarchar(max)",
              nullable: false,
              defaultValue: "");
      }
  
      protected override void Down(MigrationBuilder migrationBuilder)
      {
          migrationBuilder.DropColumn(
              name: "Title",
              table: "AbpUsers");
      }
  }
  

  This is AbpUsers table after adding then updating a user:

  Save Cancel
• 

  0

  Mohammad created 3 years ago

  Is the migration code generated automatically from the Efcore configuration or we need to manually write the migration code?

  I have been following the above approach but the add-migration creates and empty migration file.

  Save Cancel
• 

  0

  gterdem created 3 years ago

  Senior .NET Developer

  You need to add migration manually. Your new migration should have been generated automatically afterwards. You can check documentation for more.

  I have been following the above approach but the add-migration creates and empty migration file.

  That is the problably your EfCore configuration is not correct. Check the Configure method of MyProjectEfCoreEntityExtensionMappings under EntityFrameworkCore project.

  Save Cancel
• 

  0

  nick.coleman created 3 years ago

  @gterdem

  Thanks you for your help!

  This is now working....

  This was the key part

  OneTimeRunner.Run(() => { ObjectExtensionManager.Instance .MapEfCoreProperty<IdentityUser, Title>( "Title", (entityBuilder, propertyBuilder) => { propertyBuilder.HasConversion<string>(); // If you want your Title to be seen as string } ); });

  Save Cancel
• 

  0

  Mohammad created 3 years ago

  How can we use the extended property in LINQ to query the database?

  Save Cancel