getting same row in entityframework for table without primary key

Question

I have below data in database table "City" with no primary key

CityId  CityName
1       ABC
1       XYZ

I am using entityframework to fetch this data and I am getting same row. Below is the Context Class code

public class StudentsDbContext :DbContext
    {
        public DbSet<City> cities { get; set; }
    }

Below is the City Class Code

[Table("City")]
    public class City
    {
        [Key]
        public int CityId { get; set; }
        public string CityName { get; set; }
    }

Below is the output code

StudentsDbContext studentsDbContext = new StudentsDbContext();
            List<City> cities = studentsDbContext.cities.ToList();
            foreach (var val in cities)
            {
                Console.WriteLine("studentName: " + val.CityName);
            }
            Console.ReadLine();

Below is the output image enter image description here

Below is the desired result

CityName: ABC
CityName: XYZ

You also need to use `DefaultIfEmpty` if you want to do a left join. — juharr, Aug 13 '20 at 04:00
Use Left Outer Join : https://learn.microsoft.com/en-us/dotnet/csharp/language-reference/keywords/join-clause — jdweng, Aug 13 '20 at 06:57
I have updated my issue that I have found please help me with this — shin95, Aug 13 '20 at 15:32
I'm glad you edited the post, but currently you don't have any questions in the new post. Before the post was edited you mentioned a left outer join. Are you still willing to do that? If yes I can help. — Richárd Baldauf, Aug 13 '20 at 15:42
@RichárdBaldauf I was not able to get desired result because of this above problem — shin95, Aug 13 '20 at 15:43
@RichárdBaldauf I have updated desired result in above post — shin95, Aug 14 '20 at 03:59
could you try removing the `[Key]` attribute from `City` class `CityId` property? — Richárd Baldauf, Aug 14 '20 at 05:32
Btw, It's not a good idea to get rid of the primary key, see answer here:https://stackoverflow.com/questions/15381233/can-we-have-table-without-primary-key-in-entity-framework — Richárd Baldauf, Aug 14 '20 at 06:59
@RichárdBaldauf but if there is such a case then do you know how can we do it in EF — shin95, Aug 14 '20 at 07:21
@shin95 Gotcha! The CityId is the same for both city, if you going to chane the Id for the second city (XYZ) it shoud work. — Richárd Baldauf, Aug 14 '20 at 09:40
@RichárdBaldauf I dont want to change the data...I need both rows with same exact values — shin95, Aug 14 '20 at 12:38

getting same row in entityframework for table without primary key

0 Answers0