How to handle database datas in List<>

Question

How to maintaine database datas in List<>

 

 

ID	Name	Qty	Price
A-1	Apple	2	25
A-1	Orange	5	50
A-1	Mango	2	10

 

Query = Select * from Table where ID= 'A-1' ; 

 

how to use List<> to maintaine that table data