We are looking for a small asp.net control and 2 classes for the DB interaction for storing, updating simple key value pairs in a table. Very little oracle knowledge is required, only to write a few straightforward queries
The table roughly speaking has the columns
the Id is gnerated from a sequence in Oracle i.e. equivalent to an autoincrement
Project,Namespace,Category,SubCategory are hierarchical so subcategory is UNDER Category which is under Namespace which is under project
For the combination Project,Namespace,Category,SubCategory : we then have a dickey,dicvalue pairs
so by select all matching Project,Namespace,Category,SubCategory I obtain a set of key /values
I will provide the schema for the table.
We also need a .net control which roughly speaking allow us to add value into the table. The detailed description is attached.
HEllo, as some questions came up here are a few clarifications:
Note: proper DbParameters with placeholders need to be used in the queries else the special characters don't work!!, not just sql, this is standard, also the value column is stored as a Clob since the text can be long, it needs to be converted to and from string, but this should not pose any problems there is a standard Oracle function for this and code on the internet.
The job MUST be done in C#, I forgot to mention this, NOT VB.NET!
16 freelancers are bidding on average $184 for this job
iAm currently working on project that involves transanction between oracle and vb.net 2008 I am familiar with this environment. I may be new but I know how to do it please allow me to finish the task.