|
|
omar
User
Location:
Salmiya, Kuwait
Joined on:
15-Oct-2004 15:44:57
Posted:
569 posts
|
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
|
|
|
Otis
LLBLGen Pro Team
Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37803 posts
|
In selfservicing, it's in the field, in adapter, you need to obtain the fieldpersistence info, what do you use, adapter or selfservicing?
|
|
|
omar
User
Location:
Salmiya, Kuwait
Joined on:
15-Oct-2004 15:44:57
Posted:
569 posts
|
I am using Adapter (ofcourse  )... I will check this fieldpersistence object but any tips are always welcomed
|
|
|
omar
User
Location:
Salmiya, Kuwait
Joined on:
15-Oct-2004 15:44:57
Posted:
569 posts
|
I found the following in DADBSpecific
| Code: |
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:
| 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
| Code: |
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" ??
|
|
|
daelmo
Support Team
Location:
Guatemala City
Joined on:
28-Nov-2005 23:35:24
Posted:
8098 posts
|
|
|
omar
User
Location:
Salmiya, Kuwait
Joined on:
15-Oct-2004 15:44:57
Posted:
569 posts
|
Right on the money.. works like a charm... Thank you daelmo
|
|
|
mohamed
User
Location:
Salmia, kuwait
Joined on:
10-Mar-2008 19:55:21
Posted:
136 posts
|
Hello,
Is it possible to get the database Table name of an Entity2 ?
Like CustomerEntity ==> Customer <==this is table name from Database
|
|
|
Walaa
Support Team
Location:
Joined on:
21-Aug-2005 16:03:48
Posted:
14569 posts
|
Exactly the same as above but using SourceObjectName property instead of SourceColumnName.
|
|
|
mohamed
User
Location:
Salmia, kuwait
Joined on:
10-Mar-2008 19:55:21
Posted:
136 posts
|
Walaa.. thanks for reply, but this is the table name of field
what i want, Passing entity2 and get its table name
|
|
|
daelmo
Support Team
Location:
Guatemala City
Joined on:
28-Nov-2005 23:35:24
Posted:
8098 posts
|
Here is an example:
| Code: |
namespace <YourRootNamespace>.DatabaseSpecific
{
public partial class DataAccessAdapter
{
public string GetSourceTableName(IEntity2 entity)
{
return this.GetFieldPersistenceInfos(entity)[0].SourceObjectName;
}
}
} |
|
|
|
Walaa
Support Team
Location:
Joined on:
21-Aug-2005 16:03:48
Posted:
14569 posts
|
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.
|
|
|
omar
User
Location:
Salmiya, Kuwait
Joined on:
15-Oct-2004 15:44:57
Posted:
569 posts
|
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
|
|
|
Walaa
Support Team
Location:
Joined on:
21-Aug-2005 16:03:48
Posted:
14569 posts
|
|
|
omar
User
Location:
Salmiya, Kuwait
Joined on:
15-Oct-2004 15:44:57
Posted:
569 posts
|
Thank Walaa and thank you all for the great input..this forum continues to be as useful as ever
|
|
|
AlbertK
User
Location:
Joined on:
23-Dec-2009 17:51:37
Posted:
44 posts
|
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.
|
|
|
Walaa
Support Team
Location:
Joined on:
21-Aug-2005 16:03:48
Posted:
14569 posts
|
Please open a new thread for your question.
(hint: check forum guidelines)
Thanks.
|
|
|
|