SQL 项目未在 SQLCLR 属性中显示 C#
我正在尝试在 SSDT 中创建 SQL Server 项目，但在属性中我在语言下拉列表中看不到 C#。当我打开以前创建的 SQL 项目时，我可以看到 C# 选项。 创建使用 C# 语言的 SQL 项目需要做什么？
系统上安装的软件版本 -
Microsoft Visual Studio 2013 Shell (Integrated)
Version 12.0.21005.1 REL
Microsoft .NET Framework
Version 4.8.04084
Installed Version: IDE Standard
Common Azure Tools 1.6
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.
SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 12.0.5000.0
SQL Server Data Tools 12.0.61021.0
Microsoft SQL Server Data Tools
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 12.0.2430.0
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 12.0.2430.0
Windows Installer XML Toolset 3.10.2.2516
Windows Installer XML Toolset version 3.10.2.2516
创建 SQL 项目并重现问题的步骤 -
- 打开 Visual Studio
- 单击文件 ->新->项目->模板 – SQL Server -> SQL Server 数据库项目。
- 给出名称并选择解决方案的位置。
- 将创建数据库项目。
- 转到解决方案资源管理器 ->右键单击解决方案->特性。
- 单击 SQLCLR。单击语言下拉菜单。在这里我应该看到 C# 选项，但它丢失了。
我应该怎么做才能获得 C# 语言选项？
I am trying to create a SQL Server Project in SSDT but in the properties I can't see C# in the language dropdown. When I open a previously created SQL Project I can see the C# option.
What do I need to do to create a SQL Project having C# language?
Software Versions installed on the system-
Microsoft Visual Studio 2013 Shell (Integrated)
Version 12.0.21005.1 REL
Microsoft .NET Framework
Version 4.8.04084
Installed Version: IDE Standard
Common Azure Tools 1.6
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.
SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 12.0.5000.0
SQL Server Data Tools 12.0.61021.0
Microsoft SQL Server Data Tools
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 12.0.2430.0
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 12.0.2430.0
Windows Installer XML Toolset 3.10.2.2516
Windows Installer XML Toolset version 3.10.2.2516
Steps to create the SQL Project and reproduce the issue -
- Open Visual Studio
- Click on File -> New -> Project -> Template – SQL Server -> SQL Server Database Project.
- Give the Name and select the location of solution.
- Database project will be created.
- Go to Solution Explorer -> Right click on Solution -> Properties.
- Click on SQLCLR. Click on the Language drop down. Here I should see the C# option but it is missing.
What should I do to get the C# option in language?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
SSDT 是用于开发 SQL Server 项目的 Visual Studio 2013 shell（集成）。它不附带 C#。您需要单独安装 C# 作为“工具”>“的一部分”扩展。
请参阅 pdf 文档
SSDT is Visual Studio 2013 shell (integrated) for developing SQL Server projects. It does not come with C#. You need to install C# separately as part of Tools > Extensions.
Refer to the pdf documentation