using System;

using System.Data;

using System.Collections.Generic;

using NHibernate;

using NHibernate.Cfg;

using NHibernate.Mapping.ByCode;

using NHibernate.Mapping.ByCode.Impl;

using NHibernate.Cfg.MappingSchema;

using NHibernate.Tool.hbm2ddl;

using Community.CsharpSqlite.SQLiteClient;

​

public class Program

{

    public static void Main()

    {

        var conn=new SQLiteConnection();

        var cfg=ConfigureNHibernate();

        var sessionFactory=cfg.BuildSessionFactory();

        var session = sessionFactory.OpenSession();

        new SchemaExport(cfg).Execute(true, true, false, session.Connection, null);

    }

​

    private static Configuration ConfigureNHibernate()

    {

        var configure = new Configuration();

        configure.SessionFactoryName("BuildIt");

        configure.DataBaseIntegration(db =>

        {

            db.Dialect<NHibernate.Dialect.SQLiteDialect>();

            db.Driver<NHibernate.Driver.SQLite20Driver>();

            db.ConnectionString = "Data Source=:memory:;Version=3;New=True;Pooling=True;Max Pool Size=1;";

            db.ConnectionReleaseMode = ConnectionReleaseMode.OnClose;

        }

​

        );

        var mapping = GetMappings();

        configure.AddDeserializedMapping(mapping, "NHSchemaTest");

        return configure;

    }

​

    private static HbmMapping GetMappings()

    {

        var mapper = new ModelMapper();

        mapper.Class<Person>(e =>

        {

            e.Id(c => c.Id, c => c.Generator(Generators.GuidComb));

            e.Set(c => c.Properties, c => {

                c.Inverse(true);

                c.Key(k=>k.Column("PersonId"));

            },c=>c.OneToMany());

        }

​

        );

        mapper.Class<PersonProperty>(e =>

        {

            e.Id(c => c.Id, c => c.Generator(Generators.GuidComb));

            e.ManyToOne(c => c.Owner);

        }

​

        );

        var hbmMapping = mapper.CompileMappingForAllExplicitlyAddedEntities();

        return hbmMapping;

    }

}

​

public class PersonProperty

{

    public virtual Guid Id

    {

        get;

        set;

    }

​

    public virtual Person Owner{get;set;}

}

​

public class Person

{

    public Person()

    {

        Properties = new HashSet<PersonProperty>();

    }

​

    public virtual Guid Id

    {

        get;

        set;

    }

​

    private ICollection<PersonProperty> _properties;

    public virtual ICollection<PersonProperty> Properties

    {

        get;

        set;

    }

​

    public virtual void AddProperty(PersonProperty property)

    {

        property.Owner = this;

        _properties.Add(property);

    }

​

    public virtual void RemoveProperty(PersonProperty property)

    {

        property.Owner = null;

        _properties.Remove(property);

    }

}