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;