I'm testing out DBLinq-0.18 and DBLinq from SVN Trunk with MySQL and Postgresql. I'm only using a very simple query but on both database DBLinq is not generating a Where clause. I have confirmed this by turning on statement logging on Postgresql to check exactly what request DBLinq is sending.

My Linq query is:

MyDB db = new MyDB(new NpgsqlConnection("Database=database;Host=localhost;User Id=postgres;Password=password"));

var customers = from customer in db.Customers
                where customer.CustomerUserName == "test"
                select customer;

The query works ok but the SQL generated by DBLinq is of the form:

select customerusername, customerpassword .... from public.customers

There is no Where clause which means DBLinq must be pulling the whole table down before running the Linq query.

Has anyone had any experience with DBLinq and know what I could be doing wrong?