How about authentication, because json result from sql, no need model? about sql-server-samples HOT 3 CLOSED

Can you clarify your question please.

Is there a particular sample in particular you're looking at?

from sql-server-samples.

I will assume that you are talking about the samples in feature/json folder where we are generating JSON in sql. Generating JSON in SQL and access control to your C# method (i.e. controller actions) are completely independent. You can use existing auth mechanism to control what user can execute some action. If your can invoke Product/Edit, then you will just execute underlying sql and generate JSON response.

from sql-server-samples.

I'm closing this question because there are no additional responses. My suggestion would be to take a look at ASP.NET Core security where it is described how to implement authentication. Authentication and security is independent of model unless if you are relying on SQL Server security model where you would pass identity to database.

from sql-server-samples.