Home Dashboard Directory Help

VS 2012 - SQL CLR template missing for VB by Mister T99



Sign in
to vote
Type: Bug
ID: 776949
Opened: 1/18/2013 3:08:18 PM
Access Restriction: Public
User(s) can reproduce this bug


After creating an empty SQL Database project, I add an SQL CLR scalar function. It creates a C# function even though my primary language is VB. Also, in the list of functions to add there is:


The SQL CLR looks like a T-SQL language function. The next one is obviously a C# function. There is no option for a VB function.
Sign in to post a comment.
Posted by Microsoft on 3/19/2013 at 6:08 PM
You can switch to VB by opening the project settings, selecting "SQLCLR" and then choosing Language=Visual Basic.
Posted by Microsoft on 1/21/2013 at 12:41 AM
Thanks for your feedback.

We are rerouting this issue to the appropriate group within the Visual Studio Product Team for triage and resolution. These specialized experts will follow-up with your issue.
Posted by Microsoft on 1/18/2013 at 3:51 PM
Thank you for your feedback, we are currently reviewing the issue you have submitted. If this issue is urgent, please contact support directly(http://support.microsoft.com)
Sign in to post a workaround.
Posted by Mister T99 on 3/20/2013 at 6:19 AM
codestalker - thanks for this information

Can they make this any more convoluted?

This is just about as bad as removing icons from the tool bars. This is sad how they change things and not give us any tips as to what they have changed.
Posted by codestalker on 3/18/2013 at 4:26 AM
This works for me using Visual Studio 2012 Professional.

1. Create a new SQL Server Project in VS 2012.
2. Open Properties in Solution Explorer.
3. In the menu choose SQLCLR
4. Under Language change the option to Visual Basic.

When you add a new item to the project you should see SQL CLR VB in the menu which gives you access to the VB items.

Hope this helps.