O sorry i miss that part sorry.

Sory for my bad english

As i see from yours solutions i see that if ID jumps (is not sequence) than that query will not work.

Hear is my solution:

SELECT [t0].*

FROM [TBLYourTable] AS [t0], [TBLYourTable] AS...

Yes like i sead before i totaly agree with you.

Sory for my bad english.

I'm more developer then database fan and i recently read a book "Architecting Microsoft® .NET Solutions for the Enterprise" and i must refer to this sentence in a book:

"If you...

Try use Compile queryis in Linq you will get beter performance there, because you callin that code more than one time...

Code using LINQ…

public partial class FleetDataContext

{

public...