SQL Server Object Query

Avg Bid (USD)
Project Budget (USD)
$100 - $500

Project Description:
I have 27 business objects written in C# and 27 corresponding factory objects. I need the "retrieve" method written in each factory object such that given two business objects, the retrieve methods will query the SQL Server database and return an ArrayList containing the business objects that result from the query. The query will use the two objects passed in as templates for building the query string.

This requires SQL, and C#.

## Deliverables

The finished project should contain 27 methods for the 27 factory objects to retrieve collections of objects from the database. The initial objects will be provided (C# code and an SQL Database creation script). A finished project will consist of:

- Test harness showing retrieval of collections of each type of object.
- Wild card retrieval for each object attribute.
- Returning of collections of populated objects.
- Any database scripts used to create test data sets.

Code files will be provided upon further interest.
* * *This broadcast message was sent to all bidders on Wednesday Aug 13, 2008 2:12:49 PM:

Hello All, I have posted a .zip archive with a sample Visual Studio 2008 project and all files associated with the project. The method that will be worked on is the "Create" method in all factory objects located in the KAP_Persist directory. The archive also contains a SQL Server database creation script called KAP_Create.SQL for the database schema and a .rtf file called WildCardSearches.rtf where I list the business object attributes on which wild card searches will be done. Look over this information. This is a small piece of a larger project. Good work will likely lead to future contracts. Thanks! Jim
* * *This broadcast message was sent to all bidders on Wednesday Aug 13, 2008 2:41:45 PM:

Hello All, Sorry for the miscommunication. The method to consider in the factory objects is not the "Create" method, but the "retrieve" method. Thanks to Sergey for catching this. Cheers, Jim

Skills required:
Engineering, Linux, Microsoft, MySQL, PHP, Software Architecture, Software Testing, UNIX, Windows Desktop
Additional Files: zRAC_DOC_NameCryptedToProtectYourPrivacy_X20088131422511063667750288034323087623427254441513120613816871286840KAPRetrievalTest.zip
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.