Could not load type 'Microsoft.SqlServer.Server.SqlContext' from assembly 'System.Data, Version=4.0.0.0

Question

I have facing a problem while i am trying to restore the Data base in sqlserver 2012 .

My project configuration :

ASP.Net core 2.0, Vs2017 Preview2, c#

i have installed Microsoft.SqlServer.Scripting using nuget package , then i tried to restore data base using below code

try
{
    string DatabaseName = "TestDB";
    String ConnectionString = "Data Source=(local);Initial Catalog= " + DatabaseName + ";Integrated Security=SSPI;";
    SqlConnection sqlConnection = new SqlConnection(ConnectionString);
    // Error on the line below
    Microsoft.SqlServer.Management.Common.ServerConnection conn = new Microsoft.SqlServer.Management.Common.ServerConnection(sqlConnection);
    Server srv = new Server(conn);
    Console.WriteLine(srv.Information.Version);
}
catch (Exception ex)
{
    string exepe = ex.Message.ToString();
}

Error is :

Could not load type 'Microsoft.SqlServer.Server.SqlContext' from assembly 'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.

Did i miss anything? can you please any body help me out this .

It's likely not there (neither on packagesearch nor on github corefx) for .NET Core and you have to target .NET Framework instead — Tseng
– Tseng, Commented Aug 7, 2017 at 16:00
Hello Tseng thanks for your reply , yeah i tried .Net Framework also i gives same error . I tried with windows application there it works. — Victor Athoti.
– Victor Athoti., Commented Aug 7, 2017 at 16:18

Shaul Behr · Accepted Answer · 2018-06-19 09:42:14Z

2

I had the same problem today. I solved it by referencing Microsoft.SqlServer.SqlManagementObjects.

answered Jun 19, 2018 at 9:42

Shaul Behr

38.2k72 gold badges263 silver badges403 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Could not load type 'Microsoft.SqlServer.Server.SqlContext' from assembly 'System.Data, Version=4.0.0.0

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related