Oracle Data Fetch

Oracle Data Fetch is a small web service for fetching data from old Oracle 10g database with use of ODP.NET.

Report Bug · Request Feature

Table of Contents

• About the Project
• Used Technologies
• Getting Started
• Contributing
• Contact

About The Project

Oracle Data Fetch is a small Web API 2 service for fetching data from old, obsolate Oracle 10g database where cannot be used EF. In project there is implemented connection to database with use of ODP.NET. To encapsulate the logic required to access data source the Repository pattern is used.

Used Technologies

• ASP.NET MVC v5.1.0.0
• ASP.NET Web API 2
• ODP.NET
• Autofac
• AutoMapper
• Swagger

Getting Started

To get a local copy up and running follow these simple steps:

• Download the latest stable version from the download tab and unzip it to your folder
• Open the solution in Visual Studio 2019.
• Build the solution to install Nuget packages.
• Change in web project in Web.config the data needed for database connection:

  <connectionStrings>
    <add name="OracleDb" connectionString="yourConnectionString"/>
  </connectionStrings>

  <appSettings>
    <add key="yourTableNameId" value="yourTableName"/>
  </appSettings>

• To have it working with your model you need to create appropriate model, view model, controller, service and repository basing on my Cushion model.
• Run application
• To access SwaggerUI fire up your browser and open url https://localhost:44351/swagger
• To use other programs i.e. POSTMAN use url https://localhost:44351/api/[PrefixOfYourController]. In my case for list of all items use https://localhost:44351/api/cushions and for details for example https://localhost:44351/api/cushions/1/O
• Enjoy ;-)

Contributing

Contributions are what make the open source community such an amazing place to be learn, inspire, and create. Any contributions you make are greatly appreciated.

1. 🍴 Fork the Project
2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
3. Commit your Changes (git commit -m 'Add some AmazingFeature')
4. Push to the Branch (git push origin feature/AmazingFeature)
5. 🔃 Open a Pull Request

Contact

Mateusz Donhefner

Project Link: https://github.com/matdon90/OracleDataFetch