I've just taken on a WinForms project with a Click Once deployment requirement.
Data access uses Oracle.DataAccess.dll (ODP.NET) which depends on a full client-side install of the Oracle Client.
My.CSLA.Library.dll -> Oracle.DataAccess.dll -> Oracle Client
The Oracle Client cannot be installed via Click Once. If Click Once is to be used to deploy my application I will need to remove my application's client-side dependency on the Oracle Client.
I've been thinking a CSLA.NET server-side DataPortal may be able to help.
My question is:
If all calls to Oracle.DataAccess.dll are executed server-side within CSLA.NET Data Portal, will my application still be dependent on client-side installations of the Oracle Client?
I believe it will still need that unless you move ALL data
access code outside of client project. The reason being, your data access
code is still using Oracle client and is still in the same CSLA
class. So, click once will see this as a dependency and will attempt to
distribute DLL. AN option is to distribute DLL, but not use it. This
may work.
Sergey Barskiy
Senior Consultant
office: 678.405.0687 |
mobile: 404.388.1899
Microsoft Worldwide Partner of the Year | Custom
Development Solutions, Technical Innovation
From: ejames
[mailto:cslanet@lhotka.net]
Sent: Monday, May 19, 2008 9:45 AM
To: Sergey Barskiy
Subject: [CSLA .NET] Click Once with Oracle and CSLA.NET
I've just taken on a WinForms
project with a Click Once deployment requirement.
Data access uses Oracle.DataAccess.dll (ODP.NET) which depends on a full
client-side install of the Oracle Client.
My.CSLA.Library.dll->Oracle.DataAccess.dll->Oracle Client
The Oracle Client cannot be
installed via Click Once. If Click Once is to be used to deploy my
application I will need to remove my application's client-side dependency on
the Oracle Client.
I've been thinking a CSLA.NET
server-side DataPortal may be able to help.
My question is:
If all calls to
Oracle.DataAccess.dll are executed server-side within CSLA.NET Data Portal,
will my application still be dependent on client-side installations of the
Oracle Client?
My.CSLA.Library.dll-server-side only->Oracle.DataAccess.dll->Oracle Client
sergeyb:
I believe it will still need that unless you move ALL data access code outside of client project. The reason being, your data access code is still using Oracle client and is still in the same CSLA class. So, click once will see this as a dependency and will attempt to distribute DLL. AN option is to distribute DLL, but not use it. This may work.
I could be totally wrong, but I thought that click once
applications have to have all referenced assemblies to verify the install.
Sergey Barskiy
Senior Consultant
office: 678.405.0687 |
mobile: 404.388.1899
Microsoft Worldwide Partner of the Year | Custom
Development Solutions, Technical Innovation
From: ajj3085
[mailto:cslanet@lhotka.net]
Sent: Monday, May 19, 2008 10:16 AM
To: Sergey Barskiy
Subject: Re: [CSLA .NET] RE: Click Once with Oracle and CSLA.NET
I believe it will still need that unless you move ALL data access code outside of client project. The reason being, your data access code is still using Oracle client and is still in the same CSLA class. So, click once will see this as a dependency and will attempt to distribute DLL. AN option is to distribute DLL, but not use it. This may work.
Hi,
Just want to point out there's no need to remove the data access code at
all. If the OP sets up remoting, as long as none of the code which
depends on the Oracle client actually runs, all will be well because .Net lazy
loads referenced assemblies. So the OP can just install the client on the
remoting target and all should be well.
Nope, but I think this should work.
Sergey Barskiy
Senior Consultant
office: 678.405.0687 |
mobile: 404.388.1899
Microsoft Worldwide Partner of the Year | Custom
Development Solutions, Technical Innovation
From: ejames
[mailto:cslanet@lhotka.net]
Sent: Monday, May 19, 2008 10:23 AM
To: Sergey Barskiy
Subject: Re: [CSLA .NET] RE: Click Once with Oracle and CSLA.NET
My idea is to distribute the
Oracle.DataAccess.dll via Click Once but not make any data access calls until
DataPortal takes my objects server-side.
Has anyone tried this?
I haven't done this with clickonce, but I have an application which uses remoting where Oracle is only installed on the application server, not on the client. Obviously the client code references the OracleDataAccess dll but never uses it, but it doesn't cause a problem. If you can get ClickOnce to deploy the Oracle.DataAccess dll you should find you don't need a full client-side Oracle install.