RIA DomainService Query with parameters LightSwitch

Question

I am trying to use RIA services in LightSwitch but I get an error when the query in the DomainService has a parameter because the query is not imported into LightSwitch.

All the other queries are fine.

The error I get when attaching the data source in the Wizard window is

The parameter 'ID' in query 'AllRecordsbyId' is not a nullable type. This query will not be imported.

Answer 1

make the parameter nullable:

public IQueryable<CategoryTree> GetAllCategoryTree(int? AllRecordsbyId)
{
}