Encerrado

database insert and retrive

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

Habilidades: Programação C#, Administração de Bancos de Dados, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: types software testing, test scenarios, software test scenarios, software testing types, scenarios test, software acceptance testing, methods engineering, all po, postgres, po file, insert, code retrive, build database sql, post batch, sql statement stored, php insert xml, insert php code form, insert form site, sql insert net, php post insert, sql server database project, insert sql, net response xml, write xml sql database, batch file post

Acerca do Empregador:
( 392 comentários ) United States

ID do Projeto: #3000412

7 freelancers estão ofertando em média $200 para este trabalho

ExpertFromInd

See private message.

$127.5 USD in 5 dias
(48 Comentários)
5.4
zdcodinginc

See private message.

$85 USD in 5 dias
(24 Comentários)
4.5
cybettechltd

See private message.

$425 USD in 5 dias
(1 Comentário)
3.9
minditvw

See private message.

$85 USD in 5 dias
(5 Comentários)
3.6
mysticsvw

See private message.

$170 USD in 5 dias
(3 Comentários)
3.5
themylab

See private message.

$340 USD in 5 dias
(9 Comentários)
3.3
sunonevw

See private message.

$170 USD in 5 dias
(0 Comentários)
0.0