c# - 如何从 .NET Core 应用程序加载 VS 数据库项目?
问题描述
默认情况下,在 .sqlproj 文件中有一个带有此类导入行的 Visual Studio SQL Server 数据库项目:
<PropertyGroup>
<VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">11.0</VisualStudioVersion>
<!-- Default to the v11.0 targets path if the targets file for the current VS version is not found -->
<SSDTExists Condition="Exists('$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets')">True</SSDTExists>
<VisualStudioVersion Condition="'$(SSDTExists)' == ''">11.0</VisualStudioVersion>
</PropertyGroup>
<Import Condition="'$(SQLDBExtensionsRefPath)' != ''" Project="$(SQLDBExtensionsRefPath)\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
<Import Condition="'$(SQLDBExtensionsRefPath)' == ''" Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
尽管 VisualStudioVersion 11.0 没有包含 SSDT 的目录,但它可以从 Visual Studio 正确打开。但是,当尝试使用 Microsoft.Build 包从 .NET Core 应用程序加载项目时,会引发错误:
未找到导入的项目“D:\TestApp\TestApp\bin\Debug\netcoreapp3.1\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets”。确认导入声明“D:\TestApp\TestApp\bin\Debug\netcoreapp3.1\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets”中的表达式是正确的,并且该文件存在于磁盘上。
D:\Database1\Database1\Database1.sqlproj
项目加载的代码看起来像
var project = new Microsoft.Build.Evaluation.Project(@"D:\Database1\Database1\Database1.sqlproj");
解决方案
我想要的只是使用 AddItem 方法将一些项目添加到项目中,然后保存它。
正如我所说,您可以忽略错过的导入,并且我相信这将防止发生错误,为此您可以使用Project构造函数的以下重载:
public Project (string projectFile, System.Collections.Generic.IDictionary<string,string> globalProperties, string toolsVersion, Microsoft.Build.Evaluation.ProjectCollection projectCollection, Microsoft.Build.Evaluation.ProjectLoadSettings loadSettings);
设置loadSettings
为IgnoreMissingImports
:
/// <summary>
/// Flags for controlling the project load.
/// </summary>
/// <remarks>
/// This is a "flags" enum, allowing future settings to be added
/// in an additive, non breaking fashion.
/// </remarks>
[Flags]
[SuppressMessage("Microsoft.Design", "CA1008:EnumsShouldHaveZeroValue", Justification = "Public API. 'Default' is roughly equivalent to 'None'. ")]
public enum ProjectLoadSettings
{
/// <summary>
/// Normal load. This is the default.
/// </summary>
Default = 0,
/// <summary>
/// Ignore nonexistent targets files when evaluating the project
/// </summary>
IgnoreMissingImports = 1,
/// <summary>
/// Record imports including duplicate, but not circular, imports on the ImportsIncludingDuplicates property
/// </summary>
RecordDuplicateButNotCircularImports = 2,
/// <summary>
/// Throw an exception and stop the evaluation of a project if any circular imports are detected
/// </summary>
RejectCircularImports = 4,
/// <summary>
/// Record the item elements that got evaluated
/// </summary>
RecordEvaluatedItemElements = 8,
/// <summary>
/// Ignore empty targets files when evaluating the project
/// </summary>
IgnoreEmptyImports = 16,
/// <summary>
/// By default, evaluations performed via <see cref="Project"/> evaluate and collect elements whose conditions were false (e.g. <see cref="Project.ItemsIgnoringCondition"/>).
/// This flag turns off this behaviour. <see cref="Project"/> members that collect such elements will throw when accessed.
/// </summary>
DoNotEvaluateElementsWithFalseCondition = 32,
/// <summary>
/// Ignore invalid target files when evaluating the project
/// </summary>
IgnoreInvalidImports = 64,
/// <summary>
/// Whether to profile the evaluation
/// </summary>
ProfileEvaluation = 128,
}
推荐阅读
- javascript - 如何从多维数组中修剪值
- android - 切换片段并返回后使用BottomNavigationBar时DialogFragment不会关闭
- javascript - Await 函数不包含来自 Promise 的完整数据
- oracle - 解释计划语句假脱机的计划表输出中未显示物化视图?
- python - PyQt:如何在按钮样式表中使用 :hover
- python - 如何在 Python 中的循环内建立 TCP 连接?
- android - 为什么不调用 YouTubeSupportFragment.initialize()?
- java - 如何运行此 SQL 更新语句
- c++ - 如何使用系统头文件创建makefile
- testing - 如何测试哪种文档相似度算法性能最好