Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Prevent Nhibernate schemaexport from generating foreign key constraints on has many relationship

I have a mapping like this:

HasMany(x => x.Orders).KeyColumn("CustomerID");

Which is causing a constraint like this to be generated by schemaexport:

alter table [CustomerOrder] 
    add constraint FK45B3FB85AF01218D 
    foreign key (CustomerID) 
    references [Customer]

I have tried adding .NotFound.Ignore() like on a References() mapping to disable the constraint from being generated but this does not work.

Can a mapping be defined that will force SchemaExport to not generate the constraint?

like image 709
Mike Glenn Avatar asked May 13 '10 12:05

Mike Glenn


1 Answers

Figured it out:

HasMany(x => x.Orders).KeyColumn("CustomerID").ForeignKeyConstraintName("none");

buried in the source is a check to ignore creation if the name is "none"

like image 96
Mike Glenn Avatar answered Oct 28 '22 07:10

Mike Glenn