database insert and retrive

已关闭 已发布的 Nov 1, 2003 货到付款
已关闭 货到付款

Modification: due to the state of the postgres driver in .NET, this project can be done, without stored procedures, against SQL Server.

This project is to create a class that saves and retrieves items from a postgres database in c#. Attached is the data types (c# source file) as well as the XML Schema generated from the objects (look at pricing response and relationships - expand in [url removed, login to view]).

Specifically, the deliverables for this project are:

- database ddl

- class that has the following methods

o void InsertPricingResponse(PricingResponse pr);

o void AddPlanOffer(string pricingResponseGuid, PlanOffer po);

o PricingResponse GetPricingResponse(string guid)

o PlanOffer GetPlanOffer(string guid)

o PricingResponse GetPricingResponse(OrderDetails order); (returns a pricing response that is filtered by the id’s that are represented by the order details object which contains a number of ID’s)

- Create a test class that shows insertion and retrieval of objects as an nunit test cases. These tests should include testing both success and failure scenarios.

This project should take about the following timeframes for an experienced person:

- create and review ddl: 2 hours

- write insertion and retrieval methods: 4 hours

- nunit tests: 2 hours

- updates (post delivery): 2-5 hours

The code needs to be written for the efficiency of inserting and retrieving data. When inserting data, the code should build up a batch of sql and send the entire set of insert statements to the database at once. When retrieving data, all data should be retrieved in one statement (or in as few as possible).

(see table list - could be subject to change)

More details are available upon project acceptance

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

c#

postgres

C# 编程 数据库管理 工程 MySQL PHP 软件构架 软件测试 SQL

项目ID: #3000412

关于项目

7个方案 远程项目 活跃的Nov 12, 2003

有7名威客正在参与此工作的竞标,均价$200/小时

ExpertFromInd

See private message.

$127.5 USD 在5天内
(48条评论)
5.4
zdcodinginc

See private message.

$85 USD 在5天内
(24条评论)
4.5
cybettechltd

See private message.

$425 USD 在5天内
(1条评论)
3.9
minditvw

See private message.

$85 USD 在5天内
(5条评论)
3.6
mysticsvw

See private message.

$170 USD 在5天内
(3条评论)
3.5
themylab

See private message.

$340 USD 在5天内
(9条评论)
3.3
sunonevw

See private message.

$170 USD 在5天内
(0条评论)
0.0