Skip to content

how-to-create-a-visual-csharp-smo-project-in-visual-studio-net.md

Latest commit

 

History

History
51 lines (35 loc) · 2.35 KB

how-to-create-a-visual-csharp-smo-project-in-visual-studio-net.md

File metadata and controls

51 lines (35 loc) · 2.35 KB
title Create a Visual C# SMO Project in Visual Studio .NET
ms.custom seo-dt-2019
ms.date 08/06/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology
ms.topic reference
helpviewer_keywords
Visual C# [SMO]
ms.assetid 1e7abb16-23a0-4a18-91ad-253261e6bf84
author markingmyname
ms.author maghan
monikerRange =azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

How to Create a Visual C# SMO Project in Visual Studio .NET

[!INCLUDEappliesto-ss-asdb-asdw-xxx-md]

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 [!INCLUDEssNoVersion] Agent. The Common namespace is required to establish a secure connection to the instance of [!INCLUDEssNoVersion]. The SqlClient namespace is used to process SQL exception errors.

Creating a Visual C# SMO project in Visual Studio.NET

  1. Start Visual Studio

  2. On the File menu, click New and then Project. The New Project dialog box appears.

  3. In the [!INCLUDEvsprvs] Installed pane, navigate to Templates\Visual C#\Windows and select Console Application.

  4. (Optional) In the Name text box, type the name of the new application.

  5. Click OK to load the console application template.

  6. Follow the instructions on Installing SMO to install the package for your project to reference.

  7. On the View menu, click Code.

  8. 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;

  9. SMO has various namespaces under Microsoft.SqlServer.Management.Smo, such as Microsoft.SqlServer.Management.Smo.Agent. Add these namespaces as they are required.

  10. You can now add your SMO code.