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

C# Programming Database Administration Engineering MySQL PHP Software Architecture Software Testing SQL

Project ID: #3000412

About the project