paillave / Etl.Net

Mass processing data with a complete ETL for .net developers
https://paillave.github.io/Etl.Net/
MIT License
668 stars 92 forks source link

handle null values in sql queries #440

Closed FrancisGauthier closed 1 year ago

FrancisGauthier commented 1 year ago

Issue when querying an sql database with null values. If any columns has null, then an exception "Could not cast DbNull to object" raises.

Added a DbNull check to return null. if not, the actual value.

paillave commented 1 year ago

Thanks for the contribution @FrancisGauthier