anik butt

anik butt

  • NA
  • 1
  • 826

fetching records from multiple tables ado.net c#

Jan 21 2015 2:51 PM
Guys i need ur help.Here is the scenario
One Printer Can have multiple PriterTrays and PaperSizes,Schema is given below.
Table Schema : 3 Tables
1)Printer:
PrinterId,Name,PrinterStatus
1,ABC,2
2)PrinterTray
PrinterTrayId,Name,PrinterID
100,xyz,1
101,ddy,1
2)PaperSizes
paperSizeId,Name,PrinterId
1,abc,1
2,dww,1
BusinessObject/Model : (it will have complete information of printer along with respective printerTrays and printerSizes,as shown below)
class => Printer
printerid,
Name,
printerStatus,
list of PaperTrays;
list of paperSizes;
I want to fetch the records from Printer table and also dump the values of associated tables(PrinterTrays and Papersizes) using ado.net(Datatable,Dataset etc Not entity Framework).So that i can Map them with Business Object.
Thanks

Answers (1)