Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

PortalWebHosting
  Ads  
Iron Speed Designer is a software development tool for building database, reporting, and forms applications for .NET without hand-coding.
 


  Sponsors  

Meet Our Sponsors

CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Extend It! ( Pr...  Expose SQL Data Provider through Remoting
Previous Previous
 
Next Next
New Post 8/12/2008 6:33 AM
User is offline Chris Newton
4 posts
10th Ranked


Expose SQL Data Provider through Remoting 

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 5:49 PM
User is offline Keith Adler
55 posts
10th Ranked


Re: Expose SQL Data Provider through Remoting 

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 Previous
 
Next Next
  Forum  General DotNetN...  Extend It! ( Pr...  Expose SQL Data Provider through Remoting
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


FREE Skins, Modules & Control Panel!
Choose how much you want to pay on our Skins, Modules, Containers and Control Panel - Starting from FREE!
www.dnngroup.com
Disgrafic
Diseño y creación de portales web dinámicos :: Desarrollo de módulos personalizados :: Soluciones a medida :: Imagen Corporativa :: Tu proveedor DNN en España
www.disgrafic.com
DM Analytics, LLC
DM Analytics, LLC provides software solutions that facilitate rapid development of independent or dependent datamarts and their associated web-based reporting.
www.dmanalytics.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP