This is a migrated thread and some comments may be shown as answers.

Contains in LINQ expression generates error

2 Answers 63 Views

LINQ (LINQ specific questions)

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

jgulin asked on 24 May 2010, 03:38 PM

I have wrote this code and when I run it it generates this error:

BackendQuery = '(result).BackendQuery' threw an exception of type 'Telerik.OpenAccess.OpenAccessException'

                    var dates = new List<string>();         
                         
                        foreach (RadDate rD in dTC)         
                        {         
                            dates.Add(rD.Date.ToString());         
                        }         
                                 
                        var result = from a in scope.Extent<Proj>() where dates.Contains(a.ETADate)          
                                     orderby a.ETADate descending, a.ArriveTime descending         
                                     select a;        

Any ideas why this is not working?

2 Answers, 1 is accepted

answered on 26 May 2010, 08:45 AM

solved:

                    var dates = new List<DateTime>();         
                         
                        foreach (RadDate rD in dTC)         
                        {         
                            dates.Add(Convert.ToDateTime(rD.Date));         
                        }         
                     
                        var result = from a in scope.Extent<Proj>()         
                                     where dates.Contains((DateTime)a.ETADate)         
                                     orderby a.ETADate descending, a.ArriveTime descending         
                                     select a;         

works!