Problem Today, data is considered the lifeline of most businesses, no matter how small or large the operation. While a plethora of relational database management systems are available, Microsoft SQL Server, a proprietary database system, is preferred over other relational…
Learn about SQL Server error handling using TRY CATCH, RAISERROR, and THROW for stored procedures, triggers, and user-defined functions.
Learn how to capture errors in SQL Server stored procedures and gracefully handle errors using Try Catch coding in your stored procedures.
In this article we look at how to use error handling in your SQL Server code by using Try Catch statements.
This article provides an overview of the new features and enhancements in Entity Framework Core 3.0 with code examples to explain the concepts.
This article presents a discussion on how Entity Framework Core can be used to log data in ASP.NET Core.
This covers eager loading in Entity Framework Core to load all related data from the database as part of the initial query.
In this article we look at how to handle complex data in disconnected scenarios using the TrackGraph method in Entity Framework Core EF Core.
In this article we look at how to use Query Types when working with Entity Framework Core.
In this article we look at how to run SQL Server queries with Entity Framework Core using the DbSet.FromSql method, parameterized queries, stored procedures and using the Database.ExecuteSqlCommand property.
This article presents a discussion on how we can create an Entity Data Model using the Database First approach in Entity Framework Core.
In this tip we look at how to handle SQL Server database concurrency issues using Entity Framework Core for both pessimistic and optimistic concurrency.