如何在 Visual Studio 2010 中手动编辑 ADO.NET 中的表映射？
我似乎无法找到我认为简单的问题的答案。我刚刚创建了一个实体模型，我想手动设置表和列的名称。我可以看到“映射详细信息”，但如何编辑或添加它们？
I can't seem to find the answer to what I think is an easy question. I have a Entity model I just created and I want to set the name of the table and the columns by hand. I can see the "mapping details," but how do I edit them or add to them?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
看来答案是，如果不使用 XML 就无法做到这一点。您可以使用 Entity Framework Power Pack 自定义生成模板，但没有用于编辑映射的直接 GUI。
It appears the answer is, you can't without going into the XML. You can use the Entity Framework Power Pack to customize the templates for generation, but there's no direct GUI for editing the mappings.
我打开 edmx 文件所在的文件夹，查看其中的所有文件，并找到可能的解决方案。
使用Notepad++编辑然后会显示xml文件内容，或者您可以直接通过notepad.exe打开Edmx文件您将在文件的顶部看到类似这样的内容：
我想要做的是删除
DataColumn4，我首先在 VS 中打开 Edmx 文件直接在VS UI中点击列名并按键盘上的Delete键，你会发现在映射详细信息窗口中，DataColumn4属性的右侧将为空，但在左侧，DataColumn4仍然存在。然后，使用步骤 1 打开 edmx 文件，删除步骤 2 中的属性并保存文件。
删除-->重启Visual Studio，再次打开edmx你会发现
DataColumn4消失了，我尝试连接到数据库并操作数据，工作正常。I open the folder where edmx file in, look into all files in it, and find a possible solution.
Edit with Notepad++then the xml file content will show, or you can directly open the Edmx file by notepad.exeYou'll see something like this on the top part of the file:
What I want to do is remove
DataColumn4, I first open the Edmx File in VS and directly click on the column name in the VS UI and press Delete on the keyboard, and you'll find that in the Mapping Detail Window, the right side ofDataColumn4property will be empty, but in the left side theDataColumn4still exist.Then, Open the edmx file using Step 1, remove the property in the Step 2 and save the file.
Remove--> <Property Name="DataColumn4" Type="nvarchar" MaxLength="255" />Restart visual studio, and open the edmx again you'll find
DataColumn4disappear, and I try connect to DB and manipulate Data, works fine.如果您在 Visual Studio 中打开了 .edmx 文件，您应该只需右键单击表或表中的列并选择“重命名”即可。更改名称后，它将反映在“映射详细信息”窗口中。
If you have your .edmx file open in Visual Studio, you should be able to simply right-click on a table or a column in the table and choose 'rename'. Once you change the name it will be reflected in the Mapping Details window.
您可以轻松编辑名称...只需单击“类图”中的名称（当已选择该项目时）或 edmx 文件中的表格表示形式并输入新名称。如果单击文本时文本未变为选中状态且无法编辑，则可以按 F2（标准 Windows 键）来重新命名对象。注意：您无法在映射窗口中编辑名称。
编辑名称后，您可以右键单击实体并选择“从模型生成数据库...”选项来更新数据库中的名称。
另请参阅这篇文章更多信息。
You can edit the names easily... just click on the name (when the item is already selected) in the 'class diagram' or the table representation in the edmx file and type the new name. If the text does not become selected and editable when you click on it, you can press F2, the standard Windows key to raname an object. Note: you cannot edit the name in the mapping window.
After editing the names, you can right click on the entity and select 'Generate Database from Model...' option to update the names in the database.
Also, see this post for more information.
这里有一个适用于 VS 2010 的解决方案。如果您重命名一个条目，然后运行“从模型生成数据库...”两次。在第一次运行中，映射被调整，但您仍然收到（让我说“编译器”）错误。在第二轮比赛中，一切都很好。
我刚刚测试了两次。工作完美。
Here a solution that works on VS 2010. If you Rename an entry, afterwards run "Generate Database from Model..." two times. IN the first run, the mapping is adjusted but you still get a (let me say "compiler") error. In the second run, everything is fine.
I just tested it two times. Worked perfectly.