用于特定表的SQL Metal或将表刷新/添加到.dbml文件的另一种方法 [英] SQL Metal for specific tables or another way to refresh/add table to .dbml file

问题描述

任何人都可以在Visual Studio中执行任何简单的方法，而不必使用服务器资源管理器?

anybody have any easy way of doing this in Visual Studio, without having to use the Server Explorer ?

我也尝试查看宏，但只录制了作品

I tried also looking at macro's but recording only produce

  Sub TemporaryMacro()
  End Sub

所以那里没有运气.

有什么脚本方法吗?

推荐答案

SqlMetal包含我. 首先使用SqlMeta创建一个完整的dbml文件-说testComplete.dbml

SqlMetal Include worked like a charm for me. First Create a complete dbml file using SqlMeta - Say testComplete.dbml

现在提供此文件作为SqlMetaInclude的输入 SqlMetalInclude/dbml:"testComplete.dbml"/输出:" testSubSet.dbml"/include:dbo.SampleTable1=SampleTable1,dbo.SampleTable2=SampleTable2

Now provide this file as an input to SqlMetaInclude SqlMetalInclude /dbml:"testComplete.dbml" /output:"testSubSet.dbml" /include:dbo.SampleTable1=SampleTable1,dbo.SampleTable2=SampleTable2

请注意，此工具中包含一个可以处理整个过程的GUI.

Note that this tool in has a GUI included which can handle the complete process.

这篇关于用于特定表的SQL Metal或将表刷新/添加到.dbml文件的另一种方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！