Improving Performance for WPF with Enterprise Library

See more:

WPF

enterprise

Hi there,

We are having some performnace issues with our WPF application. We are using WPF with PRISM and for data layer we are using Enterprise Library. We have search screen where in we will provide 10 search criteria's , When we search for one value, SP is returning the values quickly but in Enterprise Library we use executereader some thing like this

  int changeUserIDOrdinal = reader.GetOrdinal("ChangeUserID");
                        int changeDateOrdinal = reader.GetOrdinal("ChangeDate");

                        while ((reader.Read()))
{
var screenField = new VisitField();
if (!reader.IsDBNull(changeUserIDOrdinal))
                            {
                                screenField.ChangeUserID = reader.GetInt32(changeUserIDOrdinal);
                            }
                            if (!reader.IsDBNull(changeDateOrdinal))
                            {
                                screenField.ChangeDate = reader.GetDateTime(changeDateOrdinal);
                            }
                            screenFields.Add(screenField);
}

So it will iterate the data and fill the collection and bind the collection to Property in the ViewModel. But we are getting 40K records some times and we are getting connection time out all these things.


For the UI, I am having following properties for my Data Grid,

VirtualizingStackPanel.IsVirtualizing="True"
                         VirtualizingStackPanel.VirtualizationMode="Recycling

Is there any better way to improve the performance on DB side and WPF side ?


Thanks,
Kiran