Top 23 C# SQL Projects
Dapper - a simple object mapper for .NetProject mention: Don't know how to change return type from <T> to DataTable | reddit.com/r/csharp | 2022-01-17
For reference: https://github.com/DapperLib/Dapper/blob/main/Dapper/DataTableHandler.cs
The core infrastructure backend (API, database, Docker, etc). (by bitwarden)Project mention: What are some services that you pay for? | reddit.com/r/PrivacyGuides | 2022-01-26
I think you should follow this thread, and then directly give Bitwarden a go, it's completely free and open source, audited, feature packed and generally the best option there is, it's better than it's competitors in every aspect — and for a few extra features that most of us don't need, there's a $10/yearly subscription plan which supports the developers, and gives you access to those handy features which aren't really necessary; you can store hundreds of passwords, and identification documents and the free plan will have you covered, for that and more!
Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.
The most popular open-source eCommerce shopping cart solution based on ASP.NET CoreProject mention: 64-bit Visual Studio 2022 now available! | reddit.com/r/programming | 2021-11-08
As a test I just cloned https://github.com/nopSolutions/nopCommerce
Stack Exchange's Monitoring System (by opserver)Project mention: Powershell Scripting For Getdbaservice | reddit.com/r/SQLServer | 2021-02-20
Fluent migrations framework for .NETProject mention: Setup local MS SQL docker container | dev.to | 2021-12-13
Personally I prefer to use FluentMigrator to schema modification data load.
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!
Entity Framework Core Bulk Batch Extensions for Insert Update Delete Read (CRUD), Truncate and SaveChanges operations on SQL Server, PostgreSQL, SQLite
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.
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 
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and FirebirdProject 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.
Entity Framework Core provider for PostgreSQLProject mention: Announcing Entity Framework Core 6.0 Preview 4: Performance Edition | reddit.com/r/dotnet | 2021-05-30
SmartSql = MyBatis in C# + .NET Core+ Cache(Memory | Redis) + R/W Splitting + PropertyChangedTrack +Dynamic Repository + InvokeSync + Diagnostics
Get SQL Server notification on record table changeProject mention: Suggestions for how to implement this real-time app? | reddit.com/r/webdev | 2021-05-27
Bring power of Linq To DB to Entity Framework Core projectsProject mention: Little question about "Linq to entity" | reddit.com/r/csharp | 2021-10-26
Free and open source schema versioning and database migration made natively with .NET Core.Project mention: Monthly 'Shameless Self Promotion' thread - 2022/01 | reddit.com/r/devops | 2022-01-01
yuniql is free and open source tool for repeatable database deployment and schema version control. No runtime dependencies, just single exe/tar file. Write SQL just as you are used to. Keep them in folders just as you are used to. Supports wide range of databases.
Provides guidance for fast ETL jobs, an IDataReader implementation for SqlBulkCopy (or the MySql or Oracle equivalents) that wraps an IEnumerable, and libraries for mapping entites to table columns.
A brand new, fast and lightweight ORM, build for PostgreSQL.Project mention: I created a new ORM | reddit.com/r/csharp | 2021-08-09
Since you hung around until the very end, I’m assuming you have some interest in Venflow. Therefore, if you haven’t yet, check out the README over on GitHub to learn even more about it.
MFA for ADFS 2022/2019/2016/2012r2Project mention: Am I being spoofed or hacked? | reddit.com/r/exchangeserver | 2021-04-19
My server is also a homelab one. No sign of Hafnium, and I was patched very early, but it did prompt me to do my next project. ECP was already blocked from outside, but OWA is now handled by a WAP, which authenticates against my ADFS server with MFA. If anyone is looking for a free MFA solution to use with ADFS, I can recommend this.
Dashing is a simple to use mini ORM built on top of Dapper (by Polylytics)
Razor-powered ORM for .NET
A set of extensions for working with HotChocolate GraphQL and Database access with micro-orms such as RepoDb (or Dapper). This extension pack provides access to key elements such as Selections/Projections, Sort arguments, & Paging arguments in a significantly simplified facade so this logic can be leveraged in the Serivces/Repositories that encapsulate all data access (without dependency on IQueryable and execution outside of the devs control).Project mention: Say hello to Hot Chocolate 12! (GraphQL in .NET) | reddit.com/r/dotnet | 2021-10-08
This repo seems to the exact abstraction/facade that is needed but it's based on v11 and I'm not sure if the internals of v12 have changed significantly where this is now out of date: https://github.com/cajuncoding/GraphQL.RepoDb
Course exercises | SoftUni | Kalin TsenkovProject mention: Do you ever look at your own old code, say how the F did I do this? | reddit.com/r/learnprogramming | 2021-12-16
It is highly recommended when you learn programming to keep all your code in a systematically organized way, e.g. in a GitHub repo like this: https://github.com/kalintsenkov/SoftUni-Software-Engineering
More powerful and testable inline SQL used with Dapper
Modular micro-ORM with a focus on the Query Object patternProject mention: Writing SQL in C# or When You should not use ORM | reddit.com/r/dotnet | 2021-02-23
I wasn't intending to advertise here, but since you asked for the link: https://github.com/Whiteknight/CastIron
C# SQL related posts
Don't know how to change return type from <T> to DataTable
1 project | reddit.com/r/csharp | 17 Jan 2022
SQL language proposal: JOIN FOREIGN
1 project | news.ycombinator.com | 6 Jan 2022
String Interpolation Trickery and Magic with C# 10 and .NET 6
1 project | reddit.com/r/dotnet | 18 Dec 2021
Using Azure functions and Entity framework to update a Azure SQL database - slow ?
1 project | reddit.com/r/dotnet | 13 Dec 2021
1.3 GB CSV imported via EF Core in 6 min with EFCore.BulkExtensions
3 projects | reddit.com/r/csharp | 3 Dec 2021
Little question about "Linq to entity"
2 projects | reddit.com/r/csharp | 26 Oct 2021
Ask HN: How do you handle CI/CD for databases
2 projects | news.ycombinator.com | 21 Sep 2021
What are some of the best open-source SQL projects in C#? This list will help you:
|8||LINQ to DB||2,241|
|9||SqlKata Query Builder||2,141|
Are you hiring? Post a new remote job listing for free.