Sqlite Code Generation fails

[statler]

Sqlite Code Generation fails

[sjh37]

Hi Statler, I'm currently on holiday with the family, I'll be back in the country on Monday.

[statler]

OK - so it runs correctly if you use the debug T4 template function in VS, but fails if you try and run it on save.

[statler]

OK, so it runs, but still generates incorrect configurations. Basically, if a class has multiple FKs to the same table, it will only add the first relationship . I expect that this line is the culprit
var constraints = fkList.Select(x => x.FkSchema + "." + x.ConstraintName).Distinct();

Because in the Sqlite config, the schema is identical, and the constraintname is built using the current table and FK Primary key ID, which is also the same. I expect this is a mistake, and the constraintname should include the local property.