带有联接的 EF 4.1 ExecuteStoreQuery
是否可以将具有连接结果的 ExecuteStoreQuery 映射到域对象?
即我们有 2 个域对象
public class Customer
{
public virtual int Id { get; set; }
public virtual string Name { get; set; }
public virtual ICollection<Order> Orders { get; set; }
}
,
public class Order
{
public virtual int Id { get; set; }
public virtual string Description { get; set; }
public virtual int CustomerId { get; set; }
public virtual Customer Customer { get; set; }
}
现在如果我运行此查询:
string query = "select * from Order as Order
inner join Customer as Customer on Order.CustomerId = Customer.Id
where freetext(Order.Description, 'something')";
_objectContext.ExecuteStoreQuery<Order>(query);
结果将是所有客户设置为空的订单集合。 我该如何解决这个问题?
谢谢你!
Is it possible to map ExecuteStoreQuery with joins result to domain objects?
i.e. we have 2 domain objects
public class Customer
{
public virtual int Id { get; set; }
public virtual string Name { get; set; }
public virtual ICollection<Order> Orders { get; set; }
}
and
public class Order
{
public virtual int Id { get; set; }
public virtual string Description { get; set; }
public virtual int CustomerId { get; set; }
public virtual Customer Customer { get; set; }
}
and now if i'll run this query:
string query = "select * from Order as Order
inner join Customer as Customer on Order.CustomerId = Customer.Id
where freetext(Order.Description, 'something')";
_objectContext.ExecuteStoreQuery<Order>(query);
the result will be collection of orders with all customers set to null.
how can i fix this ?
Thank You!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论