Nymhar Quines

Nymhar Quines

  • NA
  • 136
  • 110.9k

linq and looping

May 8 2013 9:57 PM
Sample data from table: Table Name - SUPPLIERS and Entity Name - dbData


RECORD_NO     ID_NO      FIRST_BRANCH     SECOND_BRANCH   POSITION
----------------------------------------------------------------
   1      05100242     05100243         05100244         L
   2       05200443     05100245         05100247         L
   3       05100244     05100248                          R
   4       05100245     05100249                           L
   5       05100247     05100250                           R
   6       05100248                                        L
   7       05100249                                        L
   8       05100250                                        L




if you get all the branch of 05100242, use the query 
int suppliers = dbData.SUPPLIERS.where(x=>x.RECORD_NO !=1).Count();


THE QUESTION IS HOW ARE YOU GOING TO GET THE SUPPLIERS(COUNT) OF 05100243 & 05100244 using query and loop OR ANY METHOD USE TO GET THE RESULTS?


TO GET THE RESULT OF 05100242 I used
var data = dbData.SUPPLIERS.where(x=>x.ID_NO == 05100243);
string left = data.FIRST_BRANCH;
var leftbranch = dbData.where(x=>x.ID_NO == left);
string right = data.SECOND_BRANCH;
var leftbranch = dbData.where(x=>x.ID_NO == right);






YOU CAN USE THAT METHOD BUT MANUALLY SPEAKING,YOU DID'NT KNOW HOW TO STOP AND HOW MANY ROWS BECAUSE IT IS INCREASING.




ANYONE WHO KNOWS THE SOLUTION FOR THIS? using a class that will count the left and right side?

Answers (2)