Hello LLBLGen'ers.

Using the current release verion of GenPro, VS2005, remoting and adapter. I'm creating a new entity in the client code: new CategoryEntity(). Upon save, a trigger in the database creates a related record in CategoryDetail. The problem is, the refetch doesn't retrieve the related CategoryDetail record because, obviously, there was no Prefetch path. When I try to create a new CategoryEntity using:

        
public CatalogueCategoryEntity GetCatalogueCategory()
   {
       CategoryEntity ent = new CategoryEntity();
       IPrefetchPath2 prefetchPath = new PrefetchPath2((int)EntityType.CategoryEntity);
       prefetchPath.Add(CategoryEntity.PrefetchPathCategoryDetail);
       DataAccessAdapter adapter = new DataAccessAdapter();
       adapter.FetchEntity(ent, prefetchPath);
       return ent;
   }

and then I try to save, I get a database generated error. It appears that no prefetch graph can be generated on a non-existant entity.

I would like to Refetch a new entity with related collections. Is this doable?

Thanks.

Jeff

The code you showed tries to Fetch an Entity with no Primary Key using FetchEntity !!!

and then I try to save

Do you use this before saving the entity in the first place? (not possible)

The possible scenario is: 1- Save the Entity to the database. 2- if the Entity has an Identity(database generated) PK, passing true to the refetchAfterSave parameter of the SaveEntity(), this will update the entity with it's PK 3- Either to Fetch the Entity using its PK along with its related Entities using PrefetchPath. 4- Or Just Fetch The related Entities into a collection using FetchEntityCollection using a FK (The main Entity PK) as a filter. or by using something like this: EntityCollection orders = customer.Orders; adapter.FetchEntityCollection(orders, customer.GetRelationInfoOrders()); Where customer is your newly saved and refetched main Entity.

Walaa wrote:

The possible scenario is: 1- Save the Entity to the database. 2- if the Entity has an Identity(database generated) PK, passing true to the refetchAfterSave parameter of the SaveEntity(), this will update the entity with it's PK 3- Either to Fetch the Entity using its PK along with its related Entities using PrefetchPath.

Yes - this is what I'm doing now, however it's a two-step process. (1) perform adapter.EntitySave(newEntity) followed by (2) a fetch.

I was wondering if it could be done in a single step - by using Refetch. I guess not.

Jeff

Can't be done in a single step.

Just a quicky:

Walaa wrote:

1- Save the Entity to the database. 2- if the Entity has an Identity(database generated) PK, passing true to the refetchAfterSave parameter of the SaveEntity(), this will update the entity with it's PK

The PK is always set after the save, no refetch is needed.

LLBLGen'ers

I think I want a T-shirt that says I'm an LLBLGen'er.

(Seriously, you should look at http://www.cafepress.com/cp/info/sell/ and offer something. We did it for my kids' schools and it's no cost to set up. You just submit the logo and they print on demand.)