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. Learn more →
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.
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
-
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.
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.
-
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.
-
-
Project mention: How do you deal with merging Entity Framework feature migrations into your main branch? | reddit.com/r/dotnet | 2022-12-08
-
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.
-
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-26Don'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
-
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.
-
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 -
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.
-
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.
Additionally, an individual context will also cache the actual sql being performed and their docs go over the caching it does here regarding that.
-
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.
-
-
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
-
-
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
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
-
-
-
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
C# Database related posts
- EF Core's lack of support for Linq join's
- Support for DateOnly/TimeOnly for SQL Server has been added to EF Core 8
- How to Handle MSSQL Database in CI/CD?
- ASP.Net Core database modelling without using existing ORMs?
- ASP.Net Core database modelling without using existing ORMs?
- Entity Framework Core 6.0.13 - Negative Foreign Key Values Inserted For Join Entity
- How to introduce a queue for my API.
-
A note from our sponsor - SonarLint
www.sonarlint.org | 2 Feb 2023
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 |