Comments by Qadeer Ahmed Khan (Top 10 by date)

Didn't work. I added [Key] to both classes and yet still same. If I send Organization as null in json it works fine. Not sure why it is trying to insert data in Organizations table while it should just insert relation key into it.

So I found this in documentation.

Note:
The value of vector coordinates delimited with a ^ character in the following format: x1,y1^x2,y2^xN,yN^~
If there is a pen-up event, then you use the coordinate 0, 65535 to signal a break in the line
^ is the coordinate delimiter, ~ is the ending delimiter, and a comma (,) is the vector delimiter

Each Customer is assigned a unique id like CSP644 which can be sent for each service call. These databases are deployed upon different servers and there is a central database which keeps record of connection information. e.g
CSPID = CSP644
Host = SomeHost
Database = DBName
Password = ThePassword

So I should load a SQL Server Compact database table by calling a web service which would return data from central database and keep them locally. Clients would send their CSPID and other details like Email and Password for authentication.

Also should I keep a connection open for each database or close them after executing query as I am currently doing. Also is it possible to handle requests asynchronously and what would be the best way to do it?

There is a different database for each client.