C#

private static bool StopThread = false;

private void Form1_Load(object sender, EventArgs e)
{

   System.Threading.Thread local_Thread = new System.Threading.Thread(RunThread);
   local_Thread.Start();

   System.Windows.Forms.Form local_Form = new System.Windows.Forms.Form();
   local_Form.MdiParent = this;
   local_Form.Show();

}

private void RunThread()
{

   System.Data.SqlClient.SqlConnection local_SqlConnection = new System.Data.SqlClient.SqlConnection();
   System.Data.SqlClient.SqlCommand local_SqlCommand = new System.Data.SqlClient.SqlCommand();
   System.Data.SqlClient.SqlDataReader local_SqlDataReader;
   local_SqlConnection.ConnectionString = @"Data Source=MyServer\MyInstance;Initial    Catalog=master;Integrated Security=true;";
   local_SqlConnection.Open();

   while (!StopThread)
   {

      // Command Object setzen
      local_SqlCommand.CommandText = "SELECT * FROM SomeTable";
      local_SqlCommand.CommandTimeout = 0;
      local_SqlCommand.Connection = local_SqlConnection;

      // DataReader
      local_SqlDataReader = local_SqlCommand.ExecuteReader();

      // DataTable füllen
      System.Data.DataTable local_DataTable = new System.Data.DataTable();
      local_DataTable.BeginLoadData();
      local_DataTable.Load(local_SqlDataReader);
      local_DataTable.EndLoadData();

      System.Threading.Thread.Sleep(2000);
   }

}

private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{ StopThread = true; }

public class Product
{
    public virtual int ProductID { get; set; }
    public virtual string Name { get; set; }
    public virtual decimal BatchSize { get; set; }
    public virtual decimal FormulaSG { get; set; }
    public virtual string Appearance { get; set; }
    public virtual string Smell { get; set; }
    public virtual decimal Yield { get; set; }
    public virtual string SolidsPercentage { get; set; }
    public virtual string pH { get; set; }
    public virtual string Viscosity { get; set; }
    public virtual string Colour { get; set; }
    public virtual string FoamDefinition { get; set; }
    public virtual DateTime CreatedDate { get; set; }
    public virtual Recipe Recipe { get; set; }

    #region Overrides
    public override bool Equals(object obj)
    {...}

    public override int GetHashCode()
    {...}
    #endregion
}



public class Recipe
{
    public virtual int RecipeID { get; set; }
    public virtual List<RecipeEntry> RecipeEntries { get; set; }


    #region Overrides
    public override bool Equals(object obj)
    {...}

    public override int GetHashCode()
    {...}
    #endregion
}



public class RecipeEntry
{
    public decimal PercentageInKg { get; set; }
    public Material RawMaterial { get; set; }
}



public class Material
{
    public virtual int MaterialID { get; set; }
    public virtual string Name { get; set; }
    public virtual decimal CostPerKg { get; set; }


    #region Overrides
    public override bool Equals(object obj)
    {...}

    public override int GetHashCode()
    {...}
    #endregion
}

public class ProductMap : ClassMap<Product>
    {
        public ProductMap()
        {
            Table("Products");
            Id(p => p.ProductID);
            Map(p => p.Name);
            Map(p => p.BatchSize);
            Map(p => p.FormulaSG);
            Map(p => p.Appearance);
            Map(p => p.Smell);
            Map(p => p.Yield);
            Map(p => p.SolidsPercentage);
            Map(p => p.pH);
            Map(p => p.Viscosity);
            Map(p => p.Colour);
            Map(p => p.FoamDefinition);
            Map(p => p.CreatedDate);
            References(p => p.Recipe.RecipeID , "RecipeID");
        }
    }


    public class RecipeMap : ClassMap<Recipe>
    {
        public RecipeMap()
        {
            Table("Recipes");
            Id(p => p.RecipeID);

            Component<RecipeEntry>(x => x.RecipeEntries, m =>
            {
                m.Map(x => x.PercentageInKg);
                m.References(x => x.RawMaterial, "MaterialID");
            });            
        }
    }



    public class MaterialMap : ClassMap<Material>
    {
        public MaterialMap()
        {
            Table("RawMaterials");
            Id(p => p.MaterialID);
            Map(p => p.Name);
            Map(p => p.CostPerKg);
        }
    }