Exemplo n.º 1
0
 public virtual void AddEmployee( Employee employee )
 {
     employee.Store = this;
     Staff.Add( employee );
 }
        // Adds sample data to our database and writes the data to the console
        static void Main()
        {
            // Create a session factory
            var sessionFactory = CreateSessionFactory();

            // Open a session
            using ( var session = sessionFactory.OpenSession() )
            {
                // Begin a transaction
                using ( var transaction = session.BeginTransaction() )
                {
                    // Create a couple of Stores each with some Products and Employees
                    var barginBasin = new Store { Name = "Bargin Basin" };
                    var superMart = new Store { Name = "SuperMart" };

                    var potatoes = new Product { Name = "Potatoes", Price = 3.60 };
                    var fish = new Product { Name = "Fish", Price = 4.49 };
                    var milk = new Product { Name = "Milk", Price = 0.79 };
                    var bread = new Product { Name = "Bread", Price = 1.29 };
                    var cheese = new Product { Name = "Cheese", Price = 2.10 };
                    var waffles = new Product { Name = "Waffles", Price = 2.41 };

                    var daisy = new Employee { FirstName = "Daisy", LastName = "Harrison" };
                    var jack = new Employee { FirstName = "Jack", LastName = "Torrance" };
                    var sue = new Employee { FirstName = "Sue", LastName = "Walkters" };
                    var bill = new Employee { FirstName = "Bill", LastName = "Taft" };
                    var joan = new Employee { FirstName = "Joan", LastName = "Pope" };

                    // Add Products to the Stores
                    // The Store-Product relationship is many-to-many
                    AddProductsToStore( barginBasin, potatoes, fish, milk, bread, cheese );
                    AddProductsToStore( superMart, bread, cheese, waffles );

                    // Add Employees to the Stores
                    // The Store-Employee relationship is one-to-many
                    AddEmployeesToStore( barginBasin, daisy, jack, sue );
                    AddEmployeesToStore( superMart, bill, joan );

                    // Save the session
                    session.SaveOrUpdate( barginBasin );
                    session.SaveOrUpdate( superMart );

                    // Commit the transaction
                    transaction.Commit();
                }

                // Begin a transaction
                using ( var transaction = session.BeginTransaction() )
                {
                    var stores = session.CreateCriteria( typeof( Store ) )
                        .List<Store>();

                    foreach ( var store in stores )
                    {
                        WriteStorePretty( store );
                    }

                    // Commit the transaction
                    transaction.Commit();
                }
            }

            Console.ReadKey();
        }