Can someone tell me why when I first execute the tableAdapter to GetData() or Fill (), It takes along process time to give back data. It only happens the very first time. But the thing I don't understand is After the first execute of any tableAdapter I call, it works or run much faster. Its always the initial execute.
Can someone assist me.
The logic I am using is below:
var List = from s in this.colorTableAdapter.GetData()
select s;
ColorSerialPartNumberComboBox.DataSource = List.Select(t => t.colorSerialNumber).ToList();