Distinct on with entity framework core

Entity Framework 6 query with Distinct filter

I have a difficulty. When I run the following code:...var data = context.TableX.Where(w => w.userId == 9999&& w.id == 9999) .Distinct().ToList(); ...This is the result of the query:...SELECT [Extent1].[id] AS [id], [Extent1].[name] AS [name], [Extent1].[companyId] AS [companyId], [Extent1].[userId] AS [userId] FROM [TableX] AS [Extent1] WHERE (9999...

Deleting parent-child relation with Entity Framework or Entity Framework Core

ZZZ_tmp

Issue when inserting new entity with relationships to existing entities (Entity Framework Core 1.1.0 )

ZZZ_tmp

Log DbContext.SaveChanges Exception to the database in Entity Framework/Entity Framework Core

ZZZ_tmp

Add migration - Both Entity Framework Core and Entity Framework 6 are installed

ZZZ_tmp

Entity Framework Core 2.1 How to OrderBy() and Distinct()

ZZZ_tmp

Selecting all rows based on a distinct column in Entity Framework Core

ZZZ_tmp

Add or Update child entities when updating a parent entity in Entity Framework Core

ZZZ_tmp

Get Distinct Entries Based On Specific Column in Entity Framework

ZZZ_tmp

Entity Framework - Distinct Facets - Performance Optimization

ZZZ_tmp