I have read on the front screen that Compact Framework is supported..

My project is as follows. I have a local SQLCE DB that stores all data on a PDA. Then, when the engineer gets a GPRS Signal, the data is transmitted back to base to an SQL Server 2005 DB.

Can LLBLGen do this?

I am currently using EntitySpaces, however that will not allow me to use two different databases simultaneously.

Yes that's possible, the data send across is just XML anyway, so that's not a problem. The code generated for the CE part is generated from the same LLBLGen Pro project as the server side.

Just take a look at it by using the demo of LLBLGen Pro: create a project from a sqlserver db, generate code using that for sqlserver 2005 and then also generate code for CE using the platform selector in the code generation dialog.

Be sure to select adapter.

We've included a page in the manual which explains these steps better. (Compact Framework / SqlCE support)

(edit) However if you want to connect to the Sqlserver db directly from the handheld, that's not possible. We support sql ce on windows CE but not sqlserver 200x connections from windows CE/pocketpc.

So the answer is no then? I'm a bit confused.

I need to communicate with both servers from the PDA.

right, you can communicate with both servers. the pda will have direct communication local db. the pda will communicate with a remote web serivces. this webservice intern will communicate with the remote db.

the ascii picture will look like this [pda] -> [local db] [pda] -> [web services] -> [remote db]