`
ribishuangba
  • 浏览: 289228 次
文章分类
社区版块
存档分类
最新评论

WCF RIA Services & EF - Tip: Silverlight端访问外键关联实体

 
阅读更多

问题:在Domain Service中使用EF 4 实现如下数据访问,通过Include语句获得Job所关联的Vehicle实体

public IQueryable<Job> GetRunsByVehicleDate(int vehicleID, DateTime date)
{
date = date.Date;
DateTime dateNext = date.AddDays(1);
var result = this.ObjectContext.Jobs.Include("Vehicle").Include("Location").Include("TimeSlot")
.Where(j => j.JobDate >= date && j.JobDate <= dateNext && j.VehicleID == vehicleID)
.OrderBy(j => j.JobDate);
return result;

}

然而在Silverlight端,job.Vehicle 得到的却是null

原因:RIA没有将关联实体在客户端代码上正确生成

解决:使用Include 属性并修饰Job实体如下,

[MetadataType(typeof(JobMetaData))]
partial class Job : IEntity
{

public class JobMetaData
{
[Include]
public Vehicle Vehicle { get; set; }

[Include]
public Location Location { get; set; }

}
}

注意:Include来自 System.ServiceModel.DomainServices.Server.dll at path like

C:/Program Files (x86)/Microsoft SDKs/RIA Services/v1.0/Libraries/Server

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics