CODEWITHSUNDEEP
c#sqlnamespaces
I'm here for Winter Hats
I'm here for Winter Hats

Reputation: 593

Code using wrong namespace

I having an aspx.cs file that I am adding code to. I have all the right namespaces and references in my solution, but my code is referencing the wrong namespace with the following error on my Server server = new Server()

System.Web.UI is a 'property' but used as a 'type'

using System;
using System.Text;
using System.Collections.Generic;
using System.Linq;
using System.Text.RegularExpressions;
using System.IO;
using System.Data.SqlClient;
using Microsoft.SqlServer.Management.Common;
using Microsoft.SqlServer.Management.Smo;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace IISLoggingSolution
{
    public partial class Main : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            //connection string for SQL DB
            string connectionString = @"Data Source=Computer\SQLEXPRESS;Initial Catalog=IISLogs;Integrated Security=True";

            //Location of the query to be ran
            string script = File.ReadAllText(@"C:\\Users\\User\\Desktop\\query.txt");

            SqlConnection conn = new SqlConnection(connectionString);

            //this is the error line
            Server server = new Server(new ServerConnection(conn));

            //executes query
            server.ConnectionContext.ExecuteNonQuery(script);


        }
    }
}

How can I get it to use the Microsoft.SqlServer.Management.Smo instead of trying to used the System.Web.UI?

Upvotes: 0

Views: 1031

Answers (2)

Muckeypuck
Muckeypuck

Reputation: 559

using NS_Server = Microsoft.SqlServer.Management.Common;
using System.Web.UI;

...

NS_Server.Server server = new NS_Server.Server();

the line using NS_Server is an alias. You can use it as a shortcut when there are namespace collisions.

Upvotes: 3

Micael
Micael

Reputation: 155

You can use an alias directive:

using Server = Microsoft.SqlServer.Management...Server;

It may not work if property takes precedence, but in that cas you can simply specify the full namespade path.

var server = new Microsoft.SqlServer.Management....Server();

Upvotes: 0

Related Questions