var taskMessages = from d in result
join ptask in db.ListingTask.Entites on new
{
d.Id,
TaskType = ListingTaskType.Offer.ToString()
} equals new
{
Id = ptask.DraftId,
ptask.TaskType
} into temp
from t in temp.DefaultIfEmpty()
select new
{
DraftId = d.Id,
OfferMessage = t == null || string.IsNullOrEmpty(t.Message) ? "无" : t.Message,
OfferSubmitResult = t == null || string.IsNullOrEmpty(t.Result) ? "无" : t.Result,
d.UserName,
d.UpdateTime,
d.Stock
};
在这个LINQ查询中,当我需要结果中的所有属性时,我需要用select new {}
编写每个属性,有没有简单的方法可以做到这一点?
发布于 2017-05-31 15:48:24
将这两个对象放入result对象:
var taskMessages = from d in result
join ptask in db.ListingTask.Entites on new
{
d.Id,
TaskType = ListingTaskType.Offer.ToString()
} equals new
{
Id = ptask.DraftId,
ptask.TaskType
} into temp
from t in temp.DefaultIfEmpty()
select new
{
// you would obviously need better names
object1 = t,
object2 = d
};
然后像这样访问属性:
taskMessages[0].object2.UpdateTime; //Just as an example
Update (OP希望直接使用结果中的所有属性):
您可以通过C#交互式窗口中的反射获取所有属性的列表,并构造字符串输出以粘贴到代码中,如下所示:
#r "C:/MyApp/bin/Debug/Foo.dll"
using MyApp;
var myType = typeof(Person);
var myProperties = myType.GetProperties();
foreach(var myProperty in myProperties) { Console.WriteLine($"{myProperty.Name} = myObject.{myProperty.Name},"); }
Foo.dll是您的程序集,它也可以是可执行文件
https://stackoverflow.com/questions/44278644
复制相似问题