Import/Export CSV, Excel And Multiple User Support Via Remoting

Hi,

I'd recently posted a question about using SQL CE as a database server for a multi-user desktop app. I did some development and tested it, and it seemed to work fine. What I did was:

1. create a remoteable object that used SqlCe classes to perform read and write operations to an encrypted CE database.


public class RemData : MarshalByRefObject

{


public DataSet GetData()

{

//Read data
}

public int AddData(DataSet data)

{
//Write data
}
}

2. hosted this object in a Remoting Server


TcpServerChannel channel = new TcpServerChannel(props, bp);

// Register the channel with the runtime remoting services

ChannelServices.RegisterChannel(channel, false);



RemotingConfiguration.RegisterWellKnownServiceType(


typeof(RemData ), // The type to register

"RM_RemData", // The objectURI

WellKnownObjectMode.SingleCall

);

So, basically the CE DB is running in-proc with this Remoting Server. This is hosted on a regular P2 1GB box.

3. created client WinForms app to connect to this object through remoting with url tcp://myserverip/RM_RemData and distributed this client EXE to various machines within the intranet to execute the GetData and AddData methods

This seems to work perfectly fine and super fast, and i was also concurrently executing the above methods in loops of 100.

So what I don't understand is why most of the posts I read about multi-user scenario here and on the web are always discouraging people to only use CE for single-user desktop? As long as I use the SQL CE ONLY as a Data Store and all logic into my data layer such as the Remotabe Objects, will this be a feasible option for around 10-20 Users since CE allows 256 Connections anyway?

My other questions are with regards to programmatically Import/Export to and from CSV and Excel..is this supported or anything planned?

Would appreciate a detailed response..my product hangs in balance as i need some closure on this

Thanks,
CP