New Posts New Posts RSS Feed: Updating a Web Service
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Updating a Web Service

 Post Reply Post Reply
Author
*Calsy View Drop Down
Groupie
Groupie


Joined: 02-Feb-2009
Location: Australia
Posts: 69
Post Options Post Options   Quote *Calsy Quote  Post ReplyReply Direct Link To This Post Topic: Updating a Web Service
    Posted: 05-Apr-2009 at 11:07pm
Hi All, Just reading the Developers Guide, and it says the following:

"It is not possible to update the business model through the published web service in this release of DevForce. We will add the ability to insert, update and delete business objects (and their graphs) in future version of DevForce. Of course you can write your own update methods today. This is not nearly as easy or convenient as it will be when DevForce can generate update methods for you. Hang in there."

Is there an ETA on this functionality at all?

Thanks
Back to Top
kimj View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 1390
Post Options Post Options   Quote kimj Quote  Post ReplyReply Direct Link To This Post Posted: 06-Apr-2009 at 8:32am
There is no plan to implement this functionality.  You can implement this (albeit with modest difficulty) using a custom IAdapterProvider.  I can send you a sample of this if you're interested.
Back to Top
*Calsy View Drop Down
Groupie
Groupie


Joined: 02-Feb-2009
Location: Australia
Posts: 69
Post Options Post Options   Quote *Calsy Quote  Post ReplyReply Direct Link To This Post Posted: 06-Apr-2009 at 2:36pm
Hi Kim, I will give you my scenario and you can let me know if this is the best way to do it.

I need the application to connect to a web based sql server hosted by us. This will be so we can send information straight to the customers database. Therefore the application can be connected to databases (multiple databases) over the following scenarios:
1. a) Connected Locally to their database (over rdbkey connection string)
b) Connected to our web based server

2. a) Connected over IIS to their database
b) connected to our web based server

I dont want the user to see the connection string (and therefore be able to connect to it) so we cant supply it as a straight sql database connection. And we cant go over IIS because the user could already be using the IIS connection for their own database (if we could have multiple IIS connection we would be home). This is why we went down the path of web services which is great if we just want to read information but we do require to do some writing to the database.

Is there anyway we can encrypt the database connection string the in the loose Ibconfig? If not have you got any other ideas?

Thanks in advance




Back to Top
kimj View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 1390
Post Options Post Options   Quote kimj Quote  Post ReplyReply Direct Link To This Post Posted: 06-Apr-2009 at 6:30pm
Matthew, I'm really not clear on what some of these terms mean or what you need.
 
"connected over IIS to their database" - Is this a DevForce application connected to a BOS running under IIS? 
 
"our web based server" - Is this a web service?
 
"if we could have multiple IIS connections ..." - ??
 
Although I don't understand the use case, here are a few things to look at which may help:
  • a custom DataSourceKeyResolver, which would allow you to hide connection strings from the user, and possibly encrypt the connection string (although you would be responsible for decrypting it)
  • use of the PersistenceServiceOption flag when creating the PersistenceManager to control whether it will use the BOS or not
  • directly calling the web service from your application w/o DevForce involvement
 
 
 
 
Back to Top
*Calsy View Drop Down
Groupie
Groupie


Joined: 02-Feb-2009
Location: Australia
Posts: 69
Post Options Post Options   Quote *Calsy Quote  Post ReplyReply Direct Link To This Post Posted: 06-Apr-2009 at 9:00pm
Im quite sure the Custom DatasourcekeyResolver should do exactly what we want to do. Have you got any samples of using one at all. I have created a class that implements idatasourcekeyresolver but it never seems to jump into my GetKey function.

Thanks
Back to Top
*Calsy View Drop Down
Groupie
Groupie


Joined: 02-Feb-2009
Location: Australia
Posts: 69
Post Options Post Options   Quote *Calsy Quote  Post ReplyReply Direct Link To This Post Posted: 06-Apr-2009 at 9:38pm
No need to worry. I worked it about by configuring the Ibconfig instance in memory

Dim x As IdeaBlade.Util.IdeaBladeConfig = IdeaBlade.Util.IdeaBladeConfig.Instance
            x.RdbKeys(1).Connection = "Provider=SQLOLEDB.1;Password=Test;Persist Security Info=True;User ID=Test;Initial Catalog=IdeaBladeTutorial;Data Source=."

Works a treat.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down