I'm tring execute this comands:

NHibernate.Tool.hbm2ddl.SchemaExport se = new NHibernate.Tool.hbm2ddl.SchemaExport(Db.Configuration);
se.SetOutputFile(@"C:\SQL\schema.sql");
se.Create(true, true);

The file 'schema.sql' is created in the folder 'C:\SQL\' but it has size 0KB ... and the tables wasn't created in database.

The .hbm.xml files are createds and are runing in other database.

Is this function implemented or i'm doing something wrong ???

Thanks,
RWagner

I tried this and it works correctly for me. Are you sure that the DB.Configuration that you are passing to the SchemaExport is correctly configured, what I mean is that all the mapping files have been added to it by either calling AddAssembly or AddFile or other similar methods. If the configuration has all the assembly added it works ok

Yes the object Db.Configuration is correctly initilized with AddAssembly method ... and this Db.Configuration ir working correctly.
Is needed some configuration in web.config file ???

Thanks

The Db.Configuration was not correctly configured ... and now it's working fine in MSSQL ... but when i try create tables in MySQL it don't generate the correct create command ...

It's creating this comand:

create table Marca (
id int NOT NULL AUTO_INCREMENT unique,
Descricao varchar not null,
primary key (id)
)

but it don't put the length of varchar type ...

create table Marca (
id int NOT NULL AUTO_INCREMENT unique,
Descricao varchar(100) not null,
primary key (id)
)

My .hbm.xml mapping file has the attribute length:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="Entity.Modelo, Carros" table="Modelo">
<id name="Id" type="Int32" unsaved-value="0">
<column name="Id" sql-type="int" not-null="true" unique="true" index="PK_Modelo"/>
<generator class="native" />
</id>
<property name="Descricao" type="String">
<column name="Descricao" length="100" sql-type="varchar" not-null="true"/>
</property>
<many-to-one name="Marca" class="Entity.Marca, Carros">
<column name="idMarca" sql-type="int" not-null="true" index="IX_Modelo"/>
</many-to-one>
</class>
</hibernate-mapping>


i'm doing something wrong ???

Thanks,
RWagnerVM

I modified the method GetSqlType of class NHibernate.Mapping.Column to correct this "bug".

Do i shold register this bug in JIRA ???


public string GetSqlType( Dialect.Dialect dialect, IMapping mapping )
{
if( sqlType == null )
{
SqlType sqlTypeObject = GetAutoSqlType( mapping );
if( Length != DefaultPropertyLength )
{
return dialect.GetTypeName( sqlTypeObject, Length );
}
else
{
return dialect.GetTypeName( sqlTypeObject );
}
}
else
{
if( Length != DefaultPropertyLength )
return sqlType + "(" + Length + ")";
else
return sqlType;
}
}