Error While Working with Northwind Database

See more:

SQL-CE

SQL-Server

Hi every one

I'm working on Northwind database, I could get access to the tables by code using ADO.net, but when I try to load the tables in server explorer, after adding the database, I can't see the tables and I get the Error:

Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral ...

what is the problem?

Tnx

by code it is working:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlServerCe;
using System.Data.SqlClient;
using System.Data.Sql;

namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlCeConnection Connection = new SqlCeConnection("Data Source=E:\\Northwind.sdf;"); 

            try
            {

                Connection.Open();

                SqlCeCommand Command = Connection.CreateCommand();

                Command.CommandText = "SELECT * FROM Employees";

                SqlCeDataReader Reader = Command.ExecuteReader();

                while (Reader.Read())
                {
                    Console.WriteLine("\n RegionId={0}\t RegionDescription={1}",Reader.GetSqlInt32(0).Value,Reader.GetSqlString(1).Value);
                }

            }
            catch (SqlCeException ex)
            {

                Console.WriteLine(ex.Message); ;
            }

            finally
            {
                if (Connection.State == System.Data.ConnectionState.Open)
                {
                    Connection.Close();
                }
            }


            Console.ReadKey();


        }
    }
}