Table Joins or Linq/Lambda expression comparison RSS

• • Reply
  

  bronxbull

  Member

  237 Points

  255 Posts

  Table Joins or Linq/Lambda expression comparison

  Jan 06, 2013 03:03 PM|LINK

  I have six tables in my SQL Server database.

  Step 1: I 

  UNION ALL

   Table 1, Table 2 and Table 3 into 

  Datatable1

  .

  Step 2: I 

  UNION ALL

   Table 4, Table 5 and Table 6 into 

  Datatable2

  .

  In all the 6 tables the common columns are 

  AlbumID

  ,

  PictureID

  ,

  StoryID

  .

  Now I want to compare these columns in both the 

  Datatables

   and put a flag (True) in 

  Datatable1

  where the data in both the datatables match else False.

  I am thinking to use 

  Linq

   or 

  Lambda Expression

   to do the comparison. Is this the correct/best way to do this? OR should I go for 

  TABLE JOINS

  ?

  Basically the table should have 4 columns :-

  AlbumID, PictureID, StoryID, Flag

  Flag

   would be true only if 

  AlbumID

   or 

  PictureID

   or 

  StoryID

   is present in 

  Datatable2

• • Reply
  

  jeff lee

  Member

  296 Points

  48 Posts

  Re: Table Joins or Linq/Lambda expression comparison

  Jan 21, 2013 04:59 AM|LINK

  please refer:

  http://tiredblogger.wordpress.com/2007/07/11/table-joins-in-linq-good-bad-and-complexly-ugly/

   

  • Marked as answer by Mark - MSFT on Feb 04, 2013 05:27 AM