Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is everything case sensitive?

April 26, 2017Case sensitive

0

Posted

Is everything case sensitive?

1 Answer

0

Posted

• A – Assume it is and you can’t go wrong. In truth, some parts are and some parts aren’t and it’s beyond the control of SnapDAL. The filesystem name would match correctly on “Query_customer” or “query_customer” because File.Exists is case insensitive. However the statement name in the file gets used in a hashtable, which is always case sensitive. Similar issue with parameter names. The SnapDAL version of the name is case sensitive, but database parameters are not case sensitive unless the database insists it is. Just assume case sensitive names for everthing and you can’t go wrong.