EF获取数据库表名和列名

1|0EF获取数据库表名和列名

新建

模板

小书匠

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. } 

    ---

__EOF__

本文作者：明明.如月
本文链接：https://www.cnblogs.com/mmry/p/7159148.html
关于博主：评论和私信会在第一时间回复。或者直接私信我。
版权声明：本博客所有文章除特别声明外，均采用 BY-NC-SA 许可协议。转载请注明出处！
声援博主：如果您觉得文章对您有帮助，可以点击文章右下角【推荐】一下。您的鼓励是博主的最大动力！