C# SQL

Open-source C# projects categorized as SQL
Edit details
Topics: .NET Database Postgresql C# ORM
Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
Sponsored

Top 23 C# SQL Projects

  • Dapper

    Dapper - a simple object mapper for .Net

    • Project mention: Working with Dapper/SQL-Server Framework 4.8 C# | dev.to | 2024-01-27

    In both samples to get all records and to get a single record works fine but there is a better way to perform the same work using NuGet package Dapper. Dapper is extremely easy to use and built with performance in mind. In the source code provided the basic operations are covered, to take things to the next level and read the information at GitHub, the following page and other code samples in the following repository.

  • Bitwarden

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

    • Project mention: Bitwarden | news.ycombinator.com | 2024-03-11

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo

  • Opserver

    Stack Exchange's Monitoring System (by opserver)

  • EFCore.BulkExtensions

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

    • Project mention: Best way to do mass inserts with Entity Framework | /r/dotnet | 2023-06-08

    EF Core Bulk Extensions has helped me out many a day.

  • Npgsql

    Npgsql is the .NET data provider for PostgreSQL.

    • Project mention: PowerBI: déployer une passerelle sur AWS pour $0.12/j | dev.to | 2024-03-14

  • FluentMigrator

    Fluent migrations framework for .NET

    • Project mention: Entity Framework Core Owned Entity | dev.to | 2024-02-15

    Fluent Migrator

  • SqlKata Query Builder

    SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo

  • LINQ to DB

    Linq to database provider.

    • Project mention: Upserting complex data models from an API into EF Core entities | /r/dotnet | 2023-06-02

  • efcore.pg

    Entity Framework Core provider for PostgreSQL

    • Project mention: Relational is more than SQL | news.ycombinator.com | 2023-09-16

    LINQ in EntityFramework (EF) supports querying JSON columns as objects [1].

    unnest support is on the roadmap for EF core for PG [2], but already supported for Couchbase [3].

    [1] https://learn.microsoft.com/en-ca/ef/core/what-is-new/ef-cor...

    [2] https://github.com/npgsql/efcore.pg/issues/1525

    [3] https://github.com/couchbaselabs/Linq2Couchbase/blob/master/...

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

  • monitor-table-change-with-sqltabledependency

    Get SQL Server notification on record table change

  • sqlnotebook

    Casual data exploration in SQL

    • Project mention: Show HN: My Go SQLite driver did poorly on a benchmark, so I fixed it | news.ycombinator.com | 2023-12-14

    The meat of the P/Invoke code is in here: https://github.com/electroly/sqlnotebook/tree/master/src/Sql...

    The parent directory includes code that uses it. I'm most proud of this SQLite virtual table module that proxies queries to remote ADO.NET connections, allowing you to write joins directly between local SQLite tables and remote SQL Server tables. https://github.com/electroly/sqlnotebook/blob/master/src/Sql...

    I've also got a generic virtual table module that lets me easily write table-valued functions in C#: https://github.com/electroly/sqlnotebook/blob/master/src/Sql...

    The goal is to provide various "supercharged" features to base SQLite by taking advantage of all the extension points I can. I wish some went further; in particular the virtual table API doesn't "push down" enough of the original query to allow the module to avoid doing O(N+1) queries in some cases.

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

  • linq2db.EntityFrameworkCore

    Bring power of Linq To DB to Entity Framework Core projects

  • yuniql

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

  • Musoq

    SQL Swiss Army Knife - Engine for Diverse Data Sources

    • Project mention: Show HN: Musoq, SQL like language with LLM experimental integrations | news.ycombinator.com | 2024-02-12

  • DacFx

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

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

  • snowflake-connector-net

    Snowflake Connector for .NET

  • CSVLint

    CSV Lint plug-in for Notepad++ for syntax highlighting, csv validation, automatic column and datatype detecting, fixed width datasets, change datetime format, decimal separator, sort data, count unique values, convert to xml, json, sql etc. A plugin for data cleaning and working with messy data files.

    • Project mention: A question for the pro's, am I misusing SQL? | /r/SQL | 2023-12-11

    Also, a little self-promotion here, I've created the CSV Lint plug-in for Notepad++ to work with CSV text data files. It can reformat, validate and sort csv files, as well as convert csv to different formats including SQL. Meaning it can take a csv data file and generate INSERT INTO statements, including CREATE TABLE with the corresponding column datatypes and everything.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
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).

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 17,128
2 Bitwarden 14,286
3 Opserver 4,462
4 EFCore.BulkExtensions 3,460
5 Npgsql 3,157
6 FluentMigrator 3,118
7 SqlKata Query Builder 2,992
8 LINQ to DB 2,856
9 efcore.pg 1,456
10 SmartSql 1,045
11 Evolve 824
12 monitor-table-change-with-sqltabledependency 645
13 sqlnotebook 588
14 Dapper.FastCRUD 484
15 EntityFrameworkCore.Triggered 484
16 linq2db.EntityFrameworkCore 433
17 yuniql 409
18 Musoq 284
19 DacFx 284
20 bulk-writer 237
21 Venflow 168
22 snowflake-connector-net 167
23 CSVLint 133

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com