fetching records from multiple tables using ado.net and mapping them to Business objects C#

Vote count:

0

Here si 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

asked 26 secs ago

user3782663

1

fetching records from multiple tables using ado.net and mapping them to Business objects C#