open 2 database in wince

Question

Is it posible to open more than 2 databases in WinCE ?

I work with Sql CE 3.5. Can I get example for open 2 connections?

Answer 1

You're going to have to give us a bit more to go on than that. What kind of database? SQLCE? MySQL? SQL Server via a SqlClient? EDB? db4o? Something else?

In general, there is no issue with opening multiple databases from a single app simultaneously- you just have to have a separate connection object for each. You can also have multiple connections to the same database, provided the data engine you're using supports it (SQL CE 3.5 does, earlier doesn't, SQL Server does, not idea if MySQL does).

Edit: For example, to make 2 separate connections to a SQL CE database, just create two distinct SqlCeConnection objects using the same connection string.