Ease of use

[krugertech]

I would like to recommend making available sample projects for the most comon database platforms.

For example:
MySQL
MSSQL
SqLite

What we are finding is that new adopters are struggling to get the PetaPoco component and T4 template working. After about 30 mintues they give up trying to use it and switch to something else.
A sample project could cut down on the adoption time significantly and increase the adoption rate.

[iadaz]

Hi @krugertech, are the users aware of the Wiki pages here on Github, which include a quick-start page and a walk-through of the T4 templating? Are there specific problems (perhaps with particular providers) that new adopters are running into problems with?

[pleb]

@krugertech sounds like a great idea. @iadaz is right, but I feel that any effort to reduce the bar of adoption is a good thing. I wonder if a version or two of the http://todomvc.com/ would suffice

[6pac]

I'm a longtime PetaPoco user - in fact, I was on board the SubSonic train in the earlier days.

I have personally found that the T4 templates crash almost always on DotNet Core (VS2017 Pro v15.9.6). I have never found a solution for this, despite googling for hours - none of the suggestions worked. The only workaround was to run the templates in debug mode, which is way slower.
After some judicious fiddling I was able to change the code to stop them crashing, and I have been keen to feed the changes back.
It's tempting to blame the user, but this issue, if it occurs, is a real show stopper.

I think sample projects are a great idea. Don't know if Access, MSSQL and MySql versions of Northwind would help. I'm starting off with SQLite at the moment, could probably arrange a version in that too. I put these together way back for my SubSonic collab adventures.

[pleb]

@6pac

longtime PetaPoco user

Good to hear!

The t4 templates are on the way out. I've never really used them, but I know they're popular. The logic of these templates needs to be taken and placed in the newer .net core tooling feature. There's another thread around with more details.

Sample projects are a great idea. When I'm finished adding async support, this is likely going to be what I work on next.

[6pac]

So, at risk of going OT, what is T4 being replaced with? I haven't found a clear alternative. SubSonic 2 used a custom generator based on the ASP page generation engine. Then SubSonic 3 made the leap to T4. I have considered going back to the SS2 way, given all the T4 woes. T4 no longer appears to be fully supported.

I've never really used them

so what DO you use to generate your POCO files?