An elegant Query Builder and Executor helps you deal with SQL queries in an elegant and predictable way.
Written in C#, the language we all love, you can check the source code on SqlKata on Github
It uses parameter binding technique to protect your application against SQL injection attacks. There is no need to clean strings being passed as bindings.
In addition to protection against SQL injection attacks, this technique speeds up your query execution by letting the SQL engine caches and reuses the same query plan even if the parameters are changed.
고인물이라 DB퍼스트로만 작업하다보니 EF에 적응하지 못하고 Dapper를 사용하다 지금은 sqlkata를 사용합니다.