propertyProjectors

Posts   
 
    
shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 08-Sep-2010 12:15:51   

LLBLGEN 3.0 .net Framework 2.0

I am trying to fill the data table from all the referencing tables mentiond in prefetchPathreceipt but in datatable I get only receipt table that is because prefetch path executes seperate queries for each of prefetchPathreceipt mentioned. How do i get data from all referenced tables into datatable ?

public static DataTable returnreceptbyprimarykeyid(decimal primarykeyid) { var DataTablereceipt = new DataTable(); var adapterreceipt = new DataAccessAdapter(); var receipt = new EntityCollection<ReceiptEntity>(new ReceiptEntityFactory()); var bucketreceipt = new RelationPredicateBucket(); bucketreceipt.PredicateExpression.Add(ReceiptFields.Flag == StandardFlag.recordvalidflag); bucketreceipt.PredicateExpression.Add(ReceiptFields.ReceiptId == primarykeyid); var prefetchPathreceipt = new PrefetchPath2((int)EntityType.ReceiptEntity); prefetchPathreceipt.Add(ReceiptEntity.PrefetchPathAffiliateclub); prefetchPathreceipt.Add(ReceiptEntity.PrefetchPathBank); prefetchPathreceipt.Add(ReceiptEntity.PrefetchPathCorporate); prefetchPathreceipt.Add(ReceiptEntity.PrefetchPathEmployee); prefetchPathreceipt.Add(ReceiptEntity.PrefetchPathLedger); prefetchPathreceipt.Add(ReceiptEntity.PrefetchPathMember); prefetchPathreceipt.Add(ReceiptEntity.PrefetchPathTransactionmode); adapterreceipt.FetchEntityCollection(receipt, bucketreceipt, 0, null, null); var receiptView = receipt.DefaultView; var propertyProjectors = EntityFields2.ConvertToProjectors(receipt.EntityFactoryToUse.CreateFields()); receiptView.CreateProjection(propertyProjectors, DataTablereceipt); return DataTablereceipt;

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 08-Sep-2010 12:44:36   

Do you want all data in a flat way in just one dataTable, or do you want to project each entity into a DataTable and all within a DataSet?

shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 08-Sep-2010 16:13:32   

Walaa wrote:

Do you want all data in a flat way in just one dataTable, or do you want to project each entity into a DataTable and all within a DataSet?

Hi Walaa Preferably all data in a flat way in just one dataTable but request you give an idea to all data in a flat way in just one dataTable also so that I dont have to come back with same question on forum at later date

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 08-Sep-2010 16:15:38   

Why don't you use a TypedList or a DynamicList to fetch all related data in one dataTable?

shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 08-Sep-2010 16:58:07   

Walaa wrote:

Why don't you use a TypedList or a DynamicList to fetch all related data in one dataTable?

Thanks Walaa am familiar with both TypedList and DynamicList. Will do