How does one go about determining the underlying table and column names for LLBLGen entities and fields/properties in a self servicing environment? I've seen several references to how to do this with adapter but was unable to find for Self Servicing.

I thought I had found the solution for fields in FieldInfoProviderSingleton.GetInstance().GetFieldInfo() but that seems to be not the right place.

But I am wanting this for both table names and column names.

It's easier in SelfServicing, as these info are in the EntityField class (SourceColumnName & SourceObjectName properties).

e.g.

var colName = myEntity.Fields["myField"].SourceColumnName;

Wow, fast reply!

Actually, I just found that after I posted!

Now, is it as easy to find a table name for an entity?? This I can't seem to find....

Aw, sorry!

ReadOnly Property SourceObjectName() As String Member of SD.LLBLGen.Pro.ORMSupportClasses.IFieldPersistenceInfo Summary: The name of the source object which holds SD.LLBLGen.Pro.ORMSupportClasses.IFieldPersistenceInfo.SourceColumnName. Can be a view or a table (or synonym of those). Used to generate SQL on the fly.