Oracle Database & ASP.NET Sample Code
$10-30 AUD
Paid on delivery
I need some SAMPLE CODE created with an Oracle database & .Net Interface. to demonstrate how to copy data to 2 separate tables (one to many ) with a single stored procedure.
---------------------------------------------------------------------------
Oracle Relationships Database with 2 tables
---------------------------------------------------------------------------
Table 1: Applications
---------------------------------------------------------------------------
Fields:
ApplicationID | Auto Generate ID
ApplicationType | String
---------------------------------------------------------------------------
Table 2: Applicants
---------------------------------------------------------------------------
Fields:
ApplicantID | Auto Generate ID
ApplicationID | passed from Table 1 (Applications) as a key
FirstName | String
LastName | String
Age | int
Comment | String
---------------------------------------------------------------------------
.Oracle DB Stored Procedure
---------------------------------------------------------------------------
Create a single stored procedure that can except from .Net in a SINGLE Transaction the application and the applicants' details. For each application there is multiple applicants . Stored procedure must make use of either Oracle “ref cursor” or “collections” to store multiple applicants against a single application in one .net call
---------------------------------------------------------------------------
.NET CODE
---------------------------------------------------------------------------
Generate the required code to pass to the stored procedure the required values
In your code use the 2 below data sample sets;
Data Set 01:
ApplicationType = “Coal”
Applicant1| FirstName: Mark, LastName: Smith, Age:55, Comment: I wasn’t sure
Applicant2| FirstName: James, LastName: Gate, Age:34, Comment: I want the "right" size land
Data Set 02 :
ApplicationType = “Petrol”
Applicant1| FirstName: Bill, LastName: Smith, Age:44, Comment: the first on the seen
Applicant2| FirstName: Oliver, LastName: webbing, Age:61, Comment: explore 1'st choice
Applicant3| FirstName: Bob, LastName: wong, Age:30, Comment: NULL or Empty String
Project ID: #13024273
About the project
12 freelancers are bidding on average $32 for this job
Hi, I have delivered many successful projects, having 6+ yr exp i can assure you of great quality and Good Work.
Hi I am .NET Developer and I have very good programming skills. I have more than 1 year of experience of developing application including web application and also desktop application. I have seen your project and I am More
DDear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have More
Hello, I'm 2 years experienced .NET developer worked with windows applications, web applications, web services, web apis. Also i have worked with database component like SQL server, Oracle 10g/11g. Kindly go through More
hey i am new here as my profile shows but i am web developer professionally and i am building my reputation here and i bid to only those projects which i think i can complete, thanks :)