Entity Framework Core での C# と MySQL の型の対応表

環境

対象	version
dotnet	6.0.200
Pomelo.EntityFrameworkCore.MySql	6.0.1
MySQL	8.0.28

C#とMySQLの型の対応表

C#	MySQL
bool	tinyint(1)
byte	tinyint unsigned
char	varchar(1) CHARACTER SET utf8mb4
short	smallint
ushort	smallint unsigned
int	int
uint	int unsigned
long	bigint
unlong	bigint unsigned
string	longtext CHARACTER SET utf8mb4
DateTime	datetime(6)
DateTimeOffset	datetime(6)
TimeSpan	time(6)
Guid	char(36) COLLATE ascii_general_ci
Uri	longtext CHARACTER SET utf8mb4
IPAddress	varchar(45) CHARACTER SET utf8mb4
enum	int
byte[]	longblob