FETCH DATA

Fetch Data is a web service for fetching data from Oracle and PostgreSQL database with use of EFCore.

Report Bug · Request Feature

Table of Contents

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

About The Project

FetchData is a small ASP.NET Core service for fetching data from Oracle 11g and PostgreSQL databases. In project there is implemented connection to database with use of EF Core. Clean Architecture with CQRS + MediatR is used as architecture of the project.

Used Technologies

• ASP.NET Core 3.1
• PostgreSQL
• Oracle
• Entity Framework Core
• MediatR
• FluentValidation
• Swashbuckle

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 appsettings.json the data needed for database connection:

  "ConnectionStrings": {
    "PostgresConnectionString": "yourPostgresConnectionString",
    "OracleConnectionString": "yourOracleConnectionString"
  }

• To have it working with your model you need to create appropriate model, view model, controller and service basing on my models.
• Run application
• To access SwaggerUI fire up your browser and open url https://localhost:5001
• To use other programs i.e. POSTMAN use url https://localhost:5001/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/FetchData