Great tool for LINQ Query

Joseph Albahari has created a great tool for LINQ query expression. You can dwnload it  from here.

Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc

You may receive “Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc” while connection to database.  I got the error when I tried to connect to SQL Server 2005 from Visual studio 2008 using server explorer. The exact error is,

Could not load file or assembly ‘Microsoft.SqlServer.Management.Sdk.Sfc, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. The system cannot find the file specified.

To solve this error you need to download following three updates from Microsoft.

  • Microsoft SQL Server System CLR Types
  • Microsoft SQL Server 2008 Management Objects
  • Microsoft SQL Server 2008 Native Client

I found the solution form here. Thanks to Ahmed !!!