ErikEJ

Øredev 2026 links: MCP for .NET apps

SQL Server Rules (SqlServer.Rules) https://github.com/ErikEJ/SqlServer.Rules

Blog: MCP, .NET and Copilot https://erikej.github.io/mcp/dotnet/copilot/2025/05/06/mcp-dotnet-copilot.html

Blog: Publishing an MCP Server to NuGet https://erikej.github.io/mcp/dotnet/nuget/2025/07/30/mcp-dotnet-nuget.html

ErikEJ

Intro blog post

Blog post: Create a Custom Static Code Analysis Rule for Azure SQL Database / SQL Server with .NET

Blog post: Introducing MSBuild.Sdk.SqlProj 3.0 - create, build, validate, analyze, pack and deploy SQL database projects with .NET 9

Blog post: Better together with Entity Framework Core Power Tools - use a SQL Server Database Project (.dacpac) and EF Core

Demo script and analyzer sample

ErikEJ

Tech Passion Day

How to: Code analyze your SQL Server T-SQL scripts in Visual Studio

NL2SQL in Azure Portal Query Editor

Use natural language to execute SQL queries

NLS2SQL sample bug fixed

ErikEJ

Oredev EF Core 9 & Power Tools CLI CTA

Get .NET 9

.NET Conf 2024

What's new in EF Core 9

Breaking changes in EF Core 9

ErikEJ

using System.Linq.Expressions;

namespace Microsoft.EntityFrameworkCore
{
    public static class IQueryableExtensions
    {
        public static IQueryable<TQuery> In<TKey, TQuery>(
        this IQueryable<TQuery> queryable,
        IEnumerable<TKey> values,
        Expression<Func<TQuery, TKey>> keySelector)

ErikEJ

  
  <runtime>
    <gcServer enabled="true" />
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="System.Data.SqlServerCe" publicKeyToken="89845dcd8080cc91" culture="neutral" />
        <bindingRedirect oldVersion="4.0.0.0-4.0.0.1" newVersion="4.0.0.1" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>