I have the below query, which I want filtered on every keystroke in a textbox. Ive got it working but its painfully slow. SQ_SysproHis_Step3 is a view on the server, when run on the server it takes a good 15 seconds to run, but my understanding is that entity framework will then store alot of the data locally so i would expect the load to possibly be slow but the filtering to be quick? But this isnt the case?
private void LoadGrid()
using (SmartQuoteEntities CounterfeitContext = new SmartQuoteEntities())
var counterfeits = from d in CounterfeitContext.SQ_SysproHis_Step3
flx_SysproArchive.ItemsSource = counterfeits.ToList();
private void txtStockCode_TextChanged(object sender, TextChangedEventArgs e)