我使用Massive并有一个Members表。在我的Members类中,我有一个find方法来通过电子邮件查找成员:
public class Members : DynamicModel
{
public Members(): base("TSConnection", "Members", "Id"){}
public dynamic Find(string email)
{
dynamic result = new ExpandoObject();
result.Success = false;
try
{
result.Member = this.Single(where: "Email=@0", args: email);
result.Success = result.Member != null;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return result;
}
}
这将按照预期返回所有内容,并在单独的单元测试中测试result.Member.Id
显示它已填充了数据。
在一个单独的类中,我尝试使用这个方法来检查用户是否存在并检索Member。为特定成员插入地址时使用的Id:
public class Addresses : DynamicModel
{
public Addresses() : base("TS", "Addresses", "Id") { }
public dynamic Create(string email, string type, string address1, string address2, string city, string state, int countryId, string postcode)
{
var members = new Members();
dynamic result = new ExpandoObject();
result.Success = false;
//var member = members.Find(email);
result.Member = members.Single(where: "Email=@0", args: email);
dynamic address = new ExpandoObject();
if (result.Member != null)
{
address.Id = this.Insert(new {
MemberId = result.Member.Id,
AddressTypeId = (int)AddressType.Account,
Address1 = address1,
Address2 = address2,
City = city,
State = state,
Country = countryId,
Postcode = postcode
});
result.Address = address.Id != 0 ? address : null;
result.Success = address.Id != 0;
}
return result;
}
}
在读取var member = members.Find(email);
的选项卡上,当我试图访问member.Member.Id
时,这将返回一个RuntimeBinderException。我进入代码和查找方法是"返回"正确的数据,但它没有被传递给变量成员。奇怪的是,当我使用下面一行的代码检索用户时:
result.Member = members.Single(where: "Email=@0", args: email);
很好。但这并不利于保持干燥。发生了什么,有一种方法,我可以使用查找方法从我的成员类在我的地址类?
劳埃德这是因为您从Find
返回result
,这是ExpandoObject
。要访问Addresses
中的Member
,您需要将代码更改为:
var members = new Members();
var result = members.Find(email);
var member = result.Member;