ServiceStack.Ormlite Postgres case insensitive queries

Question

I am looking to cleanly implement a mechanism to override all where clauses that compare strings to do the following

[Column].Value.ToLower() == SqlParam.ToLower()

effectively overcoming the case sensitivity of Postgres.

Possibly a duplicate of stackoverflow.com/questions/18807276/… — bonh
– bonh, Commented Apr 6, 2020 at 13:11

mythz · Accepted Answer · 2020-04-06 12:14:24Z

0

OrmLite's INamingStrategy allows you to customize how Schemas, Tables and Columns are named and OrmLite's PostgreSQL Provider is already configured to use the PostgreSqlNamingStrategy which converts or .NET's PascalCase names to PostgreSQL-friendly snake_case.

answered Apr 6, 2020 at 12:14

mythz

144k31 gold badges253 silver badges400 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ServiceStack.Ormlite Postgres case insensitive queries

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related