Announcing Entity Framework Core (EFCore) 5.0 RC1
Today, the Entity Framework Core team announces the first release candidate (RC1) of EF Core 5.0. This is a feature complete release candidate of EF Core 5.0 and ships with a "go live" license. You are supported using it in production. This is a great opportunity to start using EF Core 5.0 early while there is still time to fix remaining issues. We're looking for reports of any remaining critical bugs that should be fixed before the final release.
Executing raw SQL with Entity Framework Core 5
Entity Framework Core 5 is an open-source, lightweight, extensible, and a cross-platform ORM. It is easy to apply and it makes database access super simple. However, sometimes working with tables and views is just not enough. How to execute raw SQL script with Entity Framework Core 5? Let’s find out.
Is Entity Framework Core Quicker than Dapper?
I want to see if Entity Framework Core has features that would make it quicker than Dapper. Now, I've always used Entity Framework over Dapper, so I'm likely to be more biased in the former. However, it would take me some convincing to switch from Entity Framework to Dapper.
Working with views in Entity Framework Core 5
In SQL, a view is a virtual table based on the result-set of an SQL statement. They are typically used as read-only objects that are optimized to provide data for a given scenario. Entity Framework Core 5 can handle views and in this article, I’m going to show you how.
Announcing Entity Framework Core (EF Core) 5.0 Preview 8
Today, the Entity Framework Core team announces the eighth and final preview release of EF Core 5.0. The next release will be a release candidate (RC). This release includes table-per-type (TPT) mapping, table-valued functions, SQLite table rebuilds for migrations and much more.
How to generate PostgreSQL UUID with EF Core
There are number of options to use for ID fields in PostgreSQL each one of them have valid use cases of when to use or not use them. I won’t go into detail of the pro’s and cons of using which approach, because ultimately that is a debate for another time and place. In my particular case, I needed to create a table that made use of UUID ( Universally Unique Identifiers), which is an identifier with a 128-bit quantity generated by an algorithm chosen to make it very unlikely that the same identifier will be generated by anyone else in the known universe using the same algorithm.
如何在 EF Core 3.1 的模型驗證方法中注入 ServiceCollection 中的服務
由於 .NET Core 大量的使用 DI 技術，所有註冊到 DI 容器(ServiceCollection)的服務，幾乎都可以用「注入」的方式取得物件。只不過有些類別不容易用建構式注入的方式取得服務，這篇文章將分享如何在 EF Core 3.1 的模型驗證方法中注入 ServiceCollection 裡的任何服務。
How to call stored procedures with OUTPUT parameters with FromSqlRaw in EF Core
In this post I will show how you can call stored procedures with OUTPUT parameters from EF Core. I am using the Northwind database for the sample code.
Merging migrations in Entity Framework Core 5
When working with a fast-evolving project changes happen rapidly not only to the project’s code but also to the database schema. It happens especially when working on a micro-service from the start when its purpose shifts.
Announcing Entity Framework Core EF Core 5.0 Preview 7
Today, the Entity Framework Core team announces the seventh preview release of EF Core 5.0. This release includes a factory to create DbContext instances, the ability to reset DbContext state, Cosmos DB improvements including enhanced support for configuration options and partition keys, and much more.
Adding Entity Framework Core 5 migrations to .NET 5 project
Database migrations help a developer to keep database schema up-to-date with the code. It is a core mechanism, that keeps changes in code and applies them in the database. Entity Framework Core 5 migrations are designed to keep track of DbContext class and generate migrations when you update it.
EF Core In depth – Tips and techniques for configuring EF Core
This article is being more efficient at configuring your EF Core DbContext that runs fast and safe. As a working freelance developer, I’m always looking for ways to make me a more efficient/faster developer. While configuring a DbContext is really important there can be a lot of configuration code, but over the years I have found ways to minimise or automate much of the EF Core configurations. This article pulls together lots of configuration approaches I have learnt working with EF Core, and EF6 before that.
Adding an Entity Framework Core 5 to an existing database
Entity Framework Core 5 is a light and easy to use ORM, that let you use the database without writing any SQL commands. Built-in mechanisms will translate your LINQ queries on your entity classes to SQL queries and return mapped objects. Here is an article about adding EF Core with migrations to an empty database: PrimeHotel – adding Entity Framework Core 5 in .NET
Add Custom Database Functions For Entity Framework Core
Object Relational Mappers (ORMs) are great tools for abstracting our database choice away and allowing us to get things done. As time goes on and our applications evolve, we realize the underlying database can get things done faster and more efficiently. Not just that, we will notice features that can help us deliver value to our end users in new and exciting ways. I’m here to tell you that we can continue to use LINQ and utilize database functions together. In this post, we’ll see how we can configure Entity Framework Core (EF Core) to recognize existing database functions and also our custom database functions.
Announcing Entity Framework Core EFCore 5.0 Preview 6
Today, the Entity Framework Core team announces the sixth preview release of EF Core 5.0. This release includes split queries for related collections, a new “index” attribute, improved exceptions related to query translations, IP address mapping, exposing transaction id for correlation, and much more.
深入理解 EF Core：EF Core 写入数据时发生了什么？
这是深入理解 EF Core 系列的第二篇文章。第一篇是关于 EF Core 如何从数据库读取数据的；而这一篇是关于 EF Core 如何向数据库写入数据的。这是四种数据库操作 CRUD（新增、读取、更新和删除）中的 CUD 部分。我假设你对 EF Core 已经有了一定的认识，但在深入学习之前，我们先来了解一下如何使用 EF Core，以确保我们已经掌握了一些基本知识。这是一个“深入研究”的课题，所以我准备大量的技术细节，希望我的描述方式你能理解。
深入理解 EF Core：EF Core 读取数据时发生了什么？
本文将为你详细描绘 EF Core 从数据库中读取数据的“幕后”视图。我将揭开两种数据库读取方式的面纱：一个是普通的查询，另一个是使用 AsNoTracking 方法的非跟踪查询。我还将通过一个实验来演示我是如何解决我的一个客户遇到的性能问题。
Announcing Entity Framework Core 5.0 Preview 5
Today we are announcing the fifth preview release of EF Core 5.0. The fifth previews of .NET 5 and ASP.NET Core 5.0 are also available now.
Announcing Entity Framework Core 5.0 Preview 4
Today we are excited to announce the fourth preview release of Entity Framework Core (EF Core) 5.0. The fourth previews of .NET 5 and ASP.NET Core 5.0 are also available now. Be sure to check out the full release of Blazor WebAssembly 3.2.0!
Using PredicateBuilder with EF Core for Complex Queries
In a perfect world, all of your EF Queries will be simplistic and not require complex logic, and the EF system itself will generate high-quality & performant queries in the process. Sadly, this utopia doesn't exist; however, tools are available, including PredicateBuilder that makes things work well...