SQL Server to C# data type mapping

SQL-CLR Type Mapping

Data type conversion (Database Engine)

Implicit and explicit conversion

Reference link :- https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-type-conversion-database-engine?view=sql-server-ver15

Mapping Run-time Behavior Matrix

Reference link :- https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/sql-clr-type-mapping