Entity Relationship created by ABP Suite #3717

5 Answer(s)

• 

  0

  mat.guthrie@loupa.io created 2 years ago

  Hi,

  NOTE: This is not an answer, just a follow-up question

  Having gone through the free Implementing DDD pdf I see that the reason that navigation properties are not created is so as to remain database provider agnostic. I will only be using EF Core and SQL so this is not an issue for me. I note that the documentation says "If you think such features are important for you and you will never stray from the EF Core, we believe that it is worth stretching this principle."

  Do you have any code samples that make use of entities with navigation properties? Normally I would just use AutoMapper to map the DTO to the entity and sub-entities, however is is not possible because the requirements use Guid as the identity. Is there anyway to get around this or a preferred method that doesn't involve setting every property manually. Something like:

  CreateMap<AddressCreateDto, Address>().ConstructUsing(a => new Address(_guidGenerator.Create()));
  

  An example of the type of entity relationships I'm trying to deal with would be as follows:

      public class Customer
      {
          public Guid Id { get; set; }
          public string Email { get; set; }
          public object FirstName { get; set; }
          public object LastName { get; set; }
          public int CurrencyId { get; set; }
  
          // Navigation Property
          public List<Address> Addresses { get; set; }
  
          // Navigation Property
          public Currency Currency { get; set; }
  
      }
  
      public class Address
      {
          public Guid Id { get; set; }
          public string Line1 { get; set; }
  
          public string City { get; set; }
  
          public string Zip { get; set; }
      }
  
      // Shared Reference Data
      public class Currency
      {
          public int Id { get; set; }
          public string Name { get; set; }
          public string IsoCode { get; set; }
      }
  

  Any assistance or sample code would be very helpful.

  Thanks

  Mat

  Save Cancel
• 

  0

  alper created 2 years ago

  Support Team Director

  Ok, Mat I'll try to make an example project via Suite based on your message.

  Save Cancel
• 

  0

  hamzabraim created 2 years ago

  Hello Mat,

  As for your first question, I created a new solution and used ABP Suite to generate a customer entity, and then a address entity. I also added a navigation property (one-to-many) to the address entity and linked it with the customer entity so that each customer can have multiple addresses and it works perfectly as in the screenshots:

  As for the one-to-one relationship, I'm afraid it is not supported.

  Save Cancel
• 

  0

  mat.guthrie@loupa.io created 2 years ago

  Hi,

  When you say "it works perfectly" what do you mean? When I did exactly that, the Customer Entity didn't have a Address collection navigation property and it appeared to create a 1-1 relationship in CustomerWithNaviagtionProperties class. See below. That's not 1 Customer with Many addresses.

  Your screenshots just illustrate the UI for creating Addresses. That's wasn't the question.

  Further assistance would be appreciated. Thanks

  Mat

  public class Customer : FullAuditedAggregateRoot<Guid>, IMultiTenant
  {
      public virtual Guid? TenantId { get; set; }
  
      [CanBeNull]
      public virtual string Name { get; set; }
      public Guid? AddressId { get; set; }
  
      public Customer()
      {
  
      }
  
      public Customer(Guid id, Guid? addressId, string name)
      {
  
          Id = id;
          Check.Length(name, nameof(name), CustomerConsts.NameMaxLength, 0);
          Name = name;
          AddressId = addressId;
      }
  
  }
  
  public class CustomerWithNavigationProperties
  {
      public Customer Customer { get; set; }
  
      public Address Address { get; set; }       
  
      
  }
  

  Save Cancel
• 

  0

  alper created 2 years ago

  Support Team Director

  Hi,

  ABP Suite helps to create basic CRUD pages with limited relationship options. if you need further steps, you should manually edit the generated code.

  Save Cancel