Hi all! I need help.

Some my entity tables has a structure like ths:

ID - uniqueidentifier not null primary key, <some field1> <some field2> ... <some fieldN> RecordStatus int not null default(0).

RecordStatus is of two possible values: 0 - active, 1 - removed.

I need realize (db) extraction condition [RecordStatus = 0]. I.e. instantiate only active entities (related entities too).

Environment: LLBLGen 2.6 Pro, C#/.Net 3.5, MSSQL 2005

Hi

You need to explore the use of Filtering to get the entities that you want, and PreFetch Paths to get their related entities

Matt

It seems I described the situation incompletely.

I know how I can get the result using API.

But I want to get such behaviour in generated code. I need advice - how to get this by designer or using template engine.

Please check this: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=15311

Understood. Thanks.