public void EF_Select_Mapping()
{
var expected = new[]
{
new
{
IsTransform = "N",
TransformDescription = "未轉換",
Status = "10",
StatusDescription = "已開立"
},
new
{
IsTransform = "Y",
TransformDescription = "已轉換",
Status = "99",
StatusDescription = "已核准"
}
};
using (var dbContext = new LabDbContext())
{
var orders = dbContext.Orders
.AsNoTracking()
.ToList()
.Select(p => new
{
p.Id,
p.IsTransform,
TransformDescription =
DefineManager.GetLookup <TransferStatus>()[p.IsTransform].Description,
p.Status,
StatusDescription =
DefineManager.GetLookup <ApproveStatus>()[p.Status].Description
})
.ToList()
;
orders.Should()
.BeEquivalentTo(expected, option =>
{
option.WithoutStrictOrdering();
return(option);
});
}
}
public void GetLookup_By_TransferStatus_Y()
{
var description = DefineManager.GetLookup <TransferStatus>()["Y"].Description;
Assert.AreEqual("已轉換", description);
}
public void GetLookup_By_ApproveStatus_Open()
{
var description = DefineManager.GetLookup <ApproveStatus>()["10"].Description;
Assert.AreEqual("已開立", description);
}