I have a need to be able to build a Sql command which requires the full table name given an entity type but I can't seem to find an obvious way of accessing this.

PersistenceInfoProviderSingleton looked promising but is marked internal. If I use reflection to access this, can I get a table name from it?

Cheers Simon

PS I need to be able to clear a table and reset its identity and was thinking something along the lines of

LLCoolJHelper.ExecuteSql(adapter, string.Format("DBCC CHECKIDENT ([{0}], NORESEED);"), xxx);

Which runtime library version are you using? And which template set are you using?

Walaa wrote:

Which runtime library version are you using? And which template set are you using?

It varies! (Just noticed that a library of mine was linked to a previous LLBLGen runtime version - fixed that and now find a whole load of interface signatures have changed so I'll have to fix them up )

SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll v3.5.0.0 is the one I want which is the latest for .NET 4 I believe?

roperty is caled SourceObjectName

In SelfServicing: you can find it in EntityField.

var tableName = OrderDetailFields.ProductId.SourceObjectName;

In Adapter:

IFieldPersistenceInfo info = adapter.GetFieldPersistenceInfo(OrderDetailFields.ProductId);
var tableName = info.SourceObjectName;

Sorry, should have said Adapter (but might change back to SelfServicing yet!)

Anyway, that method is protected. Argggh! You guys are hiding everything away from me!

What method exactly? It might be available through the interfaces (IEntityCore, IEntity2), as we moved methods to the interfaces to clean up the public interface of entities.

GetFieldPersistenceInfo on DataAccessAdapterBase - its protected.

This seems to work:

    public partial class DataAccessAdapter
    {
        public string GetDatabaseTableName<T>() where T: EntityBase2
        {
            var firstField = GetFieldPersistenceInfos(typeof(T).Name)[0];

            return GetDbSpecificCreatorInstance().CreateObjectName(firstField);
        }
    }

Took we a while to work it out though!