C#

Supplier supplier = new Supplier();
supplier.Name = "Supplier5";


Manufacturer manufacturer = new Manufacturer("manufacturer5");

Product product = new Product();
product.Name = "product5";

product.Supplier = supplier;
supplier.ProductList.Add(product);
manufacturer.ProductSet.Add(product);
product.ManufacturerSet.Add(manufacturer);

ITransaction transaction = Session.BeginTransaction();

try
{
  /*IQuery query = Session.CreateQuery("from Supplier as s order by s.Name asc");
   IList<Supplier> lSuppliers = query.List<Supplier>();
   foreach (Supplier supplier in lSuppliers)
   {
        string name = supplier.Name;
   }*/  // here ok

   Session.Save(supplier);  //error

   transaction.Commit();
}
catch (NHibernate.HibernateException nexp)
{
}

<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" auto-import="true" default-access="nosetter.camelcase">
	<class name="NHibernateExampleApp.Supplier, NHibernateExampleApp" table="SUPPLIER" lazy="true" mutable="true">
		<id name="SupplierId" unsaved-value="0" column="ID_SUPPLIER" type="System.Int32">
			<generator class="hilo">
				<param name="table">hibernate_unique_key</param>
				<param name="column">next_hi</param>
				<param name="max_lo">10</param>
			</generator>
		</id>
		<bag name="ProductList" table="PRODUCT" cascade="all" fetch="join" inverse="true">
			<key column="FK_SUPPLIER" />
			<one-to-many class="NHibernateExampleApp.Product, NHibernateExampleApp" />
		</bag>
		<property name="Name" column="NAME" not-null="true" type="System.String" />
	</class>

	<query name="suppliers">from Supplier</query>
</hibernate-mapping>

var proc = new Process();
proc.EnableRaisingEvents = false;
proc.StartInfo.FileName = "cmd.exe";
proc.StartInfo.Arguments = "/c " + Command;
proc.StartInfo.UseShellExecute = false;
proc.StartInfo.RedirectStandardOutput = true;
proc.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
proc.StartInfo.CreateNoWindow = true;
Debug.WriteLine(proc.StartInfo.Arguments);
proc.Start();

Output = proc.StandardOutput.ReadToEnd();

USE [Books]
GO
/****** Object:  StoredProcedure [dbo].[usp_SelectBasedonAuthor]    Script Date: 02/08/2010 17:52:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* Name: usp_SelectBasedonAuthor
   Description: Get authorfirst and last from user and do a select to get all the rows 
                meeting that criteria
   Author: Tony Stegall
   Modification Log: Change
   
   
   Description                           Date                           Author
   Created Procedure                    2/8/2010                       Tony Stegall
 
 
*/
ALTER PROCEDURE [dbo].[usp_SelectBasedonAuthor]
--Variables
@AuthorFirst varchar(50),
@AuthorLast  varchar(50)

AS

SELECT Book.*, Authors.*
FROM Book INNER JOIN 
(Authors INNER JOIN BookAuthors ON Authors.ID = BookAuthors.AuthorID) 
ON Book.ID = BookAuthors.BookID
WHERE AuthorFirst = @AuthorFirst AND AuthorLast = @AuthorLast;

private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
        {
            try
            {
                using (var db = new mombooksDataContext(Properties.Settings.Default.BooksConnectionString2))
                {


                    String[] splitstring = null;
                    string treeviewtext = treeView1.SelectedNode.Text;
                    splitstring = treeviewtext.Split(',');
                    var filter = db.usp_SelectBasedonAuthor(authorFirstTextBox.Text, authorLastTextBox.Text);

                    bindingNavigator1.BindingSource.DataSource = filter.ToList();

                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }

            
        }