How to create dll for sql asembly using Visual Studio 2013 express?

I am trying to created some CLR function using this offical documentation. In order to create the dll I have download Visual Studio 2013 Express.

The issue is I am getting errors like this on build:

Error 1 The type or namespace name 'Data' does not exist in the namespace 'System' (are you missing an assembly reference?)

I am using the following template:

and using the solution found in the net setting net framework as target:

but is not working again.

Also, which version of the .NET Framework should I use for SQL Server 2012?

Answers


Your project type should be Class Library not Portable as on your screenshot.

Be sure you've included reference to System.Data assembly in your project.

SQL 2012 uses CLR 4.0 by default.

UPDATE

You should use VS Express 2013 for Windows Desktop (not "For Windows") in order to create Winforms apps and class libraries. See What is the difference between Visual Studio Express 2013 for Windows and Visual Studio Express 2013 for Windows Desktop?


Need Your Help

Error inflating class com.actionbarsherlock.internal.widget.ActionBarContainer

java android actionbarsherlock

I'm trying to integrate abs into my app, but I keep getting this error about not being able to inflate com.actionbarsherlock.internal.widget.ActionBarContainer. Can anyone help?

SQL UNION with ORDER

sql sql-server select sql-order-by union

What's wrong with this statement? I get the following errors:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.