C# Database

Open-source C# projects categorized as Database
Topics: #.NET #C# #C# #SQL #ORM

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: EF Core's lack of support for Linq join's | reddit.com/r/csharp | 2023-01-31

    This issue on Github, and the comment branching it into subissues by SmitPatel outlines the issues some people are having with GroupJoin. https://github.com/dotnet/efcore/issues/17068

  • LiteDB

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

    Project mention: How to introduce a queue for my API. | reddit.com/r/csharp | 2023-01-23

    Please consider using the primary key to generate an unique value on the db side.

  • InfluxDB

    Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.

  • 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: Using EF Core and Bogus | dev.to | 2023-01-21

    Going forward, the secret to knowing were to find data is to read Bogus information in the readme file which goes into depth were to find paths to generate data. This is very important as you can clash with their classes e.g. you create a Person class and guess what, Bogus has a Person class. This is were knowing how to work with using statements and using statements with aliasing.

  • Event Store

    The stream database optimised for event sourcing

    Project mention: if you had to restart at 0 knowledge what would you do? | reddit.com/r/PinoyProgrammer | 2022-10-11

    C#: In Europe, Java is still strong but many trading firms use C# because of the strong Microsoft culture in Europe, as well as because of strongly supported C# libraries like say EventStore, which tends to be used for the matchmaking engines for stock exchanges (especially that exchange matchmaking problem is basically SMR). And skimming over the code, it has Paxos implemented too, making it good for dealing with partial failures (failover), essential for any HFT/trading firm. C#'s also the biggest ecosystem that many of the breakthrough java tech mentioned earlier was first ported to.

  • RavenDB

    ACID Document Database

    Project mention: SQL and M4 = Composable SQL | news.ycombinator.com | 2022-12-28
  • FluentMigrator

    Fluent migrations framework for .NET

    Project mention: How do you deal with merging Entity Framework feature migrations into your main branch? | reddit.com/r/dotnet | 2022-12-08
  • Npgsql

    Npgsql is the .NET data provider for PostgreSQL.

    Project mention: ASP.Net Core database modelling without using existing ORMs? | reddit.com/r/dotnet | 2023-01-26
  • SonarLint

    Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.

  • PKHeX

    Pokémon Save File Editor

    Project mention: Need Help installing tar.gz files | reddit.com/r/linuxmint | 2023-01-03

    It's called PKHex. Here is a link to the file

  • 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: ASP.Net Core database modelling without using existing ORMs? | reddit.com/r/dotnet | 2023-01-26

    Don't know if can be a good pick for the no-ORM requirement but I would take a look at SqlKata which is a nice query builder + execution engine, built on top of Dapper

  • LINQ to DB

    Linq to database provider.

    Project mention: LiteDB: A .NET embedded NoSQL database | news.ycombinator.com | 2022-11-08

    Before checking this out, people might want to take a look through the issues and pull requests of which there are 500+ and 50+ respectively [1]. I was really optimistic about this project and it was headed in a great direction, but it's not in a production ready state, and it seems that the main guy behind it has decided to move onto other things. It's been about a year since there was any significant activity.

    I just mention this because a lot of these little issues might only become more apparent after integrating the db into your project and so it can be a bit annoying. I ended up swapping to Linq2DB [1]. It's something, more or less, similar offering an ORM/LINQ type system as well as the ability to also use direct SQL if desired. But the neat thing is that it also uses a standardized API for the LINQ query language, so you can do things like swap from SQLite to PostgreSQL in one* line of code, so long as you're not using any provider specific extensions.

    [1] - https://github.com/mbdavid/LiteDB

    [2] - https://github.com/linq2db/linq2db

  • Pomelo.EntityFrameworkCore.MySql

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

    Project mention: Whats the different between these two? What should I be using if im on NET 6? | reddit.com/r/csharp | 2022-11-18
  • Marten

    .NET Transactional Document DB and Event Store on PostgreSQL

    Project mention: Marten, a Crystal web framework that makes building web apps productive and fun | news.ycombinator.com | 2022-10-30

    Not to be confused with the C# document database built on 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: ASP.NET Performance optimization question | reddit.com/r/csharp | 2022-02-10

    Additionally, an individual context will also cache the actual sql being performed and their docs go over the caching it does here regarding that.

  • efcore.pg

    Entity Framework Core provider for PostgreSQL

    Project mention: Poll results, repository pattern over Entity Framework? | reddit.com/r/dotnet | 2023-01-25

    Place I joined is using InMemoryProvider for tests. I tried upgrading to .net 6 and the .net 6 npgsql driver. Certain things bit us like no more support for EF.Functions.Like.

  • Realm Xamarin

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

  • Yessql

    A .NET document database working on any RDBMS

    Project mention: How would one go about storing PoE-like items in a relational database? | reddit.com/r/pathofexile | 2022-07-24

    I will go with the document database approach. If you don't want to introduce new technologies or pay additional license fees you can go and check YesSql - https://github.com/sebastienros/yessql

  • 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

  • Evolve

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

    Project mention: How to Handle MSSQL Database in CI/CD? | reddit.com/r/devops | 2023-01-26

    If you want to stay in C# land, look at Evolve.

  • 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

    Project mention: We all make mistakes sometimes.. | reddit.com/r/csharp | 2022-10-13

    I just remembered that I created an issue with my old Github account on that repository back then. It has more accurate information than my current memory: https://github.com/sjh37/EntityFramework-Reverse-POCO-Code-First-Generator/issues/409

  • monitor-table-change-with-sqltabledependency

    Get SQL Server notification on record table change

  • Cassandra

    DataStax C# Driver for Apache Cassandra

  • DBreeze

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

    Project mention: DBreeze – embedded C# .NET NOSQL key value multi-paradigm database system | news.ycombinator.com | 2022-03-15
  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

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 2023-01-31.

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 12,157
2 LiteDB 7,190
3 Bogus 6,657
4 Event Store 4,760
5 RavenDB 3,163
6 FluentMigrator 2,888
7 Npgsql 2,787
8 PKHeX 2,707
9 SqlKata Query Builder 2,586
10 LINQ to DB 2,514
11 Pomelo.EntityFrameworkCore.MySql 2,398
12 Marten 2,131
13 Entity Framework 6 1,372
14 efcore.pg 1,222
15 Realm Xamarin 1,121
16 Yessql 1,058
17 NPoco 816
18 Insight.Database 779
19 Evolve 660
20 EntityFramework-Reverse-POCO-Code-First-Generator 646
21 monitor-table-change-with-sqltabledependency 569
22 Cassandra 562
23 DBreeze 450
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com