Skip to content

Top AI Tools for C# Developers

Ok lets start this post by saying that this topic is very much of a moving target. The tools that I am going to present in this post, might be irrelevant in next few months. Nevertheless, let’s take a look at where the world stands today and which top AI tools I recommend for every C# developer.

IDE Tools

I am going to split this post into two main topics: …

Photo by Pixabay: https://www.pexels.com/photo/purple-foot-bridge-220769/

Building Modern Applications on Microsoft Fabric

Modern applications demand seamless data integration, real-time responsiveness, and scalability (+ of course cool looking UI). Microsoft Fabric unifies data movement, processing and storage into a cohesive environment. As of now the end game for Microsoft Fabric has been the Power BI report. When that is done we are fine, but think about all the work, calculation power and storage usage that we are having just to provide a report. …

Image by Canva

Estimate Your Fabric Capacity Needs

Understanding the cost of Microsoft Fabric is crucial for using Fabric efficiently. Recently Microsoft published a new tool to help estimate how much Fabric capacity you really need. In this post, we’ll explore how to use the calculator effectively, what inputs matter most, and why estimating your Fabric usage is a critical part of managing budgets and avoiding surprises.

Capacity

First let’s talk a little bit about capacity in Fabric …

Photo by Pixabay: https://www.pexels.com/photo/wine-tank-room-434311/

Working with Fabric Warehouse Data in PySpark Notebooks

I noticed today that there are surprisingly few samples/blog posts/guides about how to write (and read) data into warehouse from Fabric notebook. You can find lot of information about doing it through T-SQL Notebook, but you can actually use it from Spark Notebook through the Spark connector. Let me show you how.

Spark Connector

The Spark connector for Fabric Data Warehouse allows Spark Notebooks to read data from warehouse and …

Generated with ChatGPT

Build and Connect Blazor Chat App with MCP C# SDK

In my previous blog post, I showed how you can create your own MCP server with C#. In this post we are going to build a Blazor Web Chat application that connects to that server and utilizes local LLAMA 3.1 model with Ollama. This means that our client, MCP server and LLM model will all be running in our local environment.

What is MCP C# SDK?

We are …

Photo by InstaWalli: https://www.pexels.com/photo/brown-cardboard-robot-artwork-176842/

Build Your Own MCP Server with MCP C# SDK

In early April Microsoft published C# SDK for MCP Server. If you aren’t familiar with MCP you can check great definition from Philipp Schmid blog. If you are too lazy to read it I can give you a short intro: MCP is a standardized way to give capabilities for LLM apps. That is like most simplified way to intro it. You can implement your own tools (servers in MCP …

Photo by Vlad Alexandru Popa: https://www.pexels.com/photo/photo-of-audi-parked-near-trees-1402787/

Part II: Microsoft Fabric GraphQL Performance

This blog post is second part of my Fabric GraphQL testing posts. You can find the first part HERE.

I have been using Fabric SQL Analytics Endpoint to build solutions in where Fabric data is used outside of Fabric. You can quite easily integrate into endpoint and fetch data with .NET app by using the MSAL authentication library (Only Service Principal access is supported at the moment). However the …

Part I: Use Microsoft Fabric GraphQL API with .NET App

Microsoft Fabric’s GraphQL API allows querying data stores in a flexible and efficient way. In this post I will walk through how you can integrate the Fabric GraphQL API into a .NET application, covering authentication, making queries, and handling responses. We are going to implement the solution by using service principal, but you can also use the interactive auth also if you want to.

Authentication

As shown in my …

Scientific azure private endpoint image that is generated with DALL-E

Fabric Security: How to Access Private Network Azure Resources

In Azure it is good practice (well I would say mandatory practice) to restrict database and Key Vault access by setting network restrictions for the Azure resource. Typically enterprises has their own virtual networks set and database/Key Vault access is restricted to those networks only. I recommend to disable the “Allow Azure services and resources to access this server” for SQL databases as it allows all Azure users …

Image of fantasy library with vibrant color. Generated with Canva AI

What is Microsoft.Extensions.AI Library and Will It Replace Semantic Kernel?

Microsoft has published new AI library (well, technically it is just LLM library, but nowadays AI = LLM) in preview. This library is called Microsoft.Extensions.AI. With this library, developers can abstract away what LLM service (like OpenAI) they are using and easily leverage basic chat functionality from LLM. Sounds a lot like Semantic Kernel, doesn’t it? So what is the difference and when you should use this library …