C# Database

Open-source C# projects categorized as Database

Top 23 C# Database Projects

  • Entity Framework

    EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.

    Project mention: Multi-tenancy using schemas with Entity Framework and PostgreSQL | dev.to | 2023-10-16

    * You can check the original CreateMigration implementation at: https://github.com/dotnet/efcore/blob/release/7.0/src/EFCore.Relational/Migrations/Internal/MigrationsAssembly.cs

  • LiteDB

    LiteDB - A .NET NoSQL Document Store in a single data file

    Project mention: Generic DB with minimal boilerplate code | /r/csharp | 2023-05-22

    Maybe you want LiteDB? I don't think you need to write SQL, you can interact with the API.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • Bogus

    :card_index: A simple fake data generator for C#, F#, and VB.NET. Based on and ported from the famed faker.js.

    Project mention: Bogus custom Dataset | dev.to | 2024-01-06

    Bogus NuGet package is fake data generator which can be helpful for populating tables in a database and testing purposes. If a database is not used and Bogus populates list of data each time an application runs, the data is random, never the same. Also, the random data generated by Bogus may not meet a developer’s requirements.

  • Event Store

    EventStoreDB, the event-native database. Designed for Event Sourcing, Event-Driven, and Microservices architectures

    Project mention: Event Store State of the Art | /r/dataengineering | 2023-03-23

    I've been doing some research and found this: https://github.com/EventStore/EventStore

  • PKHeX

    Pokémon Save File Editor

    Project mention: Miyoo mini STATE File to PkHex not working | /r/MiyooMini | 2023-06-04

    .state files are not supported, according to the readme here. (disclaimer: I never used PKHex myself though)

  • RavenDB

    ACID Document Database

    Project mention: RavenDB 6.0.2 (A Jepsen Report) | news.ycombinator.com | 2024-01-31

    This aged well - https://github.com/ravendb/ravendb/issues/13218#issuecomment...

  • Npgsql

    Npgsql is the .NET data provider for PostgreSQL.

    Project mention: With .NET 8 Native AOT will we get small single binary for applications like Go/Rust? | /r/dotnet | 2023-06-04

    In theory this improves over time. .NET 8 will be the first "real" release of NativeAOT. I would expect the big ms libs to start playing nice after .net 8 comes out. Some big non-ms libs are already doing this, like npgsql. That is their issue for size reduction, many work items already done.

  • Onboard AI

    ChatGPT with full context of any GitHub repo. Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at app.getonboardai.com.

  • FluentMigrator

    Fluent migrations framework for .NET

    Project mention: Entity Framework Core Owned Entity | dev.to | 2024-02-15

    Fluent Migrator

  • SqlKata Query Builder

    SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird

    Project mention: EF Core or Dapper | /r/dotnet | 2023-03-10

    SqlKata is your friend.

  • LINQ to DB

    Linq to database provider.

    Project mention: Upserting complex data models from an API into EF Core entities | /r/dotnet | 2023-06-02
  • Pomelo.EntityFrameworkCore.MySql

    Entity Framework Core provider for MySQL and MariaDB built on top of MySqlConnector

    Project mention: Mysql and Entity | /r/csharp | 2023-03-10

    EntityFramework uses providers to translate Linq queries into real queries and connect to the datasource and convert the data into .net readable format. The MySQL provider for .NET is the official one but I think it has fallen on hard times and is not developed as much as before. You should probably look at Pomelo, which is a community library for .net core: https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql

  • Marten

    .NET Transactional Document DB and Event Store on PostgreSQL

    Project mention: Marten – .NET Transactional Document DB and Event Store on PostgreSQL | news.ycombinator.com | 2024-02-01
  • efcore.pg

    Entity Framework Core provider for PostgreSQL

    Project mention: Relational is more than SQL | news.ycombinator.com | 2023-09-16

    LINQ in EntityFramework (EF) supports querying JSON columns as objects [1].

    unnest support is on the roadmap for EF core for PG [2], but already supported for Couchbase [3].

    [1] https://learn.microsoft.com/en-ca/ef/core/what-is-new/ef-cor...

    [2] https://github.com/npgsql/efcore.pg/issues/1525

    [3] https://github.com/couchbaselabs/Linq2Couchbase/blob/master/...

  • Entity Framework 6

    This is the codebase for Entity Framework 6 (previously maintained at https://entityframework.codeplex.com). Entity Framework Core is maintained at https://github.com/dotnet/efcore.

  • Realm Xamarin

    Realm is a mobile database: a replacement for SQLite & ORMs

    Project mention: What does Realm.Fody do? | dev.to | 2023-04-04

    For the developers in the audience that never heard of it, Realm is an (amazing) offline-first (mostly) mobile object database with some really nice features. This article is not an introduction to Realm though, nevertheless I expect it should be easy to follow along even if you've never used it before. If you're curious and want to learn more about it, the official documentation is a good place to start. Besides, Realm open source, so you can check the source code for the .NET SDK on Github.

  • Yessql

    A .NET document database working on any RDBMS

  • NPoco

    Simple microORM that maps the results of a query onto a POCO object. Project based on Schotime's branch of PetaPoco

  • Insight.Database

    Fast, lightweight .NET micro-ORM

    Project mention: What your hidden nuget gems ? | /r/dotnet | 2023-03-10
  • Evolve

    Database migration tool for .NET and .NET Core projects. Inspired by Flyway.

  • EntityFramework-Reverse-POCO-Code-First-Generator

    EntityFramework Reverse POCO Code First Generator - Beautifully generated code that is fully customisable. This generator creates code as if you reverse engineered a database and lovingly created the code by hand. It is free to academics (you need a .edu or a .ac email address), not free for commercial use. Obtain your licence from

  • monitor-table-change-with-sqltabledependency

    Get SQL Server notification on record table change

  • Cassandra

    DataStax C# Driver for Apache Cassandra

  • DBreeze

    C# .NET NOSQL ( key value store embedded ) ACID multi-paradigm database management system.

  • WorkOS

    The modern API for authentication & user identity. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2024-02-15.

C# Database related posts

Index

What are some of the best open-source Database projects in C#? This list will help you:

Project Stars
1 Entity Framework 13,157
2 LiteDB 8,073
3 Bogus 8,066
4 Event Store 5,025
5 PKHeX 3,391
6 RavenDB 3,362
7 Npgsql 3,094
8 FluentMigrator 3,091
9 SqlKata Query Builder 2,948
10 LINQ to DB 2,826
11 Pomelo.EntityFrameworkCore.MySql 2,615
12 Marten 2,596
13 efcore.pg 1,422
14 Entity Framework 6 1,403
15 Realm Xamarin 1,200
16 Yessql 1,141
17 NPoco 835
18 Insight.Database 833
19 Evolve 816
20 EntityFramework-Reverse-POCO-Code-First-Generator 681
21 monitor-table-change-with-sqltabledependency 627
22 Cassandra 621
23 DBreeze 499
The modern API for authentication & user identity.
The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
workos.com