I want to create texttemplate(T4) which can generate POCOs from DB.

Question

Hi platform-independent peeps, I want to ask a question I have a web API live project in dot net framework using repository pattern now I want to convert my project completely to dot net core 3 or later without using entity framework since we don't like it. Following are the things we use in the current project.

 

1) SQL server

2) PetaPoco library (Micro ORM)

3) T4 template for database generation (when I add a column in SQL and go to the template and just press ctrl + s it automatically generate the model fields in a respective table/class)

 

Now, I want to create that T4 template for dot net core 3 or later for database model auto-generation. Any help would be highly appreciated.