SyntaxFix

[.net] Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0

Supplement to Iman Mahmoudinasab's answer

For SQL Server 2016, this is where to find the files:

https://www.microsoft.com/en-us/download/details.aspx?id=52676

Note that the files are in the list but you may need to scroll down to see/select it.

From SQL Server 2017 onwards, things change:

"Beginning with SQL Server 2017 SMO is distributed as the Microsoft.SqlServer.SqlManagementObjects NuGet package to allow users to develop applications with SMO."

Source: https://docs.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/installing-smo?view=sql-server-2017

Examples related to .net

• You must add a reference to assembly 'netstandard, Version=2.0.0.0 • How to use Bootstrap 4 in ASP.NET Core • No authenticationScheme was specified, and there was no DefaultChallengeScheme found with default authentification and custom authorization • .net Core 2.0 - Package was restored using .NetFramework 4.6.1 instead of target framework .netCore 2.0. The package may not be fully compatible • Update .NET web service to use TLS 1.2 • EF Core add-migration Build Failed • What is the difference between .NET Core and .NET Standard Class Library project types? • Visual Studio 2017 - Could not load file or assembly 'System.Runtime, Version=4.1.0.0' or one of its dependencies • Nuget connection attempt failed "Unable to load the service index for source" • Token based authentication in Web API without any user interface

Examples related to visual-studio

• VS 2017 Git Local Commit DB.lock error on every commit • How to remove an unpushed outgoing commit in Visual Studio? • How to download Visual Studio Community Edition 2015 (not 2017) • Cannot open include file: 'stdio.h' - Visual Studio Community 2017 - C++ Error • How to fix the error "Windows SDK version 8.1" was not found? • Visual Studio Code pylint: Unable to import 'protorpc' • Open the terminal in visual studio? • Is Visual Studio Community a 30 day trial? • How can I run NUnit tests in Visual Studio 2017? • Visual Studio 2017: Display method references

Examples related to sql-server-2008-r2

• A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233) • Rebuild all indexes in a Database • How to get last 7 days data from current datetime to last 7 days in sql server • Get last 30 day records from today date in SQL Server • what is numeric(18, 0) in sql server 2008 r2 • Conversion failed when converting date and/or time from character string in SQL SERVER 2008 • 'MOD' is not a recognized built-in function name • How to Convert datetime value to yyyymmddhhmmss in SQL server? • SQL Server stored procedure Nullable parameter • SQL Server 2008 R2 can't connect to local database in Management Studio

Examples related to entity-framework-5

• Entity Framework Join 3 Tables • The type initializer for 'System.Data.Entity.Internal.AppConfig' threw an exception • Entity Framework (EF) Code First Cascade Delete for One-to-Zero-or-One relationship • Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0 • EF LINQ include multiple and nested entities • Entity Framework 5 Updating a Record • Non-static method requires a target • How do I enable EF migrations for multiple contexts to separate databases? • After updating Entity Framework model, Visual Studio does not see changes • Entity Framework Migrations renaming tables and columns