pastebin

private async void LoadCustomersAsync() {  

    using(EmployeeDbEntities ent = new EmployeeDbEntities()) {  

        IdbConnection conn = (ent.Connection as EntityConnection).StoreConnection;  

        conn.Open();  

        using(DbCommand cmd = (DbCommand) conn.CreateCommand()) {  

            var query = from p in ent.EmployeeDetails  

            where p.Name.Contains("FN") && p.SurName.Contains("SN") && (p.Name + p.SurName).Length > 3  

            select p;  

            //Convert linq query to SQL statement for CommandText  

            string str = ((ObjectQuery) query).ToTraceString();  

            cmd.CommandText = str;  

            // Invoke Async flavor of ExecuteReader  

            var task = await cmd.ExecuteReaderAsync();  

            //translate retieved data to entity customer  

            var cust1 = await Task.Run(  

                () => ent.Translate < EmployeeDetails > (task).ToList < EmployeeDetails > ());  

            employeesDataGrid.ItemsSource = cust1;  

        }  

    }  

}