We are trying to create a methodology by which you can send in generic data structures ( via xml or something similar to the .NET data type accompanying this request ) that will do the following:
- Read the contents of the data type or serialized xml to determine what table the data should be executed against. If the table is not present, it should read the data from the data type and dynamically create the table.
- Perform the requested action by reading the data in from the type and forming up the sql to execute.
This is a proof of concept application. Start with very simple tables and data, then we will work into more complex issues and problems as we go ( i.e. foreign keys, etc. and how best to represent ). The initial phase is just to validate the concept and uncover any issues that we might have in moving ahead.
You will be responsible for:
- Building out the concept data types to meet the initial phase requirements.
- Developing the code to interrogate the data types to build up the sql and execute it, check for table existence, etc.
- Writing NUNit unit tests to demonstrate the application functioning in the following areas: Creating tables that do not exist yet, inserting data, updating data, deleting data, etc.
Part of your bid should be to describe how you might go about solving this problem.
Expect multiple revisions as we work thru the issues involved.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Fully functioning [login to view URL] code library project with any setup instructions.
## Platform
.NET 1.1.
[login to view URL] 2003
SQL Server 2000