Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 21, 2013 04:59 AM by jeff lee
Member
237 Points
255 Posts
Jan 06, 2013 03:03 PM|LINK
I have six tables in my SQL Server database.
Step 1: I
UNION ALL
Datatable1
Step 2: I
Datatable2
In all the 6 tables the common columns are
AlbumID
PictureID
StoryID
Now I want to compare these columns in both the
Datatables
I am thinking to use
Linq
Lambda Expression
TABLE JOINS
Basically the table should have 4 columns :-
AlbumID, PictureID, StoryID, Flag
Flag
296 Points
48 Posts
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/
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
Table 1, Table 2 and Table 3 into .Step 2: I
Table 4, Table 5 and Table 6 into .In all the 6 tables the common columns are
,,.Now I want to compare these columns in both the
and put a flag (True) in where the data in both the datatables match else False.I am thinking to use
or to do the comparison. Is this the correct/best way to do this? OR should I go for ?Basically the table should have 4 columns :-
would be true only if or or is present injeff 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/