Our great sponsors
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
If you are talking about the hard coded sql query in the code, well first I am not using any Query Builder and second don't worry it is just an example to show the query I am doing. I could have used a stored procedure as well but but having just the stored procedure name would not have help people to reproduce my example. Besides most ORM (EF Core included) allow you to specify a raw sql query so it's a question of a C# feature here. And I am using an ORM here which is Dapper, maybe not as much features as other ORMs but it works fine and has a very good performance compared to other (although I think EF Core in .NET 6 is supposed to be almost as performant as Dapper).