NHibernate + Fluent NHibernate Exception

Question

Problem

There are search queries that can be stored in the database. Each search contains a set of filters. There are also roles. Each role can have a (zero column) default search assigned by default. In addition, each search is visible to zero or many roles (many-to-many relationship).

When I try to access search filters, NH tries to access .DefaultSearchId filters that are not in the filter table.

DB:

CREATE TABLE [dbo].[Searches]
(
    Id int identity(1,1) primary key,
    Description nvarchar(2000) not null
);

CREATE TABLE [dbo].[Filters]
(
    Id int identity(1,1) primary key,
    Description nvarchar(2000) not null,
    SearchId int not null references Searches(Id)
);

CREATE TABLE [dbo].[Roles]
(
    Id int identity(1,1) primary key,
    Name nvarchar(255) not null,
    DefaultSearchId int null references Searches(Id)
);
CREATE TABLE [dbo].[SearchesRoles]
(
    SearchId int not null references Searches(Id),
    RoleId int not null references Roles(Id)
);

Objects:

  public class Search {
        public virtual int Id { get; set; }
        public virtual string Description { get; set; }
        public virtual ICollection<Filter> Filters { get; set; }
        public virtual ICollection<Role> Roles { get; set; }
    }

    public class Filter {
        public virtual int Id { get; set; }
        public virtual string Description { get; set; }
        public virtual Search Search { get; set; }
    }

    public class Role {
        public virtual int Id { get; set; }
        public virtual string Name { get; set; }
        public virtual Search DefaultSearch { get; set; }
    }

Display:

 public class SearchMap : ClassMap<Search>{
        public SearchMap() {
            Table("Searches");
            Id(x => x.Id).GeneratedBy.Identity();
            Map(x => x.Description);
            HasMany(x => x.Filters).Inverse().Cascade.All().AsBag();
            HasManyToMany(x => x.Roles).Table("SearchesRoles").ParentKeyColumn("SearchId").ChildKeyColumn("RoleId");
        }
    }

 public class FilterMap : ClassMap<Filter> {
        public FilterMap() {
            Table("Filters");
            Id(x => x.Id).GeneratedBy.Identity();
            Map(x => x.Description);
            References(x => x.Search).Column("SearchId");
        }
    }
 public class RoleMap : ClassMap<Role> {
        public RoleMap() {
            Table("Roles");
            Id(x => x.Id).GeneratedBy.Identity();
            Map(x => x.Name);
            References(x => x.DefaultSearch).Column("DefaultSearchId");
        }
    }

The code:

class Program {
        static void Main() {
            var sessionFactory = CreateSessionFactory();
            using (var session = sessionFactory.OpenSession()) {
                var search = session.Get<Search>(1);
                foreach (var filter in search.Filters) {
                    Console.WriteLine(filter);
                }
            }
        }

        static ISessionFactory CreateSessionFactory(){
            string connectionString = @"server=.\sql2008; user id = sa; pwd=1; database = nhbug;";
            return Fluently.Configure()
                .Database(MsSqlConfiguration.MsSql2008.ConnectionString(connectionString))
                .Mappings(m=>m.FluentMappings.AddFromAssembly(Assembly.GetExecutingAssembly())).BuildSessionFactory();
        }
    }

Error:

When accessing the search.Filters property, NHibernate tries to access the DFS DFS column, which should not be there. This column exists in the role table, but not in the filters.

Question:

Is this the wrong configuration, Fluent NHibernate or NHibernate error?

SQL Server 2008 R2, NHibernate 2.1.2 Fluent NHibernate 1.1.0.685, NHibernate 3 beta 2.

.

UPDATE: SQL,

UPDATE2: CDMDOTNET, , sql, .

UPDATE3:

UPDATE4: : Entity "--" "--". (DefaultQuery ). NH any ( ) ( ).

UPDATE5:

UPDATE6: XML, Fluent NHibernate

Answer 1

HasMany SearchMap, KeyColumn():

HasMany (x = > x.Filters) .KeyColumn( "SearchId" ).Inverse(). Cascade.All(). AsBag();

Answer 2

Filters. SearchId.