GridLinqDataBinding problem

[Matthew]

Hi all,

I m trying to fill my radgrid's datasource by using linq to sql. Till now i successfully done it when i used only one table in queries. But when i wanted to join two tables i failed. Here is the method i used for data binding.

public RadGridSurveyAnswerPointsModel ViewSurveyAnswerPoints(int startIndex, int maximumRows,
string sortExpressions, string filterExpressions)
{

RadGridSurveyAnswerPointsModel model = new RadGridSurveyAnswerPointsModel();

IQueryable q = (from x in Context.cc_SurveyPoint

          join y in Context.CC_SurveyPointMain on x.SurveyMainPointID equals y.ID

          orderby x.Code

          select new DenemeClass

          {

               Id = x.ID,

               Code = x.Code,

               Description = x.Description,

               Sequence = x.Sequence,

               isActive = x.ISActive,

               IconId = x.IconId,

               Point = x.Point,

               SurveyMainPointId = y.Code

         });

            GridLinqBindingData data = RadGrid.GetBindingData(q, startIndex, maximumRows,
sortExpressions, filterExpressions);

            model.AnswerPointsList = data.Data.OfType<DenemeClass>().ToList();

            model.Count = data.Count;

            return model;

}

public class DenemeClass
    {
        public Guid Id
        {
            get;
            set;
        }

        public string SurveyMainPointId
        {
            get;
            set;
        }

        public string Code
        {
            get;
            set;
        }

        public string Description
        {
            get;
            set;
        }

        public int Point
        {
            get;
            set;
        }

        public int? IconId
        {
            get;
            set;
        }

        public int? Sequence
        {
            get;
            set;
        }

        public bool isActive
        {
            get;
            set;
        }

    }

It is compiled and at run time i get this error : DenemeClass' is not a valid metadata type for type filtering operations. Type filtering is only valid on entity types and complex types. 

It may not be related with radgrid but i guess you good people could help me. Thanks.

[Matthew]

Any solution ?

[Andrey]

Hi,

Could you paste your complete page source code, so all the people who want to help you have better understanding of your case.

Basically the code you have provided is looking OK, but we need to sure that everything else is OK before making suggestions what would be causing the issue.

All the best,
Andrey
the Telerik team

[Matthew]

I know this problem has no relation with telerik. But i m sure telerik team can handle it easily. Sorry for the disturbation.
 
Shortly what i am looking for is,

GridLinqBindingData data = RadGrid.GetBindingData(q, startIndex, maximumRows, 
sortExpressions, filterExpressions); 

how to cast data.Data to a custom class or list.

If i want to cast data.Data to an entity class there is no error :

GridLinqBindingData data = RadGrid.GetBindingData(q, startIndex, maximumRows, 
sortExpressions, filterExpressions);

            model.AnswerPointsList = data.Data.OfType<Context.cc_SurveyPoint 
>().ToList();



Above it works. But my example is a complex type(for the reason of join operation between two tables). So when i want to cast it to a custom class(DenemeClass) it gives the error : DenemeClass' is not a valid metadata type for type filtering operations. Type filtering is only valid on entity types and complex types. 

[Matthew]

any advice ?

[Matthew]

I solved it on my own.

To get rid of casting data to an entity type it should be ienumerable. data.Data does not have AsEnumerable() function but AsParallel() did the same for me.

model.AnswerPointsList = data.Data.AsParallel().OfType<DenemeClass>().ToList();

Finally, it works.