DatabaseFilters Project

DatabaseFilters is a repository that leverages the System.Linq.Dynamic.Core package to apply powerful filtering, searching, sorting, and pagination functionality to any query or returning model in Entity Framework Core. This project is built using cutting-edge technologies and tools, including:

1. .NET 7: The backend of the project is developed using .NET 7, which provides the latest features and enhancements for building robust and scalable applications.

2. MySQL: The project utilizes MySQL as its database management system, ensuring data persistence, reliability, and performance.

3. Angular 15: The frontend of the application is developed using Angular 15, a powerful and popular framework for building dynamic and responsive web applications.

Demo

dbfilters.mp4

Getting Started

To run this project, follow these steps:

1. Import Database Schema: Import the db.sql file provided in 'EmployeeAPI into your MySQL database. Make sure to configure the database connection details in theappsettings.json` file.

2. Run .NET API: Start the .NET API by running the dotnet run command. Ensure that the API can connect to your MySQL database.

3. Launch Angular Application: Run the Angular application to interact with the API and explore the powerful filtering and data manipulation features.

Key Features

• Dynamic Filtering: The project allows you to dynamically filter data in your Entity Framework Core queries, making it easy to retrieve specific records based on various criteria.

• Search Functionality: You can implement advanced search functionality to find data quickly, enhancing the user experience.

• Sorting Capabilities: Easily sort your query results by one or more columns, providing flexibility in presenting data to users.

• Pagination: Implement pagination to manage large datasets efficiently, ensuring optimal performance.