Page 1 of 1
SQL Server Compact + SQLite on Compact Framework 2.0
Posted: Tue 27 Nov 2012 19:32
by brian71us
Hello,
I've recently been asked to develop applications for a Windows Embedded CE 6.0 device using the .NET Compact Framework 2.0. The device has SQL Server Compact Edition on it and I'm working on getting SQLite to operate on it as well.
Will the dotConnect Universal library work on this device with SQL Server Compace and SQLite as the databases?
Thank you,
Brian Wheatley
Re: SQL Server Compact + SQLite on Compact Framework 2.0
Posted: Fri 30 Nov 2012 14:38
by Pinturiccio
The Mobile Edition of dotConnect Universal can work only with the following servers: Oracle, SQL Server, MySQL, PostgreSQL. So you can use dotConnect Universal for working with SQL Server Compact Edition, but not with the SQLite database under Windows CE.
Re: SQL Server Compact + SQLite on Compact Framework 2.0
Posted: Fri 30 Nov 2012 18:18
by brian71us
Can SQLite be added?
I've used the desktop edition and was able to add support for NexusDB's ADO.NET provider using the UniProvider component.
Re: SQL Server Compact + SQLite on Compact Framework 2.0
Posted: Fri 07 Dec 2012 11:19
by Pinturiccio
Yes, you can add any ADO.NET Compact Framework provider to dotConnect Universal Mobile. In a non-Mobile edition of dotConnect Universal you can register a ADO.NET provider in two ways:
- using the UniProvider component;
- implementing the IUniProvider interface.
dotConnect Universal Mobile doesn't have the UniProvider class, so you have to implement the IUniProvider interface. We have sent you a file with an example of how to implement the IUniProvider interface.
Devart doesn't have a ADO.NET Compact Framework provider for SQLite.