Posts

.NET 10: Using Entity Framework Core 1o to store Vector Embedding in Azure SQL Database and perform Semantic Search

-
Image
In this article, we will see new Features of Entity Framework Core 10 with Vector store in Azure SQL Database. EF Core 10 includes built-in support for Azure SQL’s native vector type and vector search, so developers no longer need the separate VectorSearch plugin used in EF Core 8/9. In .NET 10, the SQLVector support was introduced via EF Core 10.0. This added a native support Entity Framework Core 10 (released in November 2025) added native support for the new SQL Server VECTOR data type, allowing developers to use SqlVector properties in their .NET applications. Advantages of using SqlVector While building AI applications like Retrival Augmented Generation (RAG) as well as Semantic Search, we need to store data in the form of vector embedding. With a tridditional programming approach with typical database centric applications, storing vectorized data in difficult in database tables. In .NET 10 with EF Core 10, using SqlVector structure we can make it possible. in .NET 10 application ...
Read more

Model Context Protocol (MCP): Understand Core Concepts of MCP

-
Image
The Model Context Protocol (MCP) is an open standard that allows AI applications to connect seamlessly with external tools, data sources, and workflows. You can consider it as a USB-C port for AI that lets AI applications to plug into existing applications those uses Databases, Files, etc.  Technically, MCP can be defined as a protocol that is developed to standardize a mechanism using which various AI models e.g. ChatGPT, Cloude, etc. interact with an external system. The purpose of MCP is to  ensures that the AI can access real-time, contextually relevant data and perform tasks securely.  Why does MCP Really Matters? An existing AI Systems do face following challenges: Fragmented APIs:   Since each and every Application has its own style of integration e.g. REST, SOAP, GraphQL, RPC, there is no standard mechanism exist for the client application to interact with it. These results into a technical glitch where client need to implement several connectors to integr...
Read more