Check if value of Table A Column A in Table B Column B

onmyway365 .

Hi All,

I hope you can help me. I need help on a method to check whether the value from column A in table A, exists in column B in table B.

I am not sure how to approach this. I believe I need to loop through column B, checking it against the value of column A.

This is what I have so far:

private static void customerCode()

{
   using (var stageContext = new StagingTableDataContext())
{
   var data = stageContext.ProjectMasters;
   var referenceData = stageContext.CustomerMasters;

foreach (var entry in data)
{
//pseudo code
//check if entry.Customer_Number in referenceData.Customer_Code column
}

}

Thank you in advance!

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ehsan Sajjad10y ago

Accepted answer

You can use Linq Any() method here for this:

using (var stageContext = new StagingTableDataContext())
{

   var result= stageContext.CustomerMasters.Where(x=> stageContext.ProjectMasters.Any(y=>y.Customer_Number  == x.Customer_Code )).FirstOrDefault();

if(result !=null)
{
// record found in both tables
}

Ehsan Sajjad10y ago
Welcome :)
onmyway365 .10y ago
Thank you :)
onmyway365 .10y ago
Thank you :)
Ehsan Sajjad10y ago
yes you can do

onmyway365 .10y ago

@Ehsan - Thank you for your response.

May I ask you some details:

Based on you code, will I then be able to add these lines to the "if" section?

using (var stageContext = new StagingTableDataContext())
{

var result= stageContext.CustomerMasters.Where(x=> stageContext.ProjectMasters.Any(y=>y.Customer_Number  == x.Customer_Code )).FirstOrDefault();

if(result == null)
{
sourceDataEntry.Processing_Result = 2;
sourceDataEntry.Processing_Result_Text = "Customer Number Not Found";
sourceDataEntry.Processed_Datetime = DateTime.Now;

}