How to create database and tables ?

[fernandopaiva]

I'm trying create database using FluentNHibernate. I want to create the database and tables. I want to create database but after create does not drop tables it only make update.

In Java has createDatabaseIfNotExist=true but I'm not finding it to C#

There's any way to do this ?

trying.

private static ISessionFactory createConnection() {

            if (session != null)
                return session;

            //database configs
            FluentConfiguration _config = Fluently.Configure().Database(MySQLConfiguration.Standard.ConnectionString(
                                                                       x => x.Server(HOST).
                                                                          Username(USER).
                                                                          Password(PASSWORD).
                                                                          Database(DB)
                                                                        ))
                                                                        .Mappings(m => m.FluentMappings.AddFromAssemblyOf<PerfilMap>())
                                                                        .Mappings(m => m.FluentMappings.AddFromAssemblyOf<ModuloMap>())
                                                                        .Mappings(m => m.FluentMappings.AddFromAssemblyOf<PermissaoMap>())
                                                                        .Mappings(m => m.FluentMappings.AddFromAssemblyOf<UsuarioMap>())
                                                                        .Mappings(m => m.FluentMappings.AddFromAssemblyOf<CategoriaMap>())
                                                                        .Mappings(m => m.FluentMappings.AddFromAssemblyOf<SubcategoriaMap>())
                                                                        .ExposeConfiguration(cfg => new SchemaUpdate(cfg).Execute(false, true));

            session = _config.BuildSessionFactory();
            return session;
        }

[chester89]

I assume you're looking for a way to generate DB schema from your mappings.
If that's true - here's a way

[fernandopaiva]

@chester89 Yep, I want to create DB Schema. I saw the link that you suggested but I can't do it work because it no has details for example connection with db.

Can you pass me any example ?

[hazzik]

Answered.