C# socket client question

Question

Hi,

I can't quite get my head around a socket client application I am making.

I can connect to the socket server, send the subscribe request and receive the response but what I really need to do is

1) connect to the socket server
2) send the subscribe request
3) listen for responses and deal with them as they come in

Can anyone point me in the right direction?

I have been using the microsoft documentation http://msdn.microsoft.com/en-us/library/fx6588te.aspx
but I just can't get my head around the concept of sending and receiving on one socket.

Please help

Answer 1

Two completly defrent databases
One is Oracle another is Sybase.
What I need is bulk extractions from one database to another

Database tables are similar(not exactly the same as they are deferent databases)
E.g. 
DB1 -- TableA
Col1 varchar
Col2  number

E.g. in DB2 -- TableA
Colx varchar
Coly  number

Answer 2

How different are the schemas? IE does one table have fields the other doesn't?  

If anything, you could create the first Dataset from DatabaseA, then create another Dataset from 
a DataAdapter against DatabaseB, copy the information from the first dataset to the second, then use
the DataAdapter to write the information back to DatabaseB.

I'm sure theres a better way, for instance i'm sure theres a way to modify the schema on the tables
in the Dataset, then just use another DataAdapter to write the info back.

Of course, if you can use Stored Procedures on the two servers, you could just do it that way and
not fool around with Datasets.

Answer 3

No! schemas are deferent
Is it possible to map the column names to update command?

Answer 4

Yes you can do it... make sure schema of both database tables are same...