SQL Server Object Query

Closed

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 [url removed, login to view] for the database schema and a .rtf file called [url removed, login to view] 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: Engineering, Linux, Microsoft, MySQL, PHP, Software Architecture, Software Testing, UNIX, Windows Desktop

See more: test data creation, sql database business, project contracts templates, business studio 3, small business server 2008, server studio, php is object, wild code, visual lead, test sql server, sql server, sql server scripts, sql server c, sql server c# 2008, sql business, sql and c, small business server, query creation, object, harness, data query, c sql server, business objects, business object, windows broadcast server

Project ID: #3128968

Awarded to:

BearInUA

See private message.

$102 USD in 20 days
(15 Reviews)
4.3

7 freelancers are bidding on average $302 for this job

jacobdd1

See private message.

$425 USD in 20 days
(271 Reviews)
7.1
softncode

See private message.

$425 USD in 20 days
(67 Reviews)
6.0
suryavijayvw

See private message.

$425 USD in 20 days
(120 Reviews)
5.6
pbalamurali

See private message.

$102 USD in 20 days
(24 Reviews)
4.6
consult2day

See private message.

$425 USD in 20 days
(17 Reviews)
3.9
nsbandara

See private message.

$212.5 USD in 20 days
(0 Reviews)
0.0