SharpCoreDB.EntityFrameworkCore 2.1.0-RC.3

SharpCoreDB.EntityFrameworkCore v2.1.0-RC.3

Entity Framework Core Provider for SharpCoreDB

Full EF Core integration with SharpCoreDB's encryption and performance for modern .NET applications.

Patch updates in v1.9.1

• ✅ Fixed critical Guid foreign key persistence bug when using Include + navigation filters (e.g. Where(x => x.Children.Any(...))).
• Root cause was missing Guid normalization during INSERT parameter binding (now aligned with DateTime handling).
• The recommended pattern now works reliably with Guid primary keys and foreign keys.

Patch updates in v1.9.5 (archived; current release v2.1.0-RC.3)

• ✅ Fixed EF Core materialization for aliased and quoted SELECT columns by normalizing DataReader column names and fallback value resolution.
• ✅ Added targeted regression tests for aliased and qualified column lookup behavior.
• ✅ Parameterized query binding fixed (Issue #336): named-parameter binding is token-aware, so parameter names that are prefixes of others (e.g. @t vs @tid) no longer corrupt the SQL.
• ✅ Server parameter pass-through fixed (Issue #337): request.Parameters are forwarded on gRPC, the binary (PostgreSQL) protocol and WebSocket.
• ✅ ULID encoding is now standards-compliant: ULIDs follow the official Crockford Base32 spec and are interchangeable with Python/Java/Go implementations.
• ✅ NuGet dependencies updated to their latest stable versions.
• ✅ Aligned package metadata and version references to the synchronized 1.9.5 release line.
• ✅ Release automation now publishes all packable SharpCoreDB packages in CI/CD.

Features

• ✅ Inherits metadata improvements from SharpCoreDB v1.9.5
• ✅ Entity Framework Core integration
• ✅ Enterprise distributed features support
• ✅ Zero breaking changes
• ✅ Production ready

🚀 Key Features

• Full EF Core Support: LINQ queries, migrations, relationships
• Encryption: Transparent AES-256-GCM encryption
• Performance: High-speed data access with built-in caching
• MVCC: Multi-version concurrency control
• Transactions: ACID guarantees across operations

💻 Quick Example

using Microsoft.EntityFrameworkCore;
using SharpCoreDB.EntityFrameworkCore;

public class AppDbContext : DbContext
{
    public DbSet<User> Users { get; set; }
    public DbSet<Order> Orders { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder options)
    {
        options.UseSharpCoreDB("mydb.scdb", "password");
    }
}

using var context = new AppDbContext();
var users = await context.Users.Where(u => u.IsActive).ToListAsync();

📚 Documentation

• Full Documentation
• Entity Framework Integration

📦 Installation

dotnet add package SharpCoreDB.EntityFrameworkCore --version 2.1.0-RC.3

Requires: SharpCoreDB v1.9.5+, EntityFrameworkCore v8.0+

Version: 1.9.1 | Status: ✅ Production Ready (Guid FK fix included)