Hello,

Is it possible to get the database column name of an EntityField2?

Thanks

Hi fcastell,

1. Extend _DataAccessAdapter _class via a partial class (or derive a class from DataAccessAdapter), create a method which receive a IEntityField2, then retrieve the _IFieldPersistenceInfo _and return the whole object or just the column name.

using SD.LLBLGen.Pro.ORMSupportClasses;

namespace <yourDatabaseSpecificNamespace>
{   
    // I'm using a partial class, but you can create an inherited class
    public partial class DataAccessAdapter
    {
             public string GetSourceColumnName(IEntityField2 field)
             {
                 // access the protected method to retrieve the field's info
                 IFieldPersistenceInfo fieldInfo = GetFieldPersistenceInfo(field);

                // return the name of the source column
                return fieldInfo.SourceColumnName;
            }       
    }
}

1. Use the method you just created and pass a _IEntityField2 _to it. You can access the fields via <YourNamespace>.HelperClasses.<SomeEntity>Fields.<SomeField>.

DataAccessAdapter adapter = new DataAccessAdapter();
string someColumName = adapter.GetSourceColumnName(CustomerFields.CompanyName); 

Thanks David for your answer, it is exactly what I need.

Fabien

Dim fieldInfo As IFieldPersistenceInfo = SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.GetFieldPersistenceInfo(oDataType)

when i try the above it says the method is protected?

Yes this method is protected.

// I'm using a partial class, but you can create an inherited class public partial class DataAccessAdapter { public string GetSourceColumnName(IEntityField2 field) { // access the protected method to retrieve the field's info IFieldPersistenceInfo fieldInfo = GetFieldPersistenceInfo(field);

            // return the name of the source column
            return fieldInfo.SourceColumnName;
        }       
}

You should expose it by either wrappng it with another method as shown in the above example, or by inheriting from the DataAccessAdapter.

converted the above example yto vb but getting error

' I'm using a partial class, but you can create an inherited class
Partial Public Class DataAccessAdapter
    Public Function GetFieldInfo(ByVal field As IEntityField2) As String
        ' access the protected method to retrieve the field's info
        Dim fieldInfo As IFieldPersistenceInfo = GetFieldPersistenceInfo(field)***Error Name undeclared 

        ' return the name of the source column
        Return fieldInfo.SourceColumnName
    End Function
End Class

You need to inherit from DataAccessAdapter rather than extend it with a partial class.

Partial Public Class DataAccessAdapterExtend
    Inherits DataAccessAdapter

    Public Function GetFieldInfo(ByVal field As IEntityField2) As String
        ' access the protected method to retrieve the field's info
        Dim fieldInfo As IFieldPersistenceInfo = GetFieldPersistenceInfo(field)

        ' return the name of the source column
        Return fieldInfo.SourceColumnName
    End Function
End Class

Matt