EF获取数据库表名和列名

EF获取数据库表名和列名

新建
模板
小书匠
  1.  
  2. /// <summary> 
  3. /// 通过当前DBContext上下文获取对应数据库中所有得表 
  4. /// </summary> 
  5. /// <returns></returns> 
  6. public List<string> GetTableNames() 
  7. { 
  8. var TableNames = new List<string>(); 
  9. var metadata = ((IObjectContextAdapter) this).ObjectContext.MetadataWorkspace; 
  10. var tables = metadata.GetItemCollection(DataSpace.SSpace).GetItems<EntityContainer>().Single() 
  11. .BaseEntitySets.OfType<EntitySet>() 
  12. .Where(s => !s.MetadataProperties.Contains("Type") || 
  13. s.MetadataProperties["Type"].ToString() == "Tables"); 
  14. foreach (var table in tables) 
  15. { 
  16. var tableName = table.MetadataProperties.Contains("Table") && 
  17. table.MetadataProperties["Table"].Value != null 
  18. ? table.MetadataProperties["Table"].Value.ToString() 
  19. : table.Name; 
  20. var tableSchema = table.MetadataProperties["Schema"].Value.ToString(); 
  21. TableNames.Add(tableSchema + "." + tableName); 
  22. } 
  23. return TableNames; 
  24. } 
  25. public List<string> GetColumnNamesByTable(string tableName) 
  26. { 
  27. string name = tableName.Split('.')[1]; 
  28. string schema = tableName.Split('.')[0]; 
  29. var ColumnNames = new List<string>(); 
  30. var metadata = ((IObjectContextAdapter)this).ObjectContext.MetadataWorkspace; 
  31. var table = metadata.GetItemCollection(DataSpace.SSpace).GetItems<EntityContainer>().Single().BaseEntitySets.OfType<EntitySet>().Where(s=>!s.MetadataProperties.Contains("Type") || s.MetadataProperties["Type"].ToString() == "Tables").FirstOrDefault(t => t.Table==name&&t.Schema==schema); 
  32.  
  33. foreach (var member in table.ElementType.Members) 
  34. { 
  35. var ColumnName = member.Name; 
  36. ColumnNames.Add(ColumnName); 
  37. } 
  38. return ColumnNames; 
  39. } 
posted @ 2017-07-13 10:33  明明.如月  阅读(3692)  评论(0)  编辑  收藏  举报