C# SQL

Open-source C# projects categorized as SQL

Top 23 C# SQL Projects

  • Dapper

    Dapper - a simple object mapper for .Net

    Project mention: SQL Connection Question | reddit.com/r/learncsharp | 2023-03-20

    I think EF Core & EF are the successors to LINQ to SQL that you'd wanna look into, and/or Dapper if you wanna go lower.

  • Bitwarden

    The core infrastructure backend (API, database, Docker, etc). (by bitwarden)

    Project mention: Can access my wallet, but can’t get my coins off | reddit.com/r/atomicwallet | 2023-03-20

    This is why I use a password locker. https://bitwarden.com/

  • InfluxDB

    Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

  • Opserver

    Stack Exchange's Monitoring System (by opserver)

  • EFCore.BulkExtensions

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

    Project mention: What do you use in a production application? | reddit.com/r/csharp | 2023-01-04

    Using EF core with migrations. Anything that we can’t do out of the box, we can normally do with the bulk extensions (https://github.com/borisdj/EFCore.BulkExtensions). There were two specific places I had to drop back to raw SQL, one was for a specific SELECT query that needed to be optimised, the second was a stored proc doing a MERGE that we pass in a table type (upsert of 100k records)

  • 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: Is PostgreSQL a worthy alternative to Microsoft SQL Server? | dev.to | 2023-02-07

    And yet again, I got pleasantly surprised. Npgsql - the recommended ADO.NET and Entity Framework (Core) provider - makes the adoption of PostgreSQL an almost seamless experience. Additionally, the Npgsql provider implements those PostgreSQL language elements, which are not present in the Microsoft SQL Server world. Let me mention here at least support for the ILIKE operator, as well as a range of functions related to the PostgreSQL's LTree data type.

  • 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: EF Core or Dapper | reddit.com/r/dotnet | 2023-03-10

    SqlKata is your friend.

  • SonarQube

    Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

  • 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

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

  • SmartSql

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

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

  • monitor-table-change-with-sqltabledependency

    Get SQL Server notification on record table change

  • Dapper.FastCRUD

    fast & light .NET ORM for strongly typed people

  • EntityFrameworkCore.Triggered

    Triggers for EFCore. Respond to changes in your DbContext before and after they are committed to the database.

    Project mention: Is using EF core will be a good choice for building enterprise application ? | reddit.com/r/dotnet | 2022-10-24
  • yuniql

    Free and open source schema versioning and database migration made natively with .NET/6. NEW THIS MAY 2022! v1.3.15 released!

    Project mention: yuniql: A cross-platform, multi-database schema version control made with C#/.NET6 | reddit.com/r/csharp | 2022-05-24

    Here's one that with the hotfix. https://github.com/rdagumampan/yuniql/releases/download/v1.3.15/yuniql-cli-win-x64-v1.3.15.zip

  • linq2db.EntityFrameworkCore

    Bring power of Linq To DB to Entity Framework Core projects

    Project mention: 400% faster, Rapid data insertion in Entity Framework Core 7 | reddit.com/r/aspnetcore | 2022-11-30

    https://github.com/linq2db/linq2db.EntityFrameworkCore has temp table creation & bulk data insert as well

  • Musoq

    Use SQL on various data sources

    Project mention: Can SQL be used without an RDBMS? | reddit.com/r/PHP | 2023-02-27
  • 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.

  • Venflow

    A brand new, fast and lightweight ORM, build for PostgreSQL.

  • DacFx

    SQL Server database schema validation, deployment, and upgrade runtime. Enables declarative database development and database portability across SQL Server versions and environments.

    Project mention: What do you guys use for version control? | reddit.com/r/SQLServer | 2022-10-04

    For database projects, if you want the first party (and free) Microsoft experience you can use SQL Server Data Tools in Visual Studio 2019 or 2022 to get the full development experience on Windows. You can also use the SQL Database Projects extension in Azure Data Studio provided you don't run into any of the known limitations. Besides being free, the underlying technology (Data Tier Framework, or DacFx) is used under the hood by SSMS, SSDT, ADS, GitHub pipelines, etc., and is now open source so you can see what's going on if you want to dig into the code.

  • snowflake-connector-net

    Snowflake Connector for .NET

    Project mention: Did anyone experience issues with their apps after migrating to OIE? | reddit.com/r/okta | 2023-01-20
  • adfsmfa

    MFA for ADFS 2022/2019/2016/2012r2

  • Dashing

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

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

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 15,915
2 Bitwarden 12,133
3 Opserver 4,238
4 EFCore.BulkExtensions 3,024
5 FluentMigrator 2,909
6 Npgsql 2,837
7 SqlKata Query Builder 2,649
8 LINQ to DB 2,553
9 efcore.pg 1,245
10 SmartSql 934
11 Evolve 682
12 monitor-table-change-with-sqltabledependency 587
13 Dapper.FastCRUD 440
14 EntityFrameworkCore.Triggered 374
15 yuniql 351
16 linq2db.EntityFrameworkCore 351
17 Musoq 258
18 bulk-writer 229
19 Venflow 164
20 DacFx 145
21 snowflake-connector-net 122
22 adfsmfa 100
23 Dashing 47
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com