This question is locked. New answers and comments are not allowed.
Can someone help me with deciding the best way to do the following?
I have a business table in 2 separate SQL databases on 2 different websites/servers.
Both websites use ORM for data access.
On server A, I display a grid of business and allow the user to check which businesses are active and allow 3rd party access.
All that so far is working fine...
When you click update on that page I want to push the active records that allow 3rd party access to a different page on server B and update the business table there. Basically I just need to send the grid dataset to Server B web page and do some processing of the data:
On Database B I need to:
-Update Active status on all rows
-Update Allow 3rdParty access on all rows
'insert all businesses that are not already there
(or I could simply delete all business in DB B and reinsert all from DB A)
I am unsure what I should be using...
SImple form post using serialized data / JSON???
WCF, RIA or what?
If WCF, I found lots on the WCF data services wizard to create WCF from my ORM but can't find much on how to consume the WCF on server B.
It looks to me like RIA is better for querying data using a formatted URL but which technology is best suited for mostly pushing large dataset.
I will have about 2500 business with about 12 fields each.(to start)
Any pointers appreciated.
I have a business table in 2 separate SQL databases on 2 different websites/servers.
Both websites use ORM for data access.
On server A, I display a grid of business and allow the user to check which businesses are active and allow 3rd party access.
All that so far is working fine...
When you click update on that page I want to push the active records that allow 3rd party access to a different page on server B and update the business table there. Basically I just need to send the grid dataset to Server B web page and do some processing of the data:
On Database B I need to:
-Update Active status on all rows
-Update Allow 3rdParty access on all rows
'insert all businesses that are not already there
(or I could simply delete all business in DB B and reinsert all from DB A)
I am unsure what I should be using...
SImple form post using serialized data / JSON???
WCF, RIA or what?
If WCF, I found lots on the WCF data services wizard to create WCF from my ORM but can't find much on how to consume the WCF on server B.
It looks to me like RIA is better for querying data using a formatted URL but which technology is best suited for mostly pushing large dataset.
I will have about 2500 business with about 12 fields each.(to start)
Any pointers appreciated.