Bank Data Import Web App is responsible for Importing CSV file, Displaying imported data and providing a summary report on accounts transactions based on imported data.
- Features
- Technologies Used
- Getting Started
- Entity Framework Core Migrations
- Setting up Multiple Project Startup in Visual Studio 2022
- CSV Import into Database: Allows importing data from CSV files into the database for easy data migration.
- Bank Accounts List: Provides a list of bank accounts with relevant details.
- Transactions: Manages transactions associated with bank accounts.
- Bank Accounts Transactions Summary List: Presents a summary list of transactions for each bank account.
- MSSQL Data: Utilizes MS SQL Server to store and retrieve data from the database.
- Entity Framework Core: Integrates Entity Framework Core for database management.
- CQRS Patterns: Implements CQRS (Command Query Responsibility Segregation) patterns for better separation of concerns.
- MediatR Library: Uses MediatR library for handling queries and commands.
- .NET 6
- ASP.NET Core Web API
- Entity Framework Core
- MS SQL Server
- MediatR Library
- MudBlazor Library
- Blazor WebAssembly
- .NET 6 SDK
- MS SQL Server (or any other supported database server)
- Visual Studio 2022
- Clone the repository:
git clone https://github.com/DevJr14/Bank-Data-Import.git
- Navigate to the project directory:
cd Bank-Data-Import
- Restore dependencies:
dotnet restore
- Build the solution:
dotnet build
Ensure that you have MSSQL Server installed locally
- Update database server name inside
appsettings.json
orappsettings.Development.json
file.
To apply the Entity Framework Core migrations and create the database schema, follow these steps:
-
Go to Tools > Nuget Package Manager > Package Manager Console
-
Set WebApi project as a startup
-
Set Infrastructure as Default prohject on Package Manger Console 4 Run the following command to apply migrations:
update-database
and press enter -
This will apply any pending migrations and create the necessary database tables.
Note: Make sure you have configured the database connection string in the appsettings.json
or appsettings.Development.json
file.
To run both the Web API and the BankApp (Blazor WebAssembly) projects simultaneously during development, follow these steps:
- Open the solution in Visual Studio 2022.
- Right-click on the solution in the Solution Explorer and select "Configure Startup Projects".
- In the Dialog, click Multiple startup projects.
- Set the "Action" to "Start" for both the Web API project and the BankApp project.
- If required, set the order in which the projects should start (Web API first, then BankApp).
- Click the "Apply" button to save your changes, and then click "OK" to close the Solution Property Pages.
- Now, when you run the solution (press F5 or click the "Start" button), both the Web API and the BankApp will start simultaneously.
This setup is beneficial during development as it enables seamless testing and debugging of the integrated projects. When you run the solution, you'll have both the API and the Blazor application running concurrently, which can help you test how they interact with each other in real-time.