Hi, the "where" clause was supposed to work. Could you download the latest version from SVN and retry?
Pascal. On Sun, Apr 19, 2009 at 12:50, <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
