The issue is that the "sequence" ID generator is not supported on MS SQL Server. You could change the mapping to <generator class="identity" /> to have it work on SQL Server. Other ID generator strategies work on SQL Server as well, but "identity" is similar to "sequence" and will work fine for testing. Sean Carpenter
On Thu, Oct 30, 2008 at 10:22 PM, HelpNH <[EMAIL PROTECTED]> wrote: > > > > On Oct 30, 7:22 pm, "Fabio Maulo" <[EMAIL PROTECTED]> wrote: > > Hi HelpNH (aka pinkfloyd_mn)Here is a useful link to configure NH: > http://nhforge.org/wikis/howtonh/your-first-nhibernate-based-applicat... > > > > 2008/10/30 HelpNH <[EMAIL PROTECTED]> > > > > > Hi Fabio , > your link is useful and clear,good... > but i have some trouble to mapping the project of Quicoli with SQL > Server . > I studied that project to learn some feature about NHibernate with WPF > i rewrite the project > but when i change the mapping file and Configuration file of > NHibernate to connect the project > with the database i begin to meet difficulties....now i will post the > mapping files and Hibernate.cfg.xml that > i created to connect with SQL Server. > > I Show what i done: > > This is the original <Hibernate.cfg.xml> of Quicoli's project: > > <?xml version="1.0" encoding="utf-8" ?> > <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2"> > <session-factory> > <property > name="connection.provider">NHibernate.Connection.DriverConnectionProvider</ > property> > <property name="dialect">NHibernate.Dialect.FirebirdDialect</ > property> > <property > name="connection.driver_class">NHibernate.Driver.FirebirdClientDriver</ > property> > <property > > name="connection.connection_string">User=SYSDBA;Password=masterkey;Database=WPFNH- > Demo;DataSource=localhost;Dialect=3; Charset=NONE;Role=;Connection > lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet > Size=8192;ServerType=1;</property> > <property name="connection.isolation">ReadCommitted</property> > <property name="use_proxy_validator">false</property> > > <!--For tests only--> > <property name="show_sql">true</property> > </session-factory> > </hibernate-configuration> > > instead i do so to connect with SQL Server > > <?xml version="1.0" encoding="utf-8" ?> > <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2"> > <session-factory> > <property name="connection.provider"> > NHibernate.Connection.DriverConnectionProvider > </property> > <property name="dialect"> > NHibernate.Dialect.MsSql2005Dialect > </property> > <property name="connection.driver_class"> > NHibernate.Driver.SqlClientDriver > </property> > <property name="connection.connection_string"> > Data Source=ERUSYAKO\SQLEXPRESS;Integrated > Security=True; initial > catalog=DemoWPF > </property> > <property name="use_proxy_validator">false</property> > </session-factory> > </hibernate-configuration> > > > and now there are the mapping files of the classes > <Contact.hbm.xml> > <?xml version="1.0" encoding="utf-8" ?> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" > assembly="Domain" namespace="Domain" > > <class name="Contact" table="ContactTbl" > > <id name="Id" column="Id_Contact" type="Int64" > unsaved-value="0"> > <generator class="sequence"> > <param name="sequence">gen_ids</param> > </generator> > </id> > <property name="Name" column="Name" type="string" > not-null="true" / > > > <bag name="Phones" generic="true" > cascade="all-delete-orphan"> > <key column="Id_Contact" /> > <one-to-many class="Phone"/> > </bag> > </class> > </hibernate-mapping> > > > and <Phone.hbm.xml> > > <?xml version="1.0" encoding="utf-8" ?> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" > assembly="Domain" namespace="Domain" > > <class name="Phone" table="PhoneTbl" > > <id name="Id" column="Id_Phone" type="Int64" > unsaved-value="0"> > <generator class="sequence"> > <param name="sequence">gen_ids</param> > </generator> > </id> > <property name="PhoneType" column="PhoneType" > not-null="true" /> > <property name="PhoneNumber" column="PhoneNumber" > type="string" not- > null="true" /> > </class> > </hibernate-mapping> > > > when i debug the project and i wish add a new contact appear an > error :"MappingException was unhandled- could not instantiate id > generator" ...i don't know where i wrong. > Do you have some advice to work out that? > > Thanks so much and for the support . > I wish you happy time. > Bye > > > > > > > > > > > > > How all, > > > after that Paulo Quicoli post the project SimpleDemo about Nhibernate > > > with WPF i studying his project and i rewrite the same project to > > > learn some features till now that's all right but i met a > > > trouble ,on the SimpleDemo project mr.Paulo use Firebird instead i > > > use SQL Server/Express so i wish change the configuration of > > > Hibernate.cfg.xml and the files into the Mapping folder just to > > > connect the project with the database of SQL Server but i cannot > > > (again) or better i dont know the right way to change those > > > configuation file,so there is somebody that can help me ??? > > > Thank so much for the attention. > > > Have a happy time. > > > Bye > > > > > Here there is project of PauloQuicoli > > > > >http://cid-b27ccfaa07b93be8.skydrive.live.com/self.aspx/Public/WPF-NH. > .. > > > > -- > > Fabio Maulo > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. 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 -~----------~----~----~----~------~----~------~--~---
