In a SQL transaction such behaviour would be right. But, this is probably a bug. How Linq to Sql work on such a query?
Giacomo On Tue, Apr 21, 2009 at 3:07 PM, <[email protected]> wrote: > > Hi, > > The query below works ok in DBlinq-0.18 but in Trunk the datetime in > the where clause stays the same for each attempt. > > while (true) { > var customers = from customer in customerTable > where customer.Inserted < DateTime.Now > select customer; > > foreach (var customer in customers) { > Console.WriteLine(customer.Id + " " + > customer.Username); > } > Thread.Sleep(3000); > } > > Regards, > > 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 -~----------~----~----~----~------~----~------~--~---
