.NET 7 features

.NET 7 is so versatile that you can build any app on any platform.

Let’s highlight some scenarios that you can achieve with .NET starting today:

• Call an existing .NET library from React code running in the browser by including a streamlined .NET runtime optimized to run on WebAssembly.
• Access the contents of a JSON document stored in your SQL Server database using strongly-typed C#.
• Rapidly build and deploy a secure REST endpoint auto-documented with OpenAPI by writing just a few lines of code.
• Generate a streamlined native app using Ahead of Time (AOT) compilation from C# source and publish directly to a container image.
• Run a .NET Core app that uses built-in APIs to compress and archive content into a Linux-friendly tar.gz file.
• Materialize your vision for a mobile app on Android, iOS, and Windows using a single codebase and design that creates native code and components for each target platform.
• Reap the performance benefits of .NET 7 by automatically migrating your legacy apps using the upgrade assistant and modernize your Windows Communication Foundation (WCF) web services with the help of CoreWCF.
• Make it easier than ever for developers to kickstart new applications using boilerplate templates that reflect your architecture and design choices.
• Handle key combination and modifier keys better in Unix/Linux with Console.ReadKey.

What’s new in .NET 7

.NET 7 releases in conjunction with several other products, libraries, and platforms that include:

• ASP.NET Core 7
• Entity Framework Core 7
• .NET MAUI
• Windows Forms
• WPF
• Orleans 7

In this blog post, we’ll highlight the major themes the .NET Teams focused on delivering:

• Unified
  • One BCL
  • New TFMs
  • Native support for ARM64
  • Enhanced .NET support on Linux
• Modern
  • Continued performance improvements
  • Developer productivity enhancements, like container-first workflows
  • Build cross-platform mobile and desktop apps from same codebase
• .NET is for cloud-native apps
  • Easy to build and deploy distributed cloud native apps
• Simple
  • Simplify and write less code with C# 11
  • HTTP/3 and minimal APIs improvements for cloud native apps
• Performance
  • Numerous perf improvements

.NET 7 is Available!!

Download .NET 7 today!

.NET 7 brings your apps increased performance and new features for C# 11/F# 7, .NET MAUI, ASP.NET Core/Blazor, Web APIs, WinForms, WPF and more. With .NET 7, you can also easily containerize your .NET 7 projects, set up CI/CD workflows in GitHub actions, and achieve cloud-native observability.

Thanks to the open-source .NET community for your numerous contributions that helped shape this .NET 7 release. 28k contributions made by over 8900 contributors throughout the .NET 7 release!

.NET remains one of the fastest, most loved, and trusted platforms with an expansive .NET package ecosystem that includes over 330,000 packages.

Download and Upgrade

You can download the free .NET 7 release today for Windows, macOS, and Linux.

• Installers and binaries
• Container images
• Linux packages
• Release notes
• Breaking changes
• Known issues
• GitHub issue tracker

.NET 7 provides a straightforward upgrade if you’re on a .NET Core version and several compelling reasons to migrate if you’re currently maintaining a .NET Framework version.

Visual Studio 2022 17.4 is also available today. Developing .NET 7 in Visual Studio 2022 gives developers best-in-class productivity tooling. To find out what’s new in Visual Studio 2022, check out the Visual Studio 2022 blogs.

How to check active transactions in SQL Server

A transaction is a single unit of work. If a transaction is successful, all of the data modifications made during the transaction are committed and become a permanent part of the database.

Some times, if there are any issues we will get into this deadlock stage and we don't get any responses from database. In those cases, if you want know what are active connections going on at that point of time, will help identifying issue.

if you want to know more details about active sessions like session ID, Host Name, Login Name, Transaction ID, Transaction Name, Transaction Begin Time,Database ID,Database Name etc.

Use the below query for details,

SELECT
trans.session_id AS [SESSION ID],
execSession.host_name AS [HOST NAME],login_name AS [Login NAME],
trans.transaction_id AS [TRANSACTION ID],
tas.name AS [TRANSACTION NAME],tas.transaction_begin_time AS [TRANSACTION 
BEGIN TIME],
tds.database_id AS [DATABASE ID],DBs.name AS [DATABASE NAME]
FROM sys.dm_tran_active_transactions tas
JOIN sys.dm_tran_session_transactions trans
ON (trans.transaction_id=tas.transaction_id)
LEFT OUTER JOIN sys.dm_tran_database_transactions tds
ON (tas.transaction_id = tds.transaction_id )
LEFT OUTER JOIN sys.databases AS DBs
ON tds.database_id = DBs.database_id
LEFT OUTER JOIN sys.dm_exec_sessions AS execSession
ON trans.session_id = execSession.session_id
WHERE execSession.session_id IS NOT NULL