WCF+EF的一个问题

实体：

 

[Serializable]
    [DataContract]
    public class Employee
    {
        [DataMember]
        [Key]
        [Required]
        public int ID { get; set; }
        [DataMember]
        public string Name { get; set; }
        [DataMember]
        public string PosName { get; set; }
        [DataMember]
        public int? Gender { get; set; }
        
    }

接口：

[OperationContract]
        IQueryable<Employee> GetEmps(int organzationId);

 

实现：

public IQueryable<Employee> GetEmps(int organzationId)
        {
            return _objContext.ExecuteStoreQuery<Employee>("select u.ID,e.Name,P.Name as PosName,e.Gender from sys_user u inner join hr_employee e on u.ID=e.[User] inner join hr_Position p on e.Position=p.ID where u.Forbidden=0 and e.Organization=@orgid", new SqlParameter("@orgid", organzationId)).AsQueryable();
        }

运行，没有问题，但是在实体里增加一个byte[]类型的属性，如下：

[Serializable]
    [DataContract]
    public class Employee
    {
        [DataMember]
        [Key]
        [Required]
        public int ID { get; set; }
        [DataMember]
        public string Name { get; set; }
        [DataMember]
        public string PosName { get; set; }
        [DataMember]
        public int? Gender { get; set; }
        [DataMember]
        public byte[] Photo { get; set; }
    }

 

运行，报错：服务积极拒绝。但是调试服务端，并不出错。经尝试，将接口改成如下：

[OperationContract]
        IList<Employee> GetEmps(int organzationId);

实现改成如下：

public IList<Employee> GetEmps(int organzationId)
        {
            return _objContext.ExecuteStoreQuery<Employee>("select u.ID,e.Name,P.Name as PosName,e.Gender,e.Photo from sys_user u inner join hr_employee e on u.ID=e.[User] inner join hr_Position p on e.Position=p.ID where u.Forbidden=0 and e.Organization=@orgid", new SqlParameter("@orgid", organzationId)).ToList();
        }

 

运行OK。

分析：应该是执行AsQuery操作是延迟加载数据，而执行ToList操作则立即加载数据。但是为什么在无byte[]类型的属性时就能正常运行，我还没弄明白。