How get database table name with schema name from entity programmatically

Question

I'm trying to get the SQL table name for the entity. When I work with the MetadataWorkspace queries I get lots of information from the object or the storage space. But schema name and table name are not present.

I try query all the EntityType objects for CSpace and SSpace and I can see both listed correctly but I can't figure out how to get SSpace from CSpace.

So say I have a type in the object model called User - how do I find the tablename with schema name (tkp.User) in the database?

Is there any way to do this?

score 7 · Accepted Answer · edited May 23 '17 at 12:09

There is no perfect answer to this, but this should work...

var ssSpaceSet = objectContext.MetadataWorkspace
    .GetItems<EntityContainer>(DataSpace.SSpace).First()
    .BaseEntitySets
    .First(meta => meta.ElementType.Name == "YourEntityName");

If you look up in debugger, Table property should have the real table name.

You'd need to use reflection in the last part.
Good news is it should transparently work with EF6 too (as it has a similar base class)

(it's similar for schema, should be in there also - this is the space for Db/SQL mapped names, facets etc.)

See this post of mine with many details
Get Model schema to programmatically create database using a provider that doesn't support CreateDatabase

Get Model schema to programmatically create database using a provider that doesn't support CreateDatabase
How I can read EF DbContext metadata programmatically?
How check by unit test that properties mark as computed in ORM model?
Programmatic data transformation in EF5 Code First migration
Entity Framework MigrationSqlGenerator for SQLite
http://entityframework.codeplex.com/
Entity Framework - Get Table name from the Entity
ef code first: get entity table name without dataannotations
Get Database Table Name from Entity Framework MetaData
http://www.codeproject.com/Articles/350135/Entity-Framework-Get-mapped-table-name-from-an-ent

Thank you very much. I found out schema name by Schema property. — PaulP, Apr 11 '13 at 11:31
@evc what issue do you have? this is a rough stroke solution and table, schema all is inside, you can get the ObjectContext from the DbContext directly, PaulP mentioned schema property etc. And in EF 6.* (new ones) you have even better ways http://stackoverflow.com/a/18964974/417747 or [here](http://romiller.com/2014/04/08/ef6-1-mapping-between-types-tables/) — NSGaga-mostly-inactive, Aug 04 '14 at 22:36

How get database table name with schema name from entity programmatically

1 Answers1