Click here to Skip to main content
16,018,525 members

Comments by xyznelson (Top 3 by date)

xyznelson 17-Apr-15 17:45pm View    
Nice little POCOGenerator APP you wrote. I did find a bug however in one of
your SQL statements that is easily fixable. In your GetPrimaryKeys(DATABASE database)
method, add this line of code just before the "ORDER by" clause:

where kc.type = 'PK'

without it, unwanted rows slip through (like columns with a Unique Key constraint on them) causing an annoying bug.
xyznelson 17-Apr-15 17:44pm View    
Nice little POCOGenerator app you wrote. I did find a bug however in one of
your SQL statements that is easily fixable. In your GetPrimaryKeys(Database database)
method, add this line of code just before the "order by" clause:

where kc.type = 'PK'

without it, unwanted rows slip through (like columns with a Unique Key constraint on them) causing an annoying bug.
xyznelson 17-Apr-15 17:42pm View    
Nice little POCOGenerator app you wrote. I did find a bug however in one of
your SQL statements that is easily fixable. In your GetPrimaryKeys(Database database)
method, add this line of code just before the "order by" clause:

where kc.type = 'PK'

without it, unwanted columns slip through (like columns with a Unique Key constraint on them) causing an annoying bug.