ZZZ Code AI
Seed Data Generator
Stored Procedure Generator
Entity to Table Converter
Table to Entity Converter
Sql Injection Detector
What is my personal (Jonathan Magnan) preference?
<p>I prefer Dapper when reading data and <a href="https://dapper-plus.net/">Dapper Plus</a> when saving data over EF Core. The combination of both libraries makes it perfect and gives me the best flexibility and performance.</p> <p>Dapper gives me 100% control over how I select my data. It often happens that some <code>SELECT</code> are complex with multiples join, group by, where clause, so writing my own SQL makes perfect sense to ensure the statement is optimized. When I select data, I can choose all information in one database roundtrip and make sure only the information I need is selected.</p> <p>Dapper Plus ensures that my data are inserted, updated, or deleted the fastest way possible and doesn't force me to create those SQL statements. Saving data is usually very simple, so I don't want to bother writing those statements for every entity type I could have to save. In case I need to customize my savings, Dapper Plus gives me all the options I need without worrying about writing my SQL.</p> <p>It's a little bit contradicting as I want 100% control of the SQL when reading data and no control when saving, but at the same time:</p> <ul> <li>When reading data, 95% of my code requires writing custom SQL</li> <li>When saving data, 95% of my code doesn't require any custom SQL</li> </ul> <p>Sure Dapper Plus is not free, nor is my time for writing and testing all SQL that will save data in the Database.</p> <p>Another important note:</p> <ul> <li>I mostly create personal projects such as <a href="https://zzzcode.ai/">ZZZ Code AI</a></li> <li>I don't have to handle a team. Only a few developers touch with me these projects</li> </ul>
This field is required
A text with a minimum of 10 characters is required
Legal & Licensing
Answer generated by AI may produce inaccurate information about code, people, facts, and more.
Did you know...
That you can now sponsor this project on
Entity Framework Extensions