SqlCacheDependency Revisisted

Posts   
 
    
Brandt
User
Posts: 142
Joined: 04-Apr-2007
# Posted on: 13-Mar-2009 17:01:36   

I have read through the posts about SqlCacheDependency and LLBLGEN and all of them seem to target query dependencies and not table dependencies. Since I am pulling an entire aggregate root from the database in a single PrefetchPath2 object, I would like to be able to extract the actual table names targeted by that Prefetch Path. That way i can use them to create an AggregateCacheDependency object make of the individual table dependency objects. Can it be done and what is the best way?

Brandt
User
Posts: 142
Joined: 04-Apr-2007
# Posted on: 13-Mar-2009 20:36:45   

I also want to add that the tables are not under the schema dbo and there isn't is a way to guess the schema name. So I can't infer the table name from the DestinationEntityType in the prefetch. I would need the actual table name used internally by llblgen.

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 16-Mar-2009 08:14:40   

In Adapter, the info is stored in the FieldPersistenceInfo object of an EntityField

Please check the following thread to know how to get the FieldPersistenceInfo object of an EntityField2 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=12530