Dual-coding for SQL and SQL CE
Posted on 2013-01-10
I'm looking at options to make an application suitable for both MS SQL and SQL CE. The installer will choose whether they are using it single-PC or networked and, if single-PC, I don't want them to have to go through having to install SQL Express.
Problem I'm finding with .NET is that, whilst support for the two DB engines is very good, the SQL and SQLCE objects are different, so everything has to be coded twice, using the two sets of objects.
Can anyone suggest any techniques to build a class that can be told which DB engine to use, but still present a common object to the rest of the application.
Alternatively are there any 3rd party libraries that will do the job?