Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var count = GetEntitySetCount(myObjectContext.MetadataWorkspace);
- public static int GetEntitySetCount(MetadataWorkspace workspace)
- {
- var count = 0;
- // Get a collection of the entity containers from storage space.
- var containers = workspace.GetItems<EntityContainer>(DataSpace.SSpace);
- foreach(var container in containers)
- {
- //Console.WriteLine("EntityContainer Name: {0} ",
- // container.Name);
- foreach(var baseSet in container.BaseEntitySets)
- {
- if(baseSet is EntitySet)
- {
- count++;
- //Console.WriteLine(
- // " EntitySet Name: {0} , EntityType Name: {1} ",
- // baseSet.Name, baseSet.ElementType.FullName);
- }
- }
- }
- return count;
- }
- myObjectContext.ExecuteStoreQuery<int>(
- "SELECT COUNT(*) from information_schema.tables WHERE table_type = 'base table'");
- var connection = ((EntityConnection)myObjectContext.Connection).StoreConnection as SqlConnection;
- var cmd = new SqlCommand("SELECT COUNT(*) from information_schema.tables WHERE table_type = 'base table'", connection);
- connection.Open();
- var count = (int)cmd.ExecuteScalar();
- connection.Close();
Add Comment
Please, Sign In to add comment