如何获取 EF 5 中所有实体的列表? [英] how to get a list of all entities in EF 5?

问题描述

我正在构建一个 MVC 4 应用程序.我的视图有一个下拉列表，需要显示所有使用的表(实体)..

我该怎么做?我首先在配置中使用 EF 5 代码.

任何帮助将不胜感激.

谢谢

解决方案

此代码将为您获取它们，当然，已导入 EDM 的那些不一定是数据存储中的所有表.

>

var tableNames = context.MetadataWorkspace.GetItems(DataSpace.SSpace).Select(t => t.Name).ToList();

代码优先:

使用 System.Data.Metadata.Edm;使用 System.Data.Objects;使用 System.Data.Entity.Infrastructure;...使用 (dbcontext context = new TestContext()){ObjectContext objContext = ((IObjectContextAdapter)context).ObjectContext;MetadataWorkspace 工作空间 = objContext.MetadataWorkspace;IEnumerable表 = workspace.GetItems(DataSpace.SSpace);}

I am building an MVC 4 app. I have view that has a dropdown that needs to display all the tables (entities) used..

How can I do that? I am using EF 5 code first with configurations.

Any help would be appreciated.

Thanks

解决方案

This code will get them for you, of course the ones that has been imported to your EDM which necessarily is not all the tables in your data store.

var tableNames = context.MetadataWorkspace.GetItems(DataSpace.SSpace)
                        .Select(t => t.Name)
                        .ToList();

For code first:

using System.Data.Metadata.Edm;
using System.Data.Objects;
using System.Data.Entity.Infrastructure;

...

using (dbcontext context = new TestContext())
{
   ObjectContext objContext = ((IObjectContextAdapter)context).ObjectContext;
   MetadataWorkspace workspace = objContext.MetadataWorkspace;
   IEnumerable<EntityType> tables = workspace.GetItems<EntityType>(DataSpace.SSpace);

}

这篇关于如何获取 EF 5 中所有实体的列表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！