.png)
Create a Visual C# SMO Project in Visual Studio .NET
This section describes how to build a simple SMO console application.
This example imports namespaces, which enables the program to reference SMO types. The import of the Agent namespace is optional. Use it when you are writing a program that uses SQL Server Agent. The Common namespace is required to establish a secure connection to the instance of SQL Server. The SqlClient namespace is used to process SQL exception errors.
Creating a Visual C# SMO project in Visual Studio.NET
-
Start Visual Studio 2008 (or Visual Studio 2005).
-
On the File menu, click New Project. The New Project dialog box appears.
-
In Project Types dialog box, select Visual C#, and then select Windows. In the Visual Studio Installed Templates pane, select Windows Application.
-
(Optional) In the Name field, type the name of the new application
-
Select the Visual C# application type. For the examples that follow, select Console Application.
-
On the Project menu, select Add Reference. The Add Reference dialog box appears.
-
Click Browse, locate the SMO assemblies in the C:\Program Files\Microsoft SQL Server\110\SDK\Assemblies\ folder, and then select the following files. These are the minimum files that are required to build an SMO application:
Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll
Microsoft.SqlServer.SqlEnum.dll
Note
Use the Ctrl key to select more than one file.
-
Add any additional SMO assemblies that are required. For example, if you are specifically programming Service Broker, add the following assemblies:
Microsoft.SqlServer.ServiceBrokerEmum.dll
-
Click Open.
-
On the View menu, click Code.-Or-Select the Program1.cs [Design] Windows and double-click the windows form to show the code window.
-
In the code, before the namespace statement, type the following using statements to qualify the types in the SMO namespace:
using Microsoft.SqlServer.Management.Smo; using Microsoft.SqlServer.Management.Common;
-
SMO has various namespaces under Microsoft.SqlServer.Management.Smo, such as Microsoft.SqlServer.Management.Smo.Agent. Add these namespaces as they are required.
-
You can now add your SMO code.
