Descriptions

A developer must be able to pass the correct PostgreSql DB Type. Let us say the user would like to make sure the the column Customer.ExtraInfo below is passed as a NpgsqlDbType.Json type.

public class Customer
{
	public int Id { get; set; }
	...
	[NpgsqlTypeMap(NpgsqlDbType.Json)]
	public string ExtraInfo { get; set; }
}

If ever the user set the value of DbType, it is still not colliding.

As per Shay (the author of Npgsql library), this setting must be explicitly set as Npgsql is using the NpgsqlDbType property instead (over DbType).

Extent of the changes

The changes must be happened in RepoDb.PostgreSql and RepoDb.Core only.

Assessment: Minor

Acceptance Criteria

All existing Integration Tests and Unit Tests must be passed for all libraries and extensions.