Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Expose SQL Data Provider through RemotingExpose SQL Data Provider through Remoting
Previous
 
Next
New Post
8/12/2008 8:33 AM
 

Hi,

I am fairly new to DotNetNuke and could do with some guidance. I have been tasked with extending DotNetNukes functionality for a client who has a specific requirement to use .Net remoting for data access. They wish to have the DotNetNuke database deployed onto its own server and communication for resources should occur over HTTP using binary serialization.

In order to achieve this goal I had planned on doing something along the following lines:

1) Create a class library to act as the remote server instance (hosted within IIS). Within this library there would be an interface to be exposed to the client application, that would closely match the abstract method implementation within the base DataProvider class. There would also be a class that implements this interface and actually performs the data access functions using the enterprise library.

2) Create a new data provider project within DotNetNuke (RemotingDataProvider), that implements the same functions as the SqlDataProvider, except for whenever access is required to the database, remoting is used to generate a proxy and call the various functions exposed by the interface.

Due to the sheer size and number of functions within the SqlDataProvider class, it could take me a rather long time to implement such a mechanism and I am sure there would be a number of headaches along the way. Plus testing of such changes would be difficult as in order to test effectiviely you would want to test all the method calls within the class.

Due to the timescales on this project, going down this route does not seem like a viable option, so I was hoping someone might be able to offer a simpler solution to the problem, or be able to point me at resources where this has been done before within the community?

Any help would be greatly appreciated...

 
New Post
9/5/2008 7:49 PM
 

Perhaps this would be useful:

SQL server 2000: http://msdn.microsoft.com/en-us/library/aa286527.aspx
SQL Server 2005: It has native HTTP support via SOAP built-in http://msdn.microsoft.com/en-us/library/ms191274.aspx

Seems like they only want safe protocols used on the network, but frankly HTTP and SQL Server (usually 1433) both use one port to connect and high ports to transfer.  However, people who use firewalls never seem to understand anything beyond layer 4 of the OSI model and this seems to give them comfort.  using this approach will be exponentially slower than raw SQL Server protocols, but it meets their requirements without you going crazy to build classes with stubbed out functions.

 
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Expose SQL Data Provider through RemotingExpose SQL Data Provider through Remoting


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out