title: how can I use recursive concept with a relational class?
body: <p>I have three table (School - Class - Student) and I make model like the following</p>
  
  <pre><code>class School
  {
      private int _School_ID;  // School Primary Key
      public int School_ID 
      { get { return _School_ID; } set { _School_ID = value; } }
  
      public string _School_Name;
      private string School_Name 
      { get { return _School_Name; } set { _School_Name = value; } }
  }
  
  class Class
  {
      private int _Class_ID;  // Class Primary Key
      public int Class_ID 
      { get { return _Class_ID; } set { _Class_ID = value; } }
  
      public string _Class_Name;
      private string Class_Name 
      { get { return _Class_Name; } set { _Class_Name = value; } }
  
      private int _School_ID;  // School Foreign Key
      public int School_ID 
      { get { return _School_ID; } set { _School_ID = value; } }
  }
  
  class Student
  {
      private int _Student_ID;  // Student Primary Key
      public int Student_ID 
      { get { return _Student_ID; } set { _Student_ID = value; } }
  
      public string _Student_Name;
      private string Student_Name 
      { get { return _Student_Name; } set { _Student_Name = value; } }
  
      private int _Class_ID;  // Class Foreign Key
      public int Class_ID 
      { get { return _Class_ID; } set { _Class_ID = value; } }
  }
  </code></pre>
  
  <p>The Question is:</p>
  
  <ul>
  <li>How can I make a relational class by using foreign key if it possible ?</li>
  <li>How can I use recursive concept to get id from upper class by knowing id of lower class like the following </li>
  </ul>
  
  <p>====================== <br/>
  1 - Puts Student id <br/>
  2 - Student(1).Class.School <br/>
  3 - return School id <br/></p>