SyntaxFix

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

I got this error when using Visual Studio 2013 with Microsoft SQL Server Management Studio 2016 trying to update database with Entity Framework migrations

The fix was to install Microsoft SQL Server Management Studio 2012 SP1 as Visual Studio 2013 was missing the necessary libraries to connect to the SQL Server database.

I put together this detailed page with all the steps I took.

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