Last post Sep 12, 2012 09:43 AM by Rouchie
Sep 12, 2012 08:36 AM|Rouchie|LINK
We have a large web application (ASP.NET 4 web forms + SQL Server) that stores users, plus tons of related data about each user. One of our potential clients has expressed a requirement that our user data should be populated and maintained from their Oracle
Assuming (possibly incorrectly) that Oracle would 'push' data into our system, my thoughts on a solution are:
If the above approach is correct, are there any examples of how I could go about creating a web method to handle this? Is it even possible to perform CRUD operations from a public-facing page function/subroutine? I can only find MVC/Entity examples online
which are no good for us. The web method may not be accessed via a web page either, but possibly directly over HTTP from Oracle, if indeed that's even possible...
Any help/thoughts would be very helpful. Here's hoping...!
Sep 12, 2012 09:23 AM|brijeshvaidya|LINK
the oracle data fetch and entered in your sql data..
for that use webservice..
and give the generic name .
do not genereate separate userids.. use the same as oracle..
but when u display at that time.. change them(using sql backend)
for web method,.. example..
first of all ask the client / your for webservice so
from that webservice u can get the data and then in your application logic
do the crud.
Sep 12, 2012 09:43 AM|Rouchie|LINK
Not sure if my question was clear enough. Please let me add some more information.
Step 1 is not a problem. Both databases (SQL/Oracle) have their own distinct schema, however there is a common unique field for both (EmployeeID) which will be used to lookup. I was going to get the data entered via Oracle > Excel > SQL so that's not really
Step 2 is the problem.
Currently there are no webservices created for any database (none in Oracle, and none in SQL). We currently do not know how the Oracle database works (e.g. web-based or desktop-based), so I am just investigating how this
might be done for now. My assumption was that Oracle would have to access our web-based webservice to 'push' the data. I don't know if there is another way. What is the difference between using JSON or XML for
a webservice - does it matter?
One thing I would like to see is some very basic code to create a webservice in ASP.NET that we can use as a basis to work from. Do you have any links to that (not MVC though!).