JeffreyGaydos / music-database-generator

An idea to help organize your music with extra metadata using a SQL Server Database. This repository searches through a folder and gathers metadata already in mp3 files to add to a database
2 stars 1 forks source link

Validate Input Data According to SQL Types and Ignore if Invalid #24

Closed JeffreyGaydos closed 11 months ago

JeffreyGaydos commented 11 months ago

Since we can't be 100% certain what kind of data we will find in mp3 files, we should validate what is found before using EF to insert it. If inserting the data would violate any constraints in the SQL, we should ignore that data and insert some empty/default value.