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



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

Veja mais: types of software testing, the n and o, test scenarios, software test scenarios, software testing types, scenarios test, source code vs object code, software acceptance testing, methods engineering, all po, postgres, po file, insert, c code to retrive, build database sql, post batch, sql statement stored, php insert xml, send data form database php, insert php code form, insert form site, sql insert net, php post insert, class xml php, sql server database project

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

ID do Projeto: #3000412

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


See private message.

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

See private message.

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

See private message.

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

See private message.

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

See private message.

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

See private message.

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

See private message.

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