EntityDataSource optional where parameter

You can achieve it like this : Where="it.ID=@CompanyID or @CompanyID is NULL" I also tried "or @CompanyID== NULL" , but that didn't work Another way to is to use onSelecting event of the entity data source and create the where clause there