Id Field in Entity #40

5 Answer(s)

• 

  0

  apexdodge created 9 years ago

  I think if you do ID instead of Id, then you're not following conventions and code-first won't know what to map unless you specify with a [ForeignKey("ClientID")] attribute, etc etc.

  But boilerplate takes care of Ids for you if your data model inherits from Entity<long>, I'm pretty sure. Why not do that?

  Save Cancel
• 

  0

  hikalkan created 9 years ago

  Support Team

  Hi,

  You can change mapped column name with two options:

  • You can override Id property and use a Column attribute.
  • Or you can override OnModelCreating and set column name. See: <a class="postlink" href="https://msdn.microsoft.com/en-us/data/jj591617.aspx#1.1">https://msdn.microsoft.com/en-us/data/jj591617.aspx#1.1</a>

  These are all EF stuff.

  Have a nice day.

  Save Cancel
• 

  0

  a. h. created 9 years ago

  <cite>hikalkan: </cite> Hi,

  You can change mapped column name with two options:

  • You can override Id property and use a Column attribute.
  • Or you can override OnModelCreating and set column name. See: <a class="postlink" href="https://msdn.microsoft.com/en-us/data/jj591617.aspx#1.1">https://msdn.microsoft.com/en-us/data/jj591617.aspx#1.1</a>

  These are all EF stuff.

  Have a nice day.

  They are and they aren't.

  I have also had a bugger of a time with this.

  E.g Using ABP... I have had to do things to work around the issue of not having an "Id"

  public Client : Entity {
    [Key]
    public virtual int ClientID {get;set;} 
  }
  
  ...
  OnModelCreating(DBModelBuilder modelBuilder) {
    modelBuilder.Entity<Client>().Ignore(e => e.Id);
  }
  
  ...
  IClientRepository : DBRespositoryBase<Client>, IClientRepository {
  
    public virtual Client GetByID (int ClientID)
          {
              Client client = FirstOrDefault(agent => client .ClientID == ClientID);
  
              if (client == null)
              {
                  throw new Exception("Client not found: " + ClientID);
              }
              return Client;
          }
  }
  
  ClientDTO : EntityDTO {
    public ClientDTO (int ClientID) {
        Id = ClientID;
    }
  }
  
  etc...
  

  I can't use the IRepository's Get statement. Can't use AutoMapper... It is very much a ABP issue for me, unless I'm doing it wrong...

  Can you outline a quick to-do of what needs to be done to completely implement a table that doesn't use an Id in ABP? :D

  Save Cancel
• 

  0

  hikalkan created 9 years ago

  Support Team

  Overriding Id works for me. Example:

  public class Person : Entity
      {
          [Column("PersonId")]
          public override int Id { get; set; }
  
          public virtual string Name { get; set; }
  
          [ForeignKey("PersonId")]
          public virtual ICollection<Phone> Phones { get; set; }
      }
  

  Here, I overrided Id and set Column attribute.

  Save Cancel
• 

  0

  a. h. created 9 years ago

  Thank you.

  Save Cancel