title: C# MVC Model view connecting 2 different database columns
body: <p>This is the first time I have attempted to join information from one database to the other. I have a accounting database and a regular site database. Trying to keep them separate. I have a page that shows Transactions but am getting the information for a few of the columns from the regular database by way of Id's. Below is my Model. I am showing nothing in the fields for the items in the other database.</p>
  <pre><code>    public class Transaction
  {
      [Key]
      public Guid TransactionId { get; set; }
      public string Description { get; set; }
      public int? CompanyId { get; set; }
      public Guid? VendorId { get; set; }
      public string InCheckNumber { get; set; }
      public string OutCheckNumber { get; set; }
      public string InvoiceNumber { get; set; }
      public string PurchaseOrderNumber { get; set; }
      public Guid LedgerAccountId { get; set; }
      public decimal? DebitAmount { get; set; }
      public decimal? CreditAmount { get; set; }
      public DateTime TransactionDate { get; set; }
      public string ModifiedBy { get; set; }
      public DateTime? ModifiedDate { get; set; }
      public string SavedDocument { get; set; }
      public DateTime CreatedDate { get; set; }
      public string CreatedBy { get; set; }
      public bool IsCredit { get; set; }
      public bool IsDebit { get; set; }
      public Guid Type { get; set; } 
  
      [ForeignKey(&quot;LedgerAccountId&quot;)]
      public LedgerAccount LedgerAccount { get; set; }
      [ForeignKey(&quot;CompanyId&quot;)]
      public CompanyNames Company { get; set; }
      [ForeignKey(&quot;VendorId&quot;)]
      public Vendors Vendor { get; set; }
  
  }
  </code></pre>
  <p>I have added the 'using' of the General.Entities to this model. Is there something else i need to add for this?</p>
  <p>Thanks in advance.</p>
  <p>UPDATE:
  See Question - <a href="https://stackoverflow.com/questions/65622878/c-sharp-mvc-return-viewmodel-to-list/65628735#65628735">Link to answer of question</a></p>