About FromSqlRaw function in web api

In Entity Framework Core, when you use .FromSqlRaw("exec uspGetAllUsers")

EF expects the result to match your entity (UserMaster) — meaning all mapped columns must be returned, even if you don’t use them.
That’s why your stored procedure must return all 10 columns.

UserMaster is an entity model. EF tracks it, so it expects

• every mapped column

• in the correct type

• to build a complete entity

If the stored procedure returns less columns, EF can’t hydrate the entity ? it throws errors.

Let your stored procedure return only the fields you need (e.g., 4 columns), and map that to a DTO instead of the entity.

Create a DTO

public class UserDto

{

public int UserId { get; set; }

public string UserName { get; set; }

public string Email { get; set; }

public string Mobile { get; set; }

}

public DbSet UserDto { get; set; }

Stored Procedure returns only needed columns

SELECT UserId, UserName, Email, Mobile

FROM UserMaster

Query using DTO

public async Task> GetAllUsers()

{

return await _usersContext

.UserDto

.FromSqlRaw("exec uspGetAllUsers")

.ToListAsync();

}