InfoQ Homepage ADO.NET Content on InfoQ
-
Microsoft Claims Entity Framework Core 7 Faster When Saving Changes
Entity Framework (EF) Core, Microsoft's object-to-database mapper library for .NET Framework, brings performance improvements for data updates in version 7, Microsoft claims. The performance of SaveChanges method in EF7 is up to 74% faster than in EF6, in some scenarios.
-
PostgreSQL 14 Breaks the .NET and Java Drivers for PostgreSQL
In some circumstances, the new syntax in PostgreSQL 14 will break its official .NET and Java database driver, specifically, when using to create a SQL function using BEGIN ATOMIC ... END. If you are not modifying your database schema via Npgsql or PgJDBC, there’s no need to worry.
-
Database Command Batching in .NET 6
.NET 6 adds the ability for ADO.NET database drivers to support efficient command batching using native protocols.
-
Large Collection Performance in Entity Framework and EF Core
Entity Framework Core offers significant performance improvements over Entity Framework 6. As this article shows, none are so readily apparent as when dealing with large collections.
-
40 Breaking Changes in EF Core 3
In an attempt to correct many perceived deficiencies in Entity Framework Core, Microsoft is introducing 40 breaking changes to EF Core 3.
-
EF Core: Unifying SQL and NoSQL Databases
One of the original goals of EF Core was to develop a model wherein both SQL and NoSQL style databases could be used with little or no change to the code. Microsoft is taking the first steps towards that goal with an experimental EF provider for Azure Cosmos DB.
-
EF Core 2.1 Roadmap: Views, Group By, and Lazy Loading
Entity Framework Core continues to make progress towards catching up with the original Entity Framework. On the roadmap for EF Core 2.1 are features such as views, group by, and lazy loading.
-
Highlights for the Upcoming .NET Framework 4.7.2
Though most of the attention is on .NET Core, development continues on the original .NET Framework. Microsoft has recently released a preview of .NET Framework 4.7.2 with updates to ASP.NET, ADO.NET, WCF, WPF, and even Windows Forms.
-
String Interpolation in Entity Framework Raises Concerns
One of the new features in Entity Framework Core 2 is the ability to automatically convert interpolated strings into parameterized SQL. Though designed to avoid problems with poorly written SQL, it is feared that it may actually lead to more SQL injection attacks.
-
Breaking Changes in EF Core 2.0
EF Core brings with it many breaking changes, including rendering all of the database providers for EF Core 1.0/1.1 unusable in EF Core 2.0.
-
New Features in Entity Framework Core 2.0
While the EF Core 2.0 release deserves a lot of criticism, there are also a lot of things to like about it. In this article we touch on some of the highlights from this release including a safe way to use string interpolation with raw SQL.
-
Entity Framework Core 2.0 Released to Heavy Criticism
Entity Framework has always had a mixed reputation, with some developers loving it while other compared it unfavorably to NHiberante, LINQ-to-SQL, and the various micro-ORMs. But the early impressions of EF Core have been particularly bad and continue to frustrate even those who appreciated the original Entity Framework.
-
Delayed and Deprecated Features in Entity Framework Core
While Entity Framework has a rather ignominious reputation for breaking backwards compatibility, it pales in comparison to the total rewrite undertaken for Entity Framework core. In this article InfoQ looks at some of the major feature changes and their repercussions.
-
.NET Core - Terminology you Need to Know
In an effort to dramatically reduce confusion, ASP.NET 5.0 and Entity Framework 7.0 have been renamed to ASP.NET Core 1.0 and Entity Framework Core 1.0.
-
Shadow Properties in Entity Framework 7
Shadow properties are fields that don’t exist in the class itself, but are treated as if they did by Entity Framework. They can participate in queries, create/update operations, and database migrations.