I can combine more than one table but I can not select the columns.

Unal UN asked on January 18, 2018 12:33

Hi, I can combine more than one table but I can not select the columns.

var UserProductOrder = CustomTableItemProvider.GetItems<MyJoinUserItem>().Source(s => s.LeftJoin<MyJoinOrderItem>("ItemID", "UserID").LeftJoin<MyJoinProductItem>("ProductID", "ItemID")).ToList().Select(s => new
    {
        UserName = s.UserName,
        TotalPrice = s.TotalPrice
    });

Recent Answers


Roman Hutnyk answered on January 18, 2018 12:39

Could you please provide a bit more details on the problem you're trying to solve?

0 votesVote for this answer Mark as a Correct answer

Unal UN answered on January 18, 2018 14:03 (last edited on January 18, 2018 14:10)

var UserProductOrder = CustomTableItemProvider.GetItems<MyJoinUserItem>().Source(s => s.LeftJoin<MyJoinOrderItem>("ItemID", "UserID").LeftJoin<MyJoinProductItem>("ProductID", "ItemID")).ToList().Select(s => new
    {
        UserName = s.UserName,
        TotalPrice = s.TotalPrice
    });
0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.