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
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 - A .NET NoSQL Document Store in a single data file - https://www.litedb.orgProject 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.
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.
: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.
The stream database optimised for event sourcingProject 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.
ACID Document DatabaseProject mention: SQL and M4 = Composable SQL | news.ycombinator.com | 2022-12-28
Fluent migrations framework for .NETProject mention: How do you deal with merging Entity Framework feature migrations into your main branch? | reddit.com/r/dotnet | 2022-12-08
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
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.
Pokémon Save File EditorProject 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
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and FirebirdProject 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 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 . 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 . 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.
Entity Framework Core provider for MySQL and MariaDB built on top of MySqlConnectorProject mention: Whats the different between these two? What should I be using if im on NET 6? | reddit.com/r/csharp | 2022-11-18
.NET Transactional Document DB and Event Store on PostgreSQL
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.
Entity Framework Core provider for PostgreSQLProject 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 is a mobile database: a replacement for SQLite & ORMs
A .NET document database working on any RDBMSProject 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
Simple microORM that maps the results of a query onto a POCO object. Project based on Schotime's branch of PetaPoco
Fast, lightweight .NET micro-ORM
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 - 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 fromProject 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
Get SQL Server notification on record table change
DataStax C# Driver for Apache Cassandra
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 - 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
1 project | reddit.com/r/csharp | 31 Jan 2023
Support for DateOnly/TimeOnly for SQL Server has been added to EF Core 8
1 project | reddit.com/r/dotnet | 30 Jan 2023
How to Handle MSSQL Database in CI/CD?
3 projects | reddit.com/r/devops | 26 Jan 2023
ASP.Net Core database modelling without using existing ORMs?
4 projects | reddit.com/r/dotnet | 26 Jan 2023
ASP.Net Core database modelling without using existing ORMs?
1 project | reddit.com/r/csharp | 26 Jan 2023
Entity Framework Core 6.0.13 - Negative Foreign Key Values Inserted For Join Entity
2 projects | reddit.com/r/dotnet | 23 Jan 2023
How to introduce a queue for my API.
4 projects | reddit.com/r/csharp | 23 Jan 2023
A note from our sponsor - SonarLint
www.sonarlint.org | 2 Feb 2023
What are some of the best open-source Database projects in C#? This list will help you:
|9||SqlKata Query Builder||2,586|
|10||LINQ to DB||2,514|
|13||Entity Framework 6||1,372|