Name

Titus

Usage

Read Huge Data From Ecxel (like 500,000 Rows that use in Project) And Insert To Database.

Summery

Read Excel File And Check Dublicated Value And Insert Values to Redis In Program.cs ,
Read again from Redis and Insert to SQL With Fastest Performance.

Steps

1. Open Excel Stream and Read Data.
   
2. Validate Data and Insert Data In Redis.
   
3. Read Data From Redis.
   
4. Insert Data In SQL.
   

About

An Cosole Application built with .Net 5 with 2 ClassLibrary (3 Layer (Core, Domain, Service)).

Repository Pattern For EF DbContext and Redis Wrapper in Core Layer,
Models In Domain,
Services and Distributed CacheManager Methods Implemention In Service Layer,
Unit Tests with Moq Repository and Fake Services for Test Domain Services In UnitTest

Built With

• .Net
• Entityframework Core

Redis

• StackExchangeRedis

Working with Excel:

• EPPluse

Unit Test:

• Moq
• NUnit