AssociateWith Filtering a Linq2Sql context with

Question

I am using Linq to SQL and I have a root table that hold languages used by my application

All other tables have a foreign key to this table.

My idea was to filter the context according to the language

So I used this code

DataLoadOptions options = new DataLoadOptions();

options.AssociateWith< Language>(l => l.ID == 1);

Why am I receiving this error?

Subquery is not supported on 'ID' of type '.....Language'.

Actually I want to load only one row from this table and all my context will go accordingly

Thank you for your help