Thank you for getting back to me, I appreciate it. Unfortunately this solution does not exactly solve my problem. I am trying to avoid having to manually set properties after generation.
Our database has about 250 tables and who knows how many properties there are in total. Manually changing every property that is supposed to be boolean or even adding partial classes that hold boolean properties connected to their string counterpart would be huge pain. Not to mention complications arising from regenerating code when we update from the database. (We plan to only make changes to the db directly and then run the update from database tool to update our models).
I found this page
outlining the database types that map to .NET types. Is there no way to customize any of these? We have a fairly large codebase with a lot of legacy code that actually uses string “True” and “False” values from the database.
Perhaps it is not that simple and setting a mapping for varchar(5) to be created as a boolean property in the code that will get set properly from the database is not possible. If this is the case is there a way I can customize the code generation to implement one of your solutions above automatically?
I did try to look into customizing code generation but I was somewhat overwhelmed and if this is the route I have to take I could use some guidance.
Any help you can offer is greatly appreciated.
P.s. I should note we actually have telerik account where we have purchased a number of your products and have paid support included I believe. I just happened to post this question using my own account. Is there any benefit to linking our paid account to this question?