Server side scripting using in MVC with mapped filed

Question

I have two tables

1) [Client] (ClientID, ClientName, Location, RegNo)

2) [Order] (OrderID, ClientID, ItemName, QTY)

 

I have near about 100000 record in order table I want to use serverside code for speeding data for page load, but I also want clientName should display in order table list. How can I do? Please help. any example will solve my problem.