SqlCeConnectionCase sensitive database

Upon database creation the default is case insensitive, use this one for a case sensitive database.

Data Source=MyData.sdf;Case Sensitive=True;Persist Security Info=False;

This allows you to have multiple values, wich only deffer in lower / upper case, in a unique column.

This setting is a database creation time option and is ignored when connecting to an existing database.


This connection string (Case sensitive database using SqlCeConnection) can be used for connections to SQL Server Compact.

Articlesread all »

Not the right connection string for you?

Start over in the connection string reference index.

You can also get help in the Q&A forums where you can ask your own question.

The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.