开发者

LINQ to SQL: How to handle ambiguous column names when joining tables?

开发者 https://www.devze.com 2023-02-17 08:53 出处:网络
I\'m going to bootstrap this question with a previous one I asked: LINQ to SQL: Multiple joins ON multiple Columns. Is this possible?

I'm going to bootstrap this question with a previous one I asked:

LINQ to SQL: Multiple joins ON multiple Columns. Is this possible?

So I have a LINQ query:

var query =
    from t1 in myTABLE1List // List<开发者_开发技巧TABLE_1>
    join t2 in myTABLE1List
      on new { t1.ColumnA, t1.ColumnB } equals new { t2.ColumnA, t2.ColumnB }
    join t3 in myTABLE1List
      on new { t2.ColumnA, t2.ColumnB } equals new { t3.ColumnA, t3.ColumnB }
  select new {t1.ColumnA, t2.ColumnA, t3.ColumnA } // Duplicate Anon type 'ColumnA'

How can I resolve this?


With explicit naming of the properties of the anonymous type

select new {t1A = t1.ColumnA, t2A = t2.ColumnA, t3A = t3.ColumnA } 
0

精彩评论

暂无评论...
验证码 换一张
取 消