C# SQL

Open-source C# projects categorized as SQL | Edit details

Top 23 C# SQL Projects

  • Dapper

    Dapper - a simple object mapper for .Net

    Project 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

  • Bitwarden

    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!

  • SonarLint

    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.

  • nopCommerce

    The most popular open-source eCommerce shopping cart solution based on ASP.NET Core

    Project 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

  • Opserver

    Stack Exchange's Monitoring System (by opserver)

    Project mention: Powershell Scripting For Getdbaservice | reddit.com/r/SQLServer | 2021-02-20
  • 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!

  • EFCore.BulkExtensions

    Entity Framework Core Bulk Batch Extensions for Insert Update Delete Read (CRUD), Truncate and SaveChanges operations on SQL Server, PostgreSQL, SQLite

    Project mention: 1.3 GB CSV imported via EF Core in 6 min with EFCore.BulkExtensions | reddit.com/r/csharp | 2021-12-03
  • 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.

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

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

    SmartSql = MyBatis in C# + .NET Core+ Cache(Memory | Redis) + R/W Splitting + PropertyChangedTrack +Dynamic Repository + InvokeSync + Diagnostics

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

    Bring power of Linq To DB to Entity Framework Core projects

    Project mention: Little question about "Linq to entity" | reddit.com/r/csharp | 2021-10-26
  • yuniql

    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.

  • bulk-writer

    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.

    Project mention: 1.3 GB CSV imported via EF Core in 6 min with EFCore.BulkExtensions | reddit.com/r/csharp | 2021-12-03
  • Venflow

    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.

  • adfsmfa

    MFA for ADFS 2022/2019/2016/2012r2

    Project 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

    Dashing is a simple to use mini ORM built on top of Dapper (by Polylytics)

  • Jerrycurl

    Razor-powered ORM for .NET

  • GraphQL.RepoDB

    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

  • SoftUni-Software-Engineering

    Course exercises | SoftUni | Kalin Tsenkov

    Project 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

  • Dapper.QX

    More powerful and testable inline SQL used with Dapper

  • CastIron

    Modular micro-ORM with a focus on the Query Object pattern

    Project 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

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

C# SQL related posts

Index

What are some of the best open-source SQL projects in C#? This list will help you:

Project Stars
1 Dapper 14,481
2 Bitwarden 9,060
3 nopCommerce 6,907
4 Opserver 4,123
5 FluentMigrator 2,653
6 Npgsql 2,443
7 EFCore.BulkExtensions 2,363
8 LINQ to DB 2,241
9 SqlKata Query Builder 2,141
10 efcore.pg 992
11 SmartSql 817
12 monitor-table-change-with-sqltabledependency 515
13 linq2db.EntityFrameworkCore 256
14 yuniql 215
15 bulk-writer 215
16 Venflow 156
17 adfsmfa 81
18 Dashing 46
19 Jerrycurl 35
20 GraphQL.RepoDB 19
21 SoftUni-Software-Engineering 9
22 Dapper.QX 3
23 CastIron 2
Find remote jobs at our new job board 99remotejobs.com. There are 30 new remote jobs 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