Problem :
有些搜索可以存储在DB中 . 每个搜索都有一组过滤器 . 还有角色 . 每个角色可以(可空列)分配一个默认搜索 . 此外,每个搜索对零或多个角色(多对多关系)可见 .
当我尝试访问搜索过滤器时,NH尝试访问过滤器表中不存在的filters.DefaultSearchId .
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)
);
Entities:
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; }
}
Mappings:
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");
}
}
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:
访问search.Filters属性时,NHibernate尝试访问不应该存在的Filters.DefaultSearchId db列 . 此列存在于Roles表中,但不存在于过滤器中 .
QUESTION:
是配置无效,Fluent NHibernate还是NHibernate错误?
我正在使用SQL Server 2008 R2,NHibernate 2.1.2和Fluent NHibernate 1.1.0.685,尽管这个问题也存在于NHibernate 3 beta 2中 .
谢谢 .
更新:这是生成的actual SQL
UPDATE2:CDMDOTNET,同样的错误,同样的sql,不幸的是 .
更新3:Actual exception
更新4:这是一般错误的特定用例:实体引用其他实体为'many-to-many',另一方面引用'many-to-many' assoc . 另一个实体引用源实体(在我的例子中是DefaultQuery) . 当访问源实体的 any 子集合(一对多)时,NH会疯狂(在我的情况下是过滤器) .
更新5:Sample data
2 回答
更新SearchMap上的HasMany映射以包含KeyColumn():
HasMany(x => x.Filters) .KeyColumn("SearchId") .Inverse() . Cascade.All() . AsBag();
您没有指定Filters包的列名 . 它应该设置为SearchId .