Jesper

class SearchResult
    {
        public string ObjectNo { get; set; }
    }

    class SearchResultMap : EntityTypeConfiguration<SearchResult>
    {
        public SearchResultMap()
        {
            HasKey(t => new {t.ObjectNo});
            Property(t => t.ObjectNo).IsRequired().HasMaxLength(16);

            ToTable("msvi_ObjectSearchList_Static");
            Property(t => t.ObjectNo).HasColumnName("objectNo");
        }
    }

    class MyContext : DbContext
    {
        public DbSet<SearchResult> SearchResults { get; set; }

        public MyContext(string connectionString) : base(connectionString)
        {
            Database.SetInitializer<MyContext>(null);
        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Configurations.Add(new SearchResultMap());
        }
    }

    class Program
    {
        static void Main(string[] args)
        {
            const string connectionString = @"";
            using(var context = new MyContext(connectionString))
            {
                var result = context.SearchResults;
                var distinctResult = context.SearchResults.Distinct();

                var resultList = result.ToList();
                var distinctList = distinctResult.ToList();
                // resultList.Count() == distinctResult.Count() = true
                return;
            }
        }
    }