Writing
All posts
Practical C#, .NET, and ASP.NET Core tutorials.
12 posts in Database

Connect database to AI with Devart MCP in ASP.NET Core
Devart MCP Server Universal bridges your database to AI, letting assistants turn natural language questions into accurate EF Core code by querying the real schema and data.

MongoDB with EF Core
Use MongoDB with the familiar EF Core model. Install MongoDB.EntityFrameworkCore, call UseMongoDB and keep DbContext, LINQ and SaveChanges while storing documents.

Dapper Transactions in ASP.NET Core
Dapper does not wrap writes in an implicit transaction. Learn BeginTransaction, Dapper.Transaction and TransactionScope so related SQL statements commit or roll back together.

Getting Started with MongoDB in ASP.NET Core
Wire up MongoDB.Driver in ASP.NET Core with options binding, a singleton IMongoClient, BSON document mapping and full CRUD for a Product collection.

Transactions in EF Core
Database transactions ensure multiple operations succeed or fail together. EF Core wraps SaveChanges in an implicit transaction, with explicit transactions and savepoints for more complex flows.

Entity Developer and dotConnect for ASP.NET Core
EF Core and other first party tools are amazing in modern data access development in .NET ecosystem.

Efficient Similarity Search using Vector Indexes
Exact vector search is a solid starting point. Once volume grows, approximate vector search with vector indexes a offer fast alternative with relevant results instead of exhaustive comparison on every row.

Full-Text Search in EF Core 10
Full-text search in EF Core 10 combined with Azure Cosmos DB offers a powerful and efficient way to implement advanced text search in modern applications.
The next issue lands Thursday.
Join 4,000+ .NET engineers. Free, focused, and easy to leave.