Thanks a lot Oskar, this helped! I am not sure how and why it worked before, but I've been using the assembly name everywhere. Even my hibernate.cfg.xml has it:
<property name="dialect">NHibernate.Dialect.MsSql2008Dialect, NHibernate</property> Anyway, removing the part after the comma made everything work. Thanks again! On Sunday, October 28, 2012 10:54:31 AM UTC+1, Oskar Berggren wrote: > > According to the last part of section 5.6 ( > http://nhforge.org/doc/nh/en/index.html#mapping-database-object), the > name of the dialect should be given without assembly name. > > The documentation and code for this seems to be unchanged since its > introduction in 2006/2007 so I don't understand how this can have worked > without change in earlier NHibernate versions. > > /Oskar > > > > 2012/10/26 Groo <[email protected] <javascript:>> > >> Hi! >> >> I am having a problem with the SchemaExport tool: it's not generating >> indexes in MS SQL Server 2008. >> >> My NHibernate mappings include a <database-object> element to define >> indexes. The problem is that this SQL doesn't get included in the schema >> when I callSchemaExport.Create (exported file does not contain then). >> Everything else gets created, but there are no indexes. >> >> One of the entities looks like this, for example: >> >> <hibernate-mapping </property>> >> >> <class xmlns="urn:nhibernate-mapping-2.2" >> name="MyApp.Entities.SomeEntity, MyApp.Entities" table="SomeEntity"> >> >> <!- --> >> >> </class> >> >> <database-object> >> <create> >> CREATE INDEX [Idx_SomeEntityIndex] ON [SomeEntity] >> ([Field1] ASC, [Field2] ASC) INCLUDE ( [Field3], [Field4], >> [Field5]) >> CREATE STATISTICS [Stat_SomeEntityStat] ON [SomeEntity] >> ([Field1], [Field2]) >> </create> >> <drop> >> DROP INDEX [Idx_SomeEntityIndex] ON [SomeEntity] >> DROP STATISTICS [Stat_SomeEntityStat] >> </drop> >> <dialect-scope name="NHibernate.Dialect.MsSql2008Dialect, NHibernate"/> >> </database-object> >> </hibernate-mapping> >> >> Strange thing is that this used to work before (probably before moving >> from NH2 to NH3), and I am not sure if something changed in NHibernate >> which prevents this from executing. >> >> Dialect matches my dialect in the config file. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/nhusers/-/q5OVocJ7eRwJ. >> To post to this group, send email to [email protected]<javascript:> >> . >> To unsubscribe from this group, send email to >> [email protected] <javascript:>. >> For more options, visit this group at >> http://groups.google.com/group/nhusers?hl=en. >> > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To view this discussion on the web visit https://groups.google.com/d/msg/nhusers/-/uakUOtjl9m8J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
