Database Tips

In order to support database with a different culture or case-sensitive collation, make sure the database queries are written in case-sensitive format.

For example:

A query build against the above table should be:

Correct:

SELECT Id FROM SKAddInProviders

Wrong:

SELECT id FROM SKAddInProviders [Id column contains small letter i]

SELECT Id FROM SKAddinProviders [Table name contains small letter i]

The same applies for readers and rows in DataTable.

reader["id"] is wrong

reader ["Id"] is correct