6/11/2023 0 Comments Sql server json query performance![]() Now a similar query to get your results: var result = await _context.UserDTOs In your db context: // context prop for dbset You would take your UserDTO and create the keyless entity to map to your view. The other option (but slightly different from just a keyless entity) - if you want to make use of the query that you already have in your procedure.Ĭreate a view ( UserDTO_Properties) with your query w/o the concatenation of first/last fields and then a keyless entity to go with your view. ![]() Where(u => u.IsActive
0 Comments
Leave a Reply. |