Aug 28, 2020 · Backend Development

EF Core Practical Guide: DbContext Configuration, Threading, Connection Pooling, Logging, and CRUD Operations

This article provides a comprehensive tutorial on using EF Core in .NET, covering DbContext setup for MySQL and SQL Server, thread‑safety considerations, connection‑pooling benefits, logging of generated SQL, various insertion techniques (single, cascade, bulk), querying methods, and efficient update patterns.

EF CoreORMc++

0 likes · 16 min read

EF Core Practical Guide: DbContext Configuration, Threading, Connection Pooling, Logging, and CRUD Operations

Fulu Network R&D Team

Jul 24, 2020 · Databases

Efficient Bulk Insert with EF Core: CSV and DataTable Strategies for MySQL and MSSQL

This article explains how to achieve high‑performance bulk inserts in .NET Core applications by converting entities to CSV or DataTable formats and using MySQL's LOAD DATA and SQL Server's SqlBulkCopy, providing reusable extension methods, interface abstractions, and performance benchmarks.

Bulk InsertEF CoreMSSQL

0 likes · 12 min read

Efficient Bulk Insert with EF Core: CSV and DataTable Strategies for MySQL and MSSQL