J
JB
Hi All,
I need to write my first "distributed" application and due to my lack
of knowledge and experience in that area, I'm stuck on the first big
design decision. Reading a lot on distributed applications, remoting,
etc didn't help me much for that particular issue.
The main data the application manipulates is a list of Queries. A
query is a custom object containing an SQL statement and some
parameters to allow the query to run (e.g. DB connection params,
etc).
My server is where my list of queries will reside. It will be a
windows service as it needs to run permanently.
My client will display that list of queries and enable the user to
add, delete and modify the queries in the list. The client will also
initiate the running of all the queries (i.e. tell the server to run
all the queries sequentially).
What would be the recommended design as far as the list of queries is
concerned:
- A "shared" style where my list of queries on the server is accessed
(by reference) and modified by the client. i.e. from the client I
would do something like:
QueryRef = Server.List(3) 'Get a reference on the 3rd Query in the
list
QueryRef.SQL = "Select * from TABLE1" 'Directly modify the reference
i.e. the Query itself
And how can that be implemented in .Net with VB or even C#?
- A "message" style where my list of queries on the server will not be
accessed directly but through some sort of Get/Set messages like:
QueryCopy = Server.GetQuery(3) 'Get a copy of the 3rd Query locally in
my client
QueryCopy.SQL = "Select * from TABLE1" 'Modify the copy of the Query
Server.SetQuery(3, QueryCopy) 'Send the changes to the server
- Or is there a better type of design?
If anybody could shed some light over this or point me to a good
source of information, I would greatly appreciate it.
Thanks & Regards
JB
I need to write my first "distributed" application and due to my lack
of knowledge and experience in that area, I'm stuck on the first big
design decision. Reading a lot on distributed applications, remoting,
etc didn't help me much for that particular issue.
The main data the application manipulates is a list of Queries. A
query is a custom object containing an SQL statement and some
parameters to allow the query to run (e.g. DB connection params,
etc).
My server is where my list of queries will reside. It will be a
windows service as it needs to run permanently.
My client will display that list of queries and enable the user to
add, delete and modify the queries in the list. The client will also
initiate the running of all the queries (i.e. tell the server to run
all the queries sequentially).
What would be the recommended design as far as the list of queries is
concerned:
- A "shared" style where my list of queries on the server is accessed
(by reference) and modified by the client. i.e. from the client I
would do something like:
QueryRef = Server.List(3) 'Get a reference on the 3rd Query in the
list
QueryRef.SQL = "Select * from TABLE1" 'Directly modify the reference
i.e. the Query itself
And how can that be implemented in .Net with VB or even C#?
- A "message" style where my list of queries on the server will not be
accessed directly but through some sort of Get/Set messages like:
QueryCopy = Server.GetQuery(3) 'Get a copy of the 3rd Query locally in
my client
QueryCopy.SQL = "Select * from TABLE1" 'Modify the copy of the Query
Server.SetQuery(3, QueryCopy) 'Send the changes to the server
- Or is there a better type of design?
If anybody could shed some light over this or point me to a good
source of information, I would greatly appreciate it.
Thanks & Regards
JB