Hardcoded Query in PetaPoco ORM

Asked Jul 20 '16 at 13:56

Active Jul 20 '16 at 14:40

Viewed 52 times

We are planning to use PetaPoco in our project. As it is tiny ORM with performance benefit, one of the thing worried me a lot is hard coded queries.

Due to that, whenever our column changes (added/removed), we have issue to find out same in all the queries.

Can we generate Columnname in tt file and use that in place of hard coded query something like:

"Select * from " + Tables.Customer + " Where " + CustomerTable.CustomerId + " = 1"

edited Jul 20 '16 at 14:40

ErikEJ

asked Jul 20 '16 at 13:56

Manish Pansiniya

It's not in the Petapoco project scope and it will be a royal PITA to maintain. Try to use good naming conventions for your tables and you are good. – Eduardo Molteni Jul 26 '16 at 13:24
I do not understand royal PITA. – Manish Pansiniya Jul 26 '16 at 15:41
Will be too hard to develop day to day. – Eduardo Molteni Jul 27 '16 at 13:33
You should look into NPoco (a PetaPoco fork) that (I think) implements a Linq provider, so you can make statically linked queries https://github.com/schotime/NPoco/wiki/Simple-LINQ-Queries /cc @schotime – Eduardo Molteni Jul 28 '16 at 18:53
True. But what about Performance and Support/Updates? – Manish Pansiniya Aug 03 '16 at 11:10

0 Answers0