Database

<italic>Work hard, Work effectively and a bit of luck is the key to success.

class ObjBrokerFactory {<br />
   <br />
   IObjBroker GetObjBroker(ortype) {<br />
      select ortype:<br />
        case NHIBERNATE: return (IObjBroker) new NHibnernateObjBroker(...);<br />
        case OBJSPACE: return (IObjBroker) new ObjSpaceBroker(...);<br />
   }<br />
}<br />
<br />
class ObjHNibernateBroker {<br />
   public New(...) {<br />
     ... initialized depending on OR type specified ...<br />
   }<br />
<br />
   public Finder(criteria) {...}<br />
   public Insert(obj) {...}<br />
   public Update(obj) {...}<br />
   public Delete(obj) {...}<br />
}<br />

UserAccount acc = new UserAccount(...);<br />
acc.Email = "john.doe@hotmail.com";<br />
...<br />
IObjBroker broker = brokerFactory.GetObjBroker(ortype.NHIBERNATE);<br />
...<br />
broker.Insert(acc);<br />
...

<br />
ISessionFactory factory = cfg.BuildSessionFactory();<br />
ISession session = factory.OpenSession();<br />
ITransaction transaction = session.BeginTransaction();<br />
User newUser = new User();<br />
newUser.Id = "joe_cool";<br />
newUser.UserName = "Joseph Cool";<br />
...<br />
session.Save(newUser);<br />
...<br />
transaction.Commit();<br />
session.Close();<br />

<br />
IObjectSpace animal = (Animal) objectSpace.CreateObject(typeof(Animal), <br />
          ID, Age, Weight);<br />
objectSpace.BeginTransaction();<br />
objectSpace.Update(animal);<br />
objectSpace.CommitTransaction();<br />

<br />
Create table Problem as (PID int Primary Key, <br />
                         POpenDate DateTime Not Null,<br />
                         Pclosed DateTime Not Null<br />
                         )on primary<br />
Create table Notes as (	NID int PrimaryKey,<br />
			PID int ForegnKey to Problem.PID,<br />
			NEditDate<br />
			)on primary

Select  p.PID, p.POpenDate, n.NEditDate as ‘LastEditDate’, p.PclosedDate <br />
	Form Problems as p INNER JOIN Notes as n on p.PID = n.NID