Hi,

I need to map a database ( sql server, MySql ... ) and run the mapped class on NetFC2.

It's that possible ?

Thanks.

Create the db on sqlserver, migrate it to sqlserver ce, and use the sqlserver project to generate code for the CE db. It's cumbersome, but CE doesn't provide any metadata so we can't create a project from CE.

I did make me understood... sorry.

What I need to do it's to access, from Windows CE, data stored on SQLserver.

I would like to generate a data layer and use it on NetCF using SqlServer as data store.

Thanks.

....Ops

I didn't make me understood... (sorry for my English)

What I need to do it's to access, from Windows CE, data stored on SQLserver.

I would like to generate a data layer and use it on NetCF using SqlServer as data store.

Thanks.

In general it's done this way: you replicate the data you need onto the CE device and access it locally. Then, when you're done you replicate the changes back to the main db.

It's otherwise somewhat insecure as you then have to have wireless access to the Sqlserver db, which needs wireless access to the outside world.

The compact framework support of LLBLGen Pro focusses on accessing a local database, not a database over the network.

Hi...

I Know what you said... I've found it out.

In the application that I'm developping the clients running NetCF access a SQL server Database engine by a Wifi Lan... it's not a slow network. It's a warehouse application.

It's would be usefull, istead of access sql server by System.data.SqlClient on Netcf, be able to use LLBL to mapp the SQLServer tables on NETCF client.

..... as it does on desktop applications.

Well, we're not changing the client to SqlServer, as compact framework is already a pain to support (no automatic testing etc.). Therefore, you can access a local sqlserver database with llblgen pro from the compact framework (sqlce). If that's not sufficient, please use a webservice.