Make my DAL dll know where the database is????

[Alex Stevens]

Hi All.

I've written a data access component which I want to install on a database
server machine.
I have two questions which I'd would appreciate anyone's advice /
experience.

I want to make the data access component dll available to - say a business
layer which could reside on another machine.
How do I make this available to the business object?
Is this using .net Remoting? - Could someone point me to somewhere good to
start.

Secondly, When I have my data object, I'd like it to have a default
connectionstring, however I'd like this to be modifiable outside the dll and
somehow picked up by the dll when the data acess object is first
instantiated.
I remember something like this in COM+, but not anything specific.

Thanks

Alex

[Allen Anderson]

Remoting is indeed the technology to use for this. Since your network
is internal you are probably most interested in speed so I would
recommend you use an SAO Singlecall object with tcp channel and binary
formatter.

The connection string you should encrypt and store in an xml config
file.
Allen Anderson
http://www.glacialcomponents.com
mailto: allen@put my website url here.com

On Wed, 28 Jan 2004 12:42:08 -0000, "Alex Stevens"
<al****************@gcc.co.uk> wrote:

Hi All.

I've written a data access component which I want to install on a database
server machine.
I have two questions which I'd would appreciate anyone's advice /
experience.

I want to make the data access component dll available to - say a business
layer which could reside on another machine.
How do I make this available to the business object?
Is this using .net Remoting? - Could someone point me to somewhere good to
start.

Secondly, When I have my data object, I'd like it to have a default
connectionstring, however I'd like this to be modifiable outside the dll and
somehow picked up by the dll when the data acess object is first
instantiated.
I remember something like this in COM+, but not anything specific.

Thanks

Alex