Question
Simple: How do I get the mapped table name from a DbEntityEntry object? I'm inside a class that extends DbContext. I've seen examples for ObjectContext but doesn't apply to CF.
Thanks.
Accepted Answer
As stated in another answer, the table name can be obtained using the IObjectContextAdapter
private string GetTableName(DbEntityEntry ent)
{
ObjectContext objectContext = ((IObjectContextAdapter) this).ObjectContext;
Type entityType = ent.Entity.GetType();
if (entityType.BaseType != null && entityType.Namespace == "System.Data.Entity.DynamicProxies")
entityType = entityType.BaseType;
string entityTypeName = entityType.Name;
EntityContainer container =
objectContext.MetadataWorkspace.GetEntityContainer(objectContext.DefaultContainerName, DataSpace.CSpace);
string entitySetName = (from meta in container.BaseEntitySets
where meta.ElementType.Name == entityTypeName
select meta.Name).First();
return entitySetName;
}
The above code also tests for proxies. Hope this helps someone else who comes to this link as I assume the original poster solved this a long time ago.
Popular Answer
I found a cleaner way at msdn to get rid of the proxy name.
private string GetTableName(DbEntityEntry ent)
{
return ObjectContext.GetObjectType(entry.Entity.GetType()).Name;
}
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
