Coffeehouse Thread

2 posts

Full Joins in Linq

Back to Forum: Coffeehouse
  • User profile image
    spottedmah

    In my humble in opinion, Linq needs better outer join support.  See this stackoverflow thread on how to perform a full join.

    Do I stand alone?  Does anyone else find this very limiting?

    Nowadays I pretty much use LinqPad and only SSMS and SQL when I have to.  Linq is definitely not an improvement with outer joins.  For most everything else I do, Linq is more efficient to develop.

     

    MD

  • User profile image
    JoshRoss

    That's kind of crazy, how can something so simple be so complicated?

    something like this:

    select * from a full outer join b on a.id = b.id

    turns into a wall of seemingly impenetrable logic.

    Would the zip extension method work for this?

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.