Monday 21 November 2016

join between two table in linq C#

var paymentMethos = from p in DbContext.StagingPaymentMethods
                                join c in DbContext.StagingContributions on p.ContributionGuid equals c.StagingContributionGuid
                                where c.ImportMappingGuid == importMappingGuid
                                select p;
            var creditCards = from cr in DbContext.StagingCreditCards
                              join c in DbContext.StagingContributions on cr.ContributionGuid equals c.StagingContributionGuid
                              where c.ImportMappingGuid == importMappingGuid
                              select cr;

No comments:

Post a Comment