Why i'm getting error for the Microsoft.SqlServer.Server namespace?

Question

I'm writing this code:

string sqlConnectionString = conn1;

//string sqlConnectionString = "Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=True";
FileInfo file = new FileInfo("d:\\behzadBULK.sql");
string script = file.OpenText().ReadToEnd();

SqlConnection conn = new SqlConnection(sqlConnectionString);
Microsoft.SqlServer.Server server = new Microsoft.SqlServer.Server(new ServerConnection(conn));
server.ConnectionContext.ExecuteNonQuery(script);

but I'm getting an error in this line

Microsoft.SqlServer.Server = ....

I added the Microsoft.SqlServer.Smo reference, but I get this error:

'Microsoft.SqlServer.Server' is a 'namespace' but is used like a 'type'

What happen? Thanks.

My error:

enter image description here

@Jamel hi ,why i get error in the Microsoft.SqlServer.Server server = new Microsoft.SqlServer.Server(new ServerConnection(conn)); line? — behzad razzaqi, Jul 04 '15 at 05:33
Because you are using a namespace as a class and making an object of it. — Jamil, Jul 04 '15 at 05:35

score 4 · Accepted Answer · answered Jul 04 '15 at 05:43

4

Change your namespace from Microsoft.SqlServer.Smo to Microsoft.SqlServer.Management.Smo

answered Jul 04 '15 at 05:43

Jamil

330
1
6
25

Hi jamal,but i can not found the Microsoft.SqlServer.Management.Smo – behzad razzaqi Jul 04 '15 at 05:54
Your sql have the library `Microsoft.SqlServer.SmoExtended.dll`. Search that and add it to your project. – Jamil Jul 04 '15 at 06:00
Mostly its in **C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies**. Tell me when you found it! – Jamil Jul 04 '15 at 06:02
i found that and add the reference but so get error! – behzad razzaqi Jul 04 '15 at 06:07
But i use the Microsoft.SqlServer.SmoExtended.dll – behzad razzaqi Jul 04 '15 at 06:46
Add references to: -> **Microsoft.SqlServer.ConnectionInfo.dll** -> **Microsoft.SqlServer.Smo.dll** -> **Microsoft.SqlServer.Management.Sdk.Sfc.dll** -> **Microsoft.SqlServer.SqlEnum.dll** – Jamil Jul 04 '15 at 06:48
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/82351/discussion-between-jamel-and-behzad-razzaqi). – Jamil Jul 04 '15 at 06:50

score 2 · Answer 2 · answered Jan 10 '18 at 10:44

While using visual studio 2017 & above solutions did not work for me.

Simply I recreated a new project as SQL Server Database Project
and choose SQL CLR C# User Defined Function type
Automatically the namespace got added without any issues.

Previously i tried all nuget packages which did not work for me.

score 0 · Answer 3 · answered Jul 04 '15 at 05:38

0

You are initializing a namespace, not a class, that's why error occurred.

Use a class from Microsoft.SqlServer.Server namespace

answered Jul 04 '15 at 05:38

Hemal

3,682
1
23
54

Why i'm getting error for the Microsoft.SqlServer.Server namespace?

3 Answers3

Linked