SqlKata the dotnet SQL query builder


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๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

์ข‹์•„์š” 3

๋ณด์—ฌ์ฃผ์‹  ๊ฒƒ๊ณผ ๊ฐ™์€ Micro ORM๋“ค์ด ์˜คํ”ˆ ์†Œ์Šค ๋‹ท๋„ท ํ”„๋กœ์ ํŠธ๋กœ ๋งŽ์ด ๊ณต์œ ๋˜๋Š” ๊ฒƒ ๊ฐ™์€๋ฐ, ํ•œ ๋ฒˆ ์ •๋ฆฌํ•ด๋ณด๋Š” ๊ฒƒ๋„ ์ข‹์„ ๊ฒƒ ๊ฐ™๋„ค์š”! ๊ณต์œ  ๊ฐ์‚ฌ๋“œ๋ฆฝ๋‹ˆ๋‹ค.

์ข‹์•„์š” 1

์ข‹์€ ํˆด ์†Œ๊ฐœ ๊ฐ์‚ฌ๋“œ๋ฆฝ๋‹ˆ๋‹ค(__)
์–ธ์  ๊ฐ€ ํ•œ๋ฒˆ ์ €๋„ ์ €๋Ÿฐ ํŽธ์˜๊ธฐ๋Šฅ ํ•œ๋ฒˆ ๋งŒ๋“ค๊ณ  ์‹ถ๋‹ค๋Š” ์ƒ๊ฐ์„ ํ•œ ์ ์ด ์žˆ๋Š”๋ฐ
(์ €๊ธฐ์„œ ์ง์ ‘ ์ฟผ๋ฆฌ๊นŒ์ง€ ์‹คํ–‰ ํ•ด์„œ IEnumerable<object> ๋‚ด์ง€๋Š” DataTable ๋กœ ๋ฐ˜ํ™˜ํ•˜๋Š”โ€ฆ)
์—ญ์‹œ ์„ธ์ƒ์€ ๋„“๊ณ  ์ €๋ณด๋‹ค ๋ถ€์ง€๋Ÿฐํ•˜์‹œ๊ฑฐ๋‚˜ ๋˜๋Š” ๊ณ ์ˆ˜๋ถ„๋“ค์ด ๋งŽ์œผ์‹œ๊ตฐ์š” [โ€ฆ]
์ด๋ฏธ ๋ˆ„๊ฐ€ ๋งŒ๋“ค์–ด๋†“์•˜๋‹ค๋Š”๊ฑธ ๋ณด๋‹ˆ ํ—ˆํƒˆํ•จ 20% ์กด๊ฒฝ 60% ์—ญ์‹œ ์‚ฌ๋žŒ ์ƒ๊ฐ์€ ๋น„์Šทํ•˜๊ตฌ๋‚˜ ํ”ผ์‹ํ•จ 20% ์ž…๋‹ˆ๋‹ค ใ…Žใ…Ž