Thanks for your help.

For the record, for your suggestion to work, I had to define the
schema at the class/table level rather than at the default level.
I.e.:

This:

<hibernate-mapping>
    <class schema="Foo.dbo" table="Bar">
    </class>
</hibernate-mapping>

Instead of:

<hibernate-mapping schema="Foo.dbo">
    <class table="Bar">
    </class>
</hibernate-mapping>

Unless there are ways of setting the default schema to null
programatically?


On Apr 22, 1:59 pm, Ayende Rahien <[email protected]> wrote:
> yesforeach(var classMapping in cfg.ClassMappings)
> {
>     classMapping.Schema = null;
>
> }
> On Wed, Apr 22, 2009 at 8:45 AM, Charlie M <[email protected]> wrote:
>
> > Is there a way to do this programatically using NH?
>
> > On Apr 22, 1:23 pm, Ayende Rahien <[email protected]> wrote:
> > > In the test, change the mapping to remove the schema.
>
> > > On Wed, Apr 22, 2009 at 4:57 AM, Charlie M <[email protected]> wrote:
>
> > > > Hello,
>
> > > > I'm trying to use the DatabaseTestFixtureBase class teamed with SQLite
> > > > to achieve speedy in-memory database unit tests.
>
> > > > I was previously using AR but have since reverted to using NH
> > > > directly, a move that has seen me define a schema attribute for my
> > > > mapped entities. E.g.:
>
> > > > <hibernate-mapping schema="Foo.dbo">
> > > >    <class table="Bar">
> > > >    </class>
> > > > </hibernate-mapping>
>
> > > > etc.
>
> > > > However, it turns out that SQLite is not fond of SQL Server's dot
> > > > notation. I'm receiving the following error:
>
> > > > Unsuccessful: create table Foo.dbo_Bar
> > > > SQLite error unknown database Foo
>
> > > > Are there any possible work-arounds?
>
> > > > Cheers,
>
> > > > Charlie.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Rhino Tools Dev" 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/rhino-tools-dev?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to