namespace my_test
{
    public class Cat
    {
        private int id;
        private string name;
        private string sex;
         public virtual int Id
        {
            get { return id; }
            set { id = value; }
        }
        public virtual string Name
        {
            get { return name; }
            set { name = value; }
        }
        public virtual string Sex
        {
            get { return sex; }
            set { sex = value; }
        }
    }

}

namespace my_test
{
    class Program
    {
        
        static void Main(string[] args)
        {
            ISessionFactory sessionFactory = new Configuration().Configure().BuildSessionFactory();
            
            ISession currentSession;
            currentSession=sessionFactory.OpenSession();
            ITransaction tx = currentSession.BeginTransaction();
          
            Cat princess = new Cat();
            princess.Id = 1;
            princess.Name = "Murka";
            princess.Sex = "F";

            try
            {
                currentSession.Save(princess);
                tx.Commit();
            }
            catch (Exception e) { Console.WriteLine(e); }

            currentSession.Close();

create table Cats
(
 Id     int ,
 Name   varchar( 20 ),
 Sex    varchar( 1 )
)

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
    namespace="my_test" assembly="my_test">

    <class name="my_test.Cat" table="Cats" lazy="true">

      <id name="ID" type="Int32" >      
        <generator class="assigned"/>
      </id>
      
        <property name="Name" column="Name" type="String" />
        <property name="Sex" column="Sex" type="String" />

    </class>

</hibernate-mapping>

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <configSections>
    <section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate" />
  </configSections>
  <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
    <session-factory>
      <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
      <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
      <property name="connection.connection_string">Data Source=GATEWAY\SQLEXPRESS;Initial Catalog=vininfo;User ID=sa;Password=lbyfvj</property>
      <property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>
      <property name="proxyfactory.factory_class">NHibernate.ByteCode.LinFu.ProxyFactoryFactory, NHibernate.ByteCode.LinFu</property>
      <mapping assembly="my_test"/>
    </session-factory>
  </hibernate-configuration>
</configuration>