Entity Framework Showcase

Enhanced the entity framework based backend api of real-time parcel tracking system to handle diverse user inputs and pass them efficiently to SQL Server.

• Created new api endpoints to allow users to submit proof of delivery, which is then stored securely in the sql server database.
• Enhanced the entity framework based backend to support additional user inputs and new delivery workflow scenarios.
• Optimized database interactions by improving entity framework queries for faster data retrieval and updates.
  • Using linq skip and take methods to ensure only necessary data is retrieved from the database, improving performance and efficiency.
• Collaborated with frontend developers to align api request and streamline data flow between the client app and backend.
  • Worked with frontend developers to define pagination requirements, ensuring the backend API returns precise and optimized data sets aligned with the UI needs.

Enhanced the entity framework based backend api for the house of multiple occupancy website to handle user subscriptions and provide secure document links related to the service.

• Implemented secure document delivery by generating time limited links for users to access service related documents safely.
• Created new api endpoints to handle subscription creation, renewal, and cancellation, using entity framework to interact with sql server.
• Optimized database interactions by improving entity framework queries for faster data retrieval and updates.
• Contributed to frontend code to connect the api endpoints with interactive UI elements for a smooth user experience.

Developed a dynamic player list page that retrieves and displays data using entity framework core.

• Implemented data access using entity framework core to retrieve players from the statistics database.
• Designed linq queries to filter players by their positions such as forward, midfielder, defender, and goalkeeper.
• Developed a responsive player table in blazor that dynamically updates based on the selected position filter.
• Ensured efficient data retrieval through eager loading and optimized entity relationships.

Developed a dynamic standing table page that retrieves and displays data using entity framework core.

• Implemented data access using entity framework core to retrieve table information from the statistics database.
• Integrated api driven data retrieval to seamlessly fetch and display league standings.
• Developed a responsive standing table design in blazor that dynamically updates based on the selected league.
• Ensured efficient data retrieval through eager loading and optimized entity relationships.

Developed an interactive memory card game using angular, demonstrating typeScript, entity framework and api integration.

• Implemented dynamic game logic including card shuffling, match detection, move counting, scoring, and win condition handling.
• Designed responsive and animated user interface interactions such as card flip effects, game timers, and user feedback using css and angular bindings.
• Applied clean code principles and separation of concerns by organising services, models, and components for maintainability and scalability.
• Implemented game record access using entity framework core to retrieve information from database.