Hi,

I'm new to LLBLGen (loving it). I searched the forum, but I can't find any information on this. I need to know if you can retrieve a set of enumerable entities with an iterator that has a live connection to the database. Kind of like a datareader, so that you can read results of a query, but instead of returning rows, it would return entities. If this doesn't exist, is there an easy way of implementing it?

The reason is the underlying data is very large, and I need to run queries in a separate thread and have them report on their status.

Thanks all,

btw, LLBLGen is my hero

Whoops, Forgot to list some other information Using LLBLGen Version 2.0.0.0 Final with SQL Server 2005

Do you mean an EntityCollection? (not just a single entity)

yes you can. depending on whether you're using the adapter or SS model will determine the exact syntax. search the help file for EntityCollection.

Either use paging when fetching entities, or use a datareader fetch, so you then get a datareader returned when you pass in a set of fields and for example a filter. The syntax differs a bit between selfservicing and adapter, though there's enough info on them in the docs: Using the generated code -> Adapter/SelfServicing -> Fetching datareaders and projections

btw, LLBLGen is my hero