I don't agree with @JoséASalvador (my namesake), test in a real world database.
On the other hand, you are right.. but I used to create the database manually. What next? Do you want to write some code to install a unit testing instance of the engine? Also, if you want to run unit tests in a continuos integration server you will get problems. Generally speaking you need less rights to execute DDL inside a DB than to create a new database, much less. El 27 de octubre de 2009 09:50, José A. Salvador Vanaclocha < [email protected]> escribió: > El mar, 27-10-2009 a las 23:27 +1100, Dmitiry Nagirnyak escribió: > > Yes. Of course. > But generally speaking you even need rights to generate schema for existing > database. > > Yes, of course, But you do that through the settings you define at > nhibernate configuration which stores your credentials to access to explicit > database, not the server database. > > This is not really related to the actual question. > > I manually execute create schema script for MsSql using existing connection > string (Trusted Conn.) but changing the database to master. With trusted > connection there are plenty of privileges. > > Just want to make sure this is correct approach (during unit testing at > least). > > > I think the best way to achieve this would be through a "mock" embedded > database like sqllite, don't you? > > > > Cheers. > > 2009/10/27 José F. Romaniello <[email protected]> > > The problem is that you need have rights to do that > > 2009/10/26 Dmitiry Nagirnyak <[email protected]> > > > > Hi, > > > > Just wondering is it is possible to tell NHibernate to create the > database if it doesn't exists. > > Obviously, SchemaExport should not do it (and it doesn't). > > > > So lookead at Dialect but it doesn't look it has any interface to do > that. > > > > Currently I workaround it by using my own interface where I create > command and run "create database" query. > > It works ok, but just want to make sure if this is correct approach not > to do the work twice if NH already can do that. > > > > Cheers. > > Dmitriy. > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
