Is there a way to get at runtime the name of the db field mapped on the entity field ??

EDIT:

CustomerEntity e = new CustomerEntity();

e.Fields[0].Name <== this gives the entity's field name NOT the name of the source DB field

In selfservicing, it's in the field, in adapter, you need to obtain the fieldpersistence info, what do you use, adapter or selfservicing?

I am using Adapter (ofcourse )... I will check this fieldpersistence object but any tips are always welcomed

I found the following in DADBSpecific

    internal class PersistenceInfoProviderCore : PersistenceInfoProviderBase
    {
        /// <summary>Initializes a new instance of the <see cref="PersistenceInfoProviderCore"/> class.</summary>
        internal PersistenceInfoProviderCore()
        {
            Init();
        }

        /// <summary>Method which initializes the internal datastores with the structure of hierarchical types.</summary>
        private void Init()
        {
            base.InitClass((1 + 0));
            InitUidictionaryEntityMappings();

        }


        /// <summary>Inits UidictionaryEntity's mappings</summary>
        private void InitUidictionaryEntityMappings()
        {
            base.AddElementMapping( "UidictionaryEntity", "winUI", @"Default", "UIDictionary", 3 );
            base.AddElementFieldMapping( "UidictionaryEntity", "SourceFormName1", "SourceFormName", false, (int)OleDbType.VarWChar, 75, 0, 0, false, "", null, typeof(System.String), 0 );
            base.AddElementFieldMapping( "UidictionaryEntity", "EntityName1", "EntityName", false, (int)OleDbType.VarWChar, 75, 0, 0, false, "", null, typeof(System.String), 1 );
            base.AddElementFieldMapping( "UidictionaryEntity", "TargetFormName1", "TargetFormName", true, (int)OleDbType.VarWChar, 75, 0, 0, false, "", null, typeof(System.String), 2 );
        }

    }

In the LLBL project file I changed the property name of the field sourceFormName to sourceFormName1 so to track where to find the mapping

Is it true to assume that in the following code:

base.AddElementFieldMapping( "UidictionaryEntity", "SourceFormName1", "SourceFormName", false, (int)OleDbType.VarWChar, 75, 0, 0, false, "", null, typeof(System.String), 0 );

"SourceFormName1" is the entity field's property name and "SourceFormName" is the name of the DB table field mapped on that entity field?

If that is truly the case, how can I obtain this info? If I try the following

var x = FieldInfoProviderSingleton.GetInstance().GetFieldInfo("UidictionaryEntity", (int)fieldIndex);

(where field index is the index of the field I need) and inspect the properties of x, which property will give me "SourceFormName" instead of "SourceFormName1" ??

Here is the snippet to figure out the source column name for a given IEntityField2: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=12530&StartAtMessage=0&#69571

Right on the money.. works like a charm... Thank you daelmo

Hello,

Is it possible to get the database Table name of an Entity2 ?

Like CustomerEntity ==> Customer <==this is table name from Database

Exactly the same as above but using SourceObjectName property instead of SourceColumnName.

Walaa.. thanks for reply, but this is the table name of field

what i want, Passing entity2 and get its table name

Here is an example:

namespace <YourRootNamespace>.DatabaseSpecific
{
    public partial class DataAccessAdapter
    {   
    
        public string GetSourceTableName(IEntity2 entity)
        {
            return this.GetFieldPersistenceInfos(entity)[0].SourceObjectName;
        }       

    }
}

To elaborate more on this: An entity can have fields mapped to more tha one database table, as in the case of inheritance, that's why the Field or FieldPersistenceInfo is the structure/class holding the mapped table name.

so Walaa.. ignoring the inheritance angle and assuming all my entities are mapped one-to-one to tables/views, I can safely assume all the entity fields have the same DB table mapping

Sure.

Thank Walaa and thank you all for the great input..this forum continues to be as useful as ever

I have a question related to this thread. I have entity that is a subtype. How can I retrieve source table name at run time? GetFieldPersistenceInfos() returns empty array. I see generated code calling this.AddElementMapping() on the entity that is a subtype, I just don't know how to get to the table name. I'm using version 3.1.

Thank you.

Please open a new thread for your question. (hint: check forum guidelines)

Thanks.