如何配置流畅的NHibernate显式左/内连接的关联&
本文关键字:连接 关联 NHibernate 配置 何配置 | 更新日期: 2023-09-27 18:18:18
首先,一些代码来解释我的配置:
public class OrdersSessionFactoryCreator
: ISessionFactoryCreator
{
public NHibernate.ISessionFactory Create()
{
var ret =
Fluently
.Configure()
.Database(MsSqlConfiguration
.MsSql2008
.DoNot.UseOuterJoin()
.UseReflectionOptimizer()
.ShowSql()
.FormatSql()
.ConnectionString(ex =>
ex.FromConnectionStringWithKey("OrdersSqlServer")))
.Mappings(
x =>
x.AutoMappings.Add(
AutoMap.AssemblyOf<Order>(new AutoConfig()).UseOverridesFromAssemblyOf<Order>()
.Conventions.Add<DefaultStringLengthConvention>()
.Conventions.Add(DefaultCascade.None())))
.ExposeConfiguration(config => new SchemaExport(config).Create(true, true))
.BuildSessionFactory();
return ret;
}
}
现在,域模型:
public class Order : EntityBase
{
public Order(Guid id)
: base(id)
{
}
protected Order()
{
}
public virtual Customer Customer { get; set; }
}
public class Customer : EntityBase
{
public Customer(Guid id)
: base(id)
{
}
protected Customer()
{
}
public virtual IList<Order> Orders { get; set; }
}
public class OrderMap : IAutoMappingOverride<Order>
{
public void Override(AutoMapping<Order> mapping)
{
//mapping.HasOne(c => c.Customer).Not.LazyLoad().Cascade.All();
mapping.References(c => c.Customer).Not.Nullable();
}
}
public class CustomerMap : IAutoMappingOverride<Customer>
{
public void Override(AutoMapping<Customer> mapping)
{
mapping.HasMany(o => o.Orders).Cascade.All().Fetch.Join();
}
}
现在,如果我做这样的查询:
var orders = session.Query<Customer>().SelectMany(c => c.Orders).ToArray();
我在我的客户上得到一个合适的内连接。但是如果我从另一边做同样的事情:
var or = session.Query<Order>().Select(c => c.Customer).ToArray();
我得到了一个LEFT JOIN
,它可以在大数据上造成严重的性能下降。
问题是:是否有任何方法可以指示NH使用INNER JOIN
为所有不可空的引用列,所以我不被迫使用QueryOver
?
你试过真正的join吗
var ordersWithCustomers =
from o in Session.Query<Order>()
join c in Session.Query<Customer>() on o.Customer.Id equals c.Id
select o;
return ordersWithCustomers.ToArray();
你可以尝试在OrderMap: IAutoMappingOverride中使用Cascade.All()吗