binarythistle/s04e01---.net-5-graphql-api

s04e01---.net-5-graphql-api's Issues

nested queries not working

Nested queries are not working for me.

Plus ScopedService is obsolete

Platform query exposes sorting by LicenseKey

Hi,
I found out after looking at you YT video, that schema exposes the LiceseKey for sorting.
It is suggested to you when typing, and I verified that is does work as one should expect.

But, I think that this is leaking domain model to our GraphQL models (types) as we have choosen to ignore that field.

Is there an OOTB way to hide that field from ordering ?
I assume it is there as the GetPlatform-Query returns the domain object Platform, not the PlatformType; but how should the code be modified? Can we return the PlatformType as a result in Query, how should the binding to DbContext look like than

Question on performance

Hi Les! Thanks for your presentation, very helpful.

A question regarding performance. I noticed that even you specify limited fields of your entity, the generated SQL query is fetching all the fields.
ex:

graphQL query:

query {
  platform {
    name
  }
}

generates:

info: 8/22/2021 18:10:09.844 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
      Executed DbCommand (35ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [p].[Id], [p].[LicenseKey], [p].[Name]
      FROM [Platforms] AS [p]

Is there a way to fetching only desired field from DB?