title: How can I create one to at least one fluent mapping with multiple tables?
body: <p>I have an old designed database schema, and I want map it with Fluent-Nhibenrate.</p>
  
  <p>The schema looks something like this: </p>
  
  <pre><code>Table:Users
  ID Number PK
  
  Table:Kiosk
  User_ID Number PK, FK -&gt; Users.ID
  Xml Varchar
  
  Table:Email
  User_ID Number PK, FK -&gt; Users.ID
  Update_Date Date
  </code></pre>
  
  <p>And I want to achieve with the mapping objects that looks something like this:</p>
  
  <pre><code>public class User
  {
      private virtual Email _email {get;set;}
  
      public virtual int Id {get;set;}
      public virtual string Email
      {
          get
          {
              return _email.Email;
          }
          set
          {
              _email.Email = value;
              _email.UpdateDate = DateTime.Now();
          }
      }
  
      public virtual Kiosk Kiosk {get;set;}
  
      public virtual bool HasKiosk
      {
          get
          {
              return (Kiosk != null);
          }
      }
  }
  
  public class Kiosk
  {
      public virtual string XmlKiosk {get;set;}
  }
  
  public class Email
  {
      public virtual string Email {get;set;}
      public virtual DateTime UpdateDate {get;set;}
  }
  </code></pre>
  
  <p>Any ideas?</p>
  
  <p>Thanks ahead,
  Amir.</p>