216.513.4261
Website Links
Could not load file or assembly or one of its dependencies
  Code      Home  Entity Framework / SQL / Visual Studio / Could not load file or assembly
The Error
Trying to update database using Entity Framework - I got the error below:
Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.sfc, Version=11.0.0.0, Culture=neutral or one of its dependencies. The system cannot find the file specified.
The Microsoft Visual Studio error spelled out: Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.sfc, Version=11.0.0.0, Culture=neutral or one of its dependencies. The system cannot find the file specified.
Resolution to the error
In this particular case I was using Visual Studio 2013 with SQL Server 2016.
It turns out that in order to update a database with Entity Framework migrations - Visual Studio 2013 needs the libraries that connect Visual Studio to the SQL Server database.
These libraries and assemblies are associated with Microsoft SQL Server Management Studio 2012.
When you run Visual Studio 2013 - you need SQL Server Management Studio 2012 SP1.
Download it from here: https://www.microsoft.com/en-us/download/details.aspx?id=35575
Install SQL Server Management Studio 2012 SP1 > then restart Visual Studio.
Update the database again and view the tables:
error could not load file or assembly resolution

We’ll take the time to learn about your business needs then develop a customized plan
to meet your company’s custom software needs.

  • Analogy of Pearl - graphic logo - accounting, bookkeeping and financial analysis firm |  Copyright 2019 © Analogy of Pearl - all rights reserved  |  site version: 2.1.1.6