<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="TstDBConnection.Entities" assembly="TstDBConnection">
<class name="Course" table="Course">
<id name="Id" column="Id">
<generator class="guid.comb"/>
</id>
<property name="Name" column="Name"></property>
<property name="CreatedDate" column="CreatedOn"></property>
</class>
</hibernate-mapping>
namespace TstDBConnection.Entities
{
public class Course
{
public virtual Guid Id { get; set; }
public virtual string Name { get; set; }
public virtual DateTime CreatedDate { get; set; }
}
}
public static void TestSingleTable(ISessionFactory sessionFactory)
{
//Use NHibernate to create an entity and get a list of all entities
using (ISession session = sessionFactory.OpenSession())
{
Course emp = new Course()
{
Name = "English",
CreatedDate = DateTime.Now
};
session.Save(emp);
session.Flush();
var query = from course in session.Query<Course>()
select course;
IList<Course> courses = query.ToList();
}
}
static void Main(string[] args)
{
log4net.Config.XmlConfigurator.Configure(); // log4net
Configuration configuration = new Configuration();
configuration.Configure();
ISessionFactory sessionFactory = configuration.BuildSessionFactory();
TestSingleTable(sessionFactory);
sessionFactory.Close();
}
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAPAAAAB8CAIAAADYRapmAAADZElEQVR4nO3bMW7bWBiFUe9/B9lBiiwgdZoUQZoUgYEAKdI50R6YzlDIJ5p5os2f952DW2hkWrYGnznSgHqYIMjD0b8A7EnQRBE0UQRNFEETRdBEETRRBE0UQRNF0EQRNFEETRRBE0XQRNkz6AfY28FBX54ezfaaoC1qgraoCdqiJmiLmqAtaoK2qNUNevY/Fw//N2WnWMWglxFr2jaubtDr95g1Vy7oLe02X4qs/BnMbjwftvKqxguek+58QS+LvPWNy46vA20e33woTZ9oJwt6y2l4y5dWftDK41j9jR707LTdvF/QJ9q4QV82vxSxE61c0Jf9qv2vRgWdsbpBX39p+ZJg/fbsQZqN3qq/ebzEz7KKQT//ZrMXA80vrdz/4kl3449Q84lWN2izjgnaoiZoi5qgLWpVgv7w/p3ZPSsX9OF/3HbeFQ36z+8ffbs8Pe74W3EugiaKoIkiaKIIeup42pQ1UNDPF2Ms79/xWXCsgYKebrQr6CTjBn19Ad2Oz4JjDRr0rOwdnwXHErSgowha0FEELegoAwU9ewvoTWGkgYJmBIImiqCJUjfoXz+/9k3QI6sb9Pdvn/om6JHVDfrL5499E/TI6gZt1reiQXtTSAdBE0XQRBE0UQRNlIGCnl2H5JqkSIImylhBT1Pjkuhbl5VOrb8Bl5sWJ+iXD5jd3/xeihgu6KkV7uysfOt4nwmob/Sgl+fdLWdoyhox6OnqxXFf0OIua/Sgp80vOa6P3PFZs6+BgmYEgiaKoIlSN2ifKaRD3aB9ppAOdYP2mUI61A3arG9Fg/amkA6CJoqgiSJoogj6tbjk4xDDBX3nNc3bv2t5LZTE38BYQd+fVEfQrjt9SwMF3Xx6y0tGZ6fS2T3r/zgt/guw/KHP9zttvwZB/1PnysHLQJe31+/Z8jjcSdDtk+vyHNwMcf2rzR8q6Fcl6JfPyte37zl+++PQbaCgp20JXt/eHvTKV7ffyf3GCnp66U3b8o3arRch24+/dVjzNncaLmiyCZoogiZK3aB9ppAOdYP2mUI61A3aZwrpUDdos45N01QxaLN7Vitos10maIva8UHDvo4MGg4naKIImiiCJoqgiSJoogiaKIImiqCJImiiCJoogiaKoIkiaKIImiiCJoqgiSJoogiaKIImyl8xTjKqxGLihwAAAABJRU5ErkJggg==)