SQL to .NET and EF Core type map

Search common SQL Server and PostgreSQL types and see the corresponding CLR and EF Core guidance.

Quick answer: This browser-based type map connects SQL Server and PostgreSQL column types to C# and EF Core choices, including dates, decimals, GUIDs, JSON and concurrency tokens.

Runs privately in your browser

SQL Server PostgreSQL .NET Type Map

Search common SQL Server and PostgreSQL types and see the corresponding CLR and EF Core guidance.

Search SQL Server, PostgreSQL, CLR or EF Core types

Type mappings—

SQL Server	PostgreSQL	.NET	EF Core	Note

How to use this tool

Step 1Search by database type, PostgreSQL type, CLR type or EF Core method.

Step 2Compare the provider differences and read the note for precision or compatibility concerns.

Step 3Confirm the mapping against your provider version and migration tests.

Why this is useful for .NET teams

DeveloperHA provides remote / worldwide support from a senior software engineer with 15+ years of experience across enterprise software, healthcare, finance, e-commerce and business automation, with a focus on .NET backend architecture, distributed systems, AWS, Kubernetes and platform modernization. This tool is designed to shorten the path from a development problem to a clear, reviewable implementation.

Frequently asked questions

Does this generate a database migration?

No. It is a reference map for design and review; migrations should be tested against the actual provider.

What type should I use for money?

The map points toward decimal rather than floating-point types, but precision and scale still need an explicit domain decision.

Does PostgreSQL map exactly like SQL Server?

No. The table highlights common differences such as uuid, timestamptz, numeric and jsonb.

Related developer tools

Learn the related concept

Need help beyond the tool?

Bring the problem to a senior .NET engineer through a fixed-price audit, MVP sprint or ongoing partnership.

See packages Start a conversation