title: EFCore Selects wrong column name
body: <p>I  have created an API with <code>.Net core</code> and <code>EFCore</code> following <a href="https://docs.microsoft.com/en-US/aspnet/core/tutorials/web-api-vsc" rel="nofollow noreferrer">this</a> tutorial using the VSCode.</p>
  
  <p>I  have a lot of Models of my MySQL database, because i'm "migrating" my <code>EF6</code> with <code>asp.net WebAPI</code> to <code>.Net core</code>, so i just have copied and paste to avoid a lot of work (again). </p>
  
  <p>When i try to do a simple <code>Get</code>, the EFCore is concatenating two columns of diferent tables: </p>
  
  <p><strong>The Controller User</strong></p>
  
  <pre><code>[Route("v1/[controller]")]
  public class UserController : Controller
  {
  
      private readonly IntentContext _context;
  
      public UserController(IntentContext context)
      {
          _context = context;
      }
  
      [HttpGet]
      public IEnumerable&lt;user&gt; GetAll()
      {
          return _context.user.ToList();
      }
  }
  </code></pre>
  
  <p><strong>The 'user' model</strong></p>
  
  <pre><code>public class user
  {
      public user()
      {
          user_image = new HashSet&lt;user_image&gt;();
          user_credit_card = new HashSet&lt;user_credit_card&gt;();
          user_pocket_history = new HashSet&lt;user_pocket_history&gt;();
          user_pocket = new HashSet&lt;user_pocket&gt;();
  
          //A lot of table instances
      }
  
      public string id { get; set; }
      public string username { get; set; }
      public string password { get; set; }
      public string id_account_type { get; set; }
      public int user_status { get; set; }
      public DateTime create_time { get; set; }
      public DateTime update_time { get; set; }
  
      public virtual account_type account_type { get; set; }
  
      public virtual ICollection&lt;user_image&gt; user_image { get; set; }
      public virtual ICollection&lt;user_credit_card&gt; user_credit_card { get; set; }
      public virtual ICollection&lt;user_pocket_history&gt; user_pocket_history { get; set; }
      public virtual ICollection&lt;user_pocket&gt; user_pocket { get; set; }
  
      //A lot of table relations
  }
  </code></pre>
  
  <p><strong>The table account_type</strong></p>
  
  <pre><code>public class account_type
  {
      public account_type()
      {
          this.user = new HashSet&lt;user&gt;();
          this.establishment_employee = new HashSet&lt;establishment_employee&gt;();
      }
  
      public string id { get; set; }
      public string account_description { get; set; }
      public string account_name { get; set; }
      public DateTime create_time { get; set; }
      public DateTime update_time { get; set; }
  
      public virtual ICollection&lt;user&gt; user { get; set; }
      public virtual ICollection&lt;establishment_employee&gt; establishment_employee { get; set; }
  }
  </code></pre>
  
  <p><strong>The terminal log during the get request</strong></p>
  
  <pre><code>fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
    Failed executing DbCommand (140ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
    SELECT `u`.`id`, `u`.`Id_account_type`, `u`.`account_typeid`, `u`.`create_time`, `u`.`password`, `u`.`update_time`, `u`.`user_status`, `u`.`username`
    FROM `user` AS `u`
  MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'u.account_typeid' in 'field list' ---&gt; MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column **'u.account_typeid'** in 'field list'
     at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
  
  //A lot of exceptions generated 
  
  fail: Microsoft.EntityFrameworkCore.Query[10100]
    An exception occurred in the database while iterating the results of a query for context type 'IntentAPI.Models.IntentContext'.
    MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'u.account_typeid' in 'field list' ---&gt; MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'u.account_typeid' in 'field list'
       at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
  </code></pre>
  
  <p>Please, note that the field <code>u.account_typeid</code> really doesn't exists. It is a concatenate of <code>account_type</code> of <code>user</code> table and <code>id</code> of <code>account_type</code> table.</p>
  
  <p>Why it is happening?</p>
  
  <p>Many thanks and sorry for my terible English</p>