custom filtering with objectdatasource in .NET 4.0

[Datamex]

Hi,

I want to implement custom filtering in my radGrid, but I don't get it to work right now. What I'm trying to do is the following:

I have radGrid and the datasource of the grid is an objectdatasource. In the selecting event of the objectdatasource i add my filterexpression and sortexpression. In the function in my businesslogics, i have the filterexpression, sortexpression, startindex and maximumrows. The filterexpression is coming to the function properly, but i can't get it to work with my entitymodel. I've tried enableLinqExpression="True" and enableLinqExpression="False" but with both options it doesn't work.This is the code of the function:

 

 

public static IQueryable<vw_TrainingCompanyLocations> GetTrainingCompanyLocations(string filterExpression, string sortExpression, int maximumRows, int startRowIndex)
    {
      KolipeEntities db = new KolipeEntities();

      IQueryable<vw_TrainingCompanyLocations> data;

      if (!string.IsNullOrEmpty(filterExpression))
        data = db.vw_TrainingCompanyLocations.Where(filterExpression);
      else
        data = db.vw_TrainingCompanyLocations;

      return data;
    }

 

 Do you have any idea how to get this to work?

[Ben]

I have the same issue.

It seems that 'EnableLinqExpressions' doesn't work right with ObjectDataSource objects.  When I get a filter expression, it's always in SQL format regardless of that property being set to 'true' or 'false'.

[Tsvetina]

Hello Datamex,

You can take a look at the project attached to the following forum post, which demonstrates how to achieve the desired functionality. I hope it helps.
Filtering with linq through an ObjectDataSource

Greetings,
Tsvetina
the Telerik team