Sql Compact Installation

[jankhana]

Hi all, Is there any way by which we can find pro grammatically whether SQL Compact is installed or not... Actually I need to know whether the compact edition is installed or not in PC and so that I can include or exclude the SQL Compact dll... Because in my application there are different process that access the same .sdf file which will cause Access Violation error if those dll are included and compact is installed...

Any idea!!!

[Delerna]

Have you tried searching the registry for the keys that get added when SQL Compact is installed.

All you need do then, is pragrammaticall y check for the existance of those keys in the registry