C# Database

Open-source C# projects categorized as Database | Edit details
Related topics: #.NET #C# #ORM #C# #SQL

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: Entity Framework Core 6 features - Part 1 | reddit.com/r/dotnet | 2022-01-16

    An attribute is new. Github issue.

  • LiteDB

    LiteDB - A .NET NoSQL Document Store in a single data file - https://www.litedb.org

    Project mention: What sort of mature, open-source libraries do you feel Rust should have but currently lacks? | reddit.com/r/rust | 2021-11-01

    A mature NoSQL embedded/flatfile database like LiteDB would be nice. There are some similar Rust libraries but they aren't very close to production ready and the API tends to not be too user friendly. I had trouble finding one of these for a small app I had to write recently.

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  • 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: Unit test, e2e what to choose? | reddit.com/r/Blazor | 2022-01-10

    Or check out something like Bogus for generating fake data.

  • Event Store

    The stream database optimised for event sourcing

    Project mention: 3 reasons to adopt Event Sourcing | dev.to | 2021-04-01

    Where's the catch, then? Well, there's a couple of catches, in fact. First of all, in a distributed setting, appending data to a log isn't that easy. First, you need to make your log distributed. Again, Kafka/Cassandra/EventStore make this possible, however, whenever you start dealing with distributed data, you‘re introducing new operational and implementation complexity.

  • RavenDB

    ACID Document Database

  • FluentMigrator

    Fluent migrations framework for .NET

    Project mention: Setup local MS SQL docker container | dev.to | 2021-12-13

    Personally I prefer to use FluentMigrator to schema modification data load.

  • Npgsql

    Npgsql is the .NET data provider for PostgreSQL.

    Project mention: people who use Linux for using C# at your job, what is your role, and does Linux suit your needs? | reddit.com/r/csharp | 2021-12-11

    But our production server was Linux. Windows Server and Linux servers are both very capable, but Linux does the same job without any license fee. We also used Postgres for our database (again free) and it turned out that the EF Core provider of Postgres has more capabilities than the SQL Server one!

  • SonarQube

    Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

  • LINQ to DB

    Linq to database provider.

    Project mention: SQL language proposal: JOIN FOREIGN | news.ycombinator.com | 2022-01-06

    Ahhh, I know that Entity Framework would do this at one point, IDK if EF Core does or not.

    Linq2Db does it via T4 Template generation, so you can play with it more if you want [0]

    [0] - https://github.com/linq2db/linq2db/blob/64a0db9a9ed7787ff755...

  • 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: Which ORM to study ? | reddit.com/r/csharp | 2021-12-02

    Not really an ORM. But I have been enjoying SqlKata recently. Works with Dapper but helps reduce SQL strings and makes things like pagination really easy. Also nice for dynamic filters.

  • Pomelo.EntityFrameworkCore.MySql

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

    Project mention: Github repositories to study from | reddit.com/r/csharp | 2022-01-02
  • PKHeX

    Pokémon Save File Editor

    Project mention: Does anybody know where to get rare candy cheat codes for Ultra SUN ? | reddit.com/r/Citra | 2021-12-06

    Info and screenshots here: https://github.com/kwsch/PKHeX/

  • Marten

    .NET Transactional Document DB and Event Store on PostgreSQL

    Project mention: Considering MongoDB for a Production ERP System with Net 6 | reddit.com/r/csharp | 2022-01-23

    You can use Marten for this with Postgres. https://martendb.io/

  • 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.

    Project mention: Ask HN: What tangible benefits did you get from spending time on HN? | news.ycombinator.com | 2021-03-06

    Every so often, posts from Bruce Dawson's blog get posted here - one such post was about using Event Tracing for Windows to diagnose an issue with an NTFS lock being held causing 63 cores to idle while 1 does all the work.

    https://randomascii.wordpress.com/2019/10/20/63-cores-blocke...

    A few months later, some other people in my team were struggling to diagnose an issue in production where a legacy webapp was struggling to scale up and fully use all 64 cores of the server we needed it to run on. I stepped in to help and remembered that post I'd seen on HN. We used ETW (through Windows Performance Recorder and Windows Performance Analyzer) to profile our app and I looked into the Wait Analysis. Turns out that Entity Framework 6 uses a ReaderWriterLockSlim to guard a cache, and that particular lock performs extremely poorly under heavy contention. Heavy in our case meant that for a single page build of one of this app's "hot path" pages, this lock would be taken a few hundred thousand times. We weren't the first to discover this:

    https://github.com/dotnet/ef6/issues/1500

    What some other people in my team were struggling with for about two weeks was resolved in a single day thanks to me goofing off and reading HN. (We ultimately used a fork of EF6 that didn't suffer from this issue to solve our problem)

  • Realm Xamarin

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

    Project mention: Offline Sync - What are the current options | reddit.com/r/xamarindevelopers | 2021-05-26

    I'm also looking into a local DB for storage and am looking at Realm (Xamarin example).

  • efcore.pg

    Entity Framework Core provider for PostgreSQL

    Project mention: Announcing Entity Framework Core 6.0 Preview 4: Performance Edition | reddit.com/r/dotnet | 2021-05-30
  • 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

  • Cassandra

    DataStax C# Driver for Apache Cassandra

    Project mention: Alguna alternativa a MSSQL que no sea MySQL o PostgreSQL | reddit.com/r/CharruaDevs | 2021-06-05

    Sólo he usado el protocolo de Cassandra desde Go, pero por lo que veo para .NET en vez de pagar por eso usaría el driver de DataStax que implementa el mismo protocolo y es open source: https://github.com/datastax/csharp-driver

  • monitor-table-change-with-sqltabledependency

    Get SQL Server notification on record table change

    Project mention: Suggestions for how to implement this real-time app? | reddit.com/r/webdev | 2021-05-27
  • BrightstarDb

    This is the core development repository for BrightstarDB.

  • DBreeze

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

  • Ceras

    Universal binary serializer for a wide variety of scenarios https://discord.gg/FGaCX4c

    Project mention: any good binary serializers that are not assembly dependent | reddit.com/r/csharp | 2021-10-23

    So the answer is no, there aren't. If you want to add that kind of security risk to your application you can use ceras

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 2022-01-23.

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 10,928
2 LiteDB 6,202
3 Bogus 5,201
4 Event Store 4,425
5 RavenDB 2,896
6 FluentMigrator 2,653
7 Npgsql 2,443
8 LINQ to DB 2,241
9 SqlKata Query Builder 2,141
10 Pomelo.EntityFrameworkCore.MySql 2,111
11 PKHeX 1,841
12 Marten 1,679
13 Entity Framework 6 1,297
14 Realm Xamarin 1,008
15 efcore.pg 992
16 Yessql 920
17 NPoco 789
18 Insight.Database 686
19 Cassandra 524
20 monitor-table-change-with-sqltabledependency 515
21 BrightstarDb 430
22 DBreeze 421
23 Ceras 412
Find remote Database jobs at our new job board 99remotejobs.com. There is 1 new remote job listed recently.
Are you hiring? Post a new remote job listing for free.
OPS - Build and Run Open Source Unikernels
Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.
github.com/nanovms