JSON columns

• Introduce common patterns for JSON support that can be implemented by any database provider.
• JSON column support will be implemented for SQL Server and SQLite. (Note that the PostgreSQL and MySQL providers already support JSON columns.) 

.NET 6 will reach end of support on Nov 12, 2024. After that, Microsoft will no longer provide updates for .NET 6. Security fixes and technical support will no longer be available for .NET 6. You’ll need to update to .NET 8 before this date to stay supported.

.NET 6 Preview 1 is now available and ready for evaluation. This is the first preview of .NET 6, the next major update to the .NET platform. .NET 6 is expected to ship in November of this year, and will be a Long Term Support (LTS) release. 

For .NET 6, we plan to no longer perform any form of harvesting to ensure that all assets we ship can be serviced. This means we're dropping anything older than:

• .NET Framework 4.6.1
• .NET Core 3.1
• .NET Standard 2.0 

C#6 will support null propagation (https://github.com/dotnet/roslyn/wiki/Languages-features-in-C%23-6-and-VB-14). Result.OrDefault is simple null propagation for pre-C#6. 

JavaScript Object Notation (JSON) is a subset of the JavaScript language used for the definition and exchange of data. While I’m not proposing that we create a similar standard using C#, I do want to illustrate some of the rich object initialization syntax of the language.

Today, the Entity Framework Core team announces the first preview release of EF Core 6.0. This release includes new attributes, built-in functions, and database-specific improvements to SQLite and SQL Server capabilities. 

A few highlights for this release include:

• Support for 64-bit identity seed values
• Support for new BCL DateOnly and TimeOnly structs for SQLite
• Uniquify and validate check constraint names
• Pre-convention model configuration 

• Added support for .NET 6.0. #1704
• Added support for DateOnly and TimeOnly for SqlParameter value and GetFieldValue. #1813
• Added support for TLS 1.3 on .NET Core and native SNI. #1821
• Added ServerCertificate setting for Encrypt=Mandatory or Encrypt=Strict. #1822 Read more
• Added Windows ARM64 support when targeting .NET Framework. #1828  

Downloads

1. Includes the .NET Runtime and ASP.NET Core Runtime
2. For hosting stand-alone apps on Windows Servers. Includes the ASP.NET Core Module for IIS and can be installed separately on servers without installing .NET Runtime.