Hi All,
I'm testing out DBLinq-0.18 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 returns the correct 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?
Thanks,
Greyman.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---
