Top 23 C# SQL Projects

• Dapper

  41 17,165 8.3 C#

  Dapper - a simple object mapper for .Net

  

Project mention: Get SQL-Server Stored Procedures with C# | dev.to | 2024-05-04

Using Dapper to get database names from the SQL-Server instance set in appsettings.json

• Bitwarden

  1,057 14,401 9.8 C#

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

  

Project mention: Essential Tools & Technologies for New Developers | dev.to | 2024-05-08

Bitwarden

• InfluxDB

  www.influxdata.com featured

  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.

  

• Opserver

  1 4,479 4.5 C#

  Stack Exchange's Monitoring System (by opserver)

  

• EFCore.BulkExtensions

  16 3,488 9.0 C#

  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

  15 3,164 9.4 C#

  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

  9 3,140 8.8 C#

  Fluent migrations framework for .NET

  

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

Fluent Migrator

• SqlKata Query Builder

  5 3,003 2.6 C#

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

  

• SaaSHub

  www.saashub.com featured

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

  

• LINQ to DB

  20 2,862 8.8 C#

  Linq to database provider.

  

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

• efcore.pg

  5 1,464 8.6 C#

  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

  0 1,049 5.4 C#

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

  

• Evolve

  5 826 2.8 C#

  Database migration tool for .NET and .NET Core projects. Inspired by Flyway.

• monitor-table-change-with-sqltabledependency

  2 645 0.0 C#

  Get SQL Server notification on record table change

• sqlnotebook

  1 588 7.6 C#

  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.

• EntityFrameworkCore.Triggered

  1 489 2.9 C#

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

• Dapper.FastCRUD

  1 486 3.8 C#

  fast & light .NET ORM for strongly typed people

• linq2db.EntityFrameworkCore

  4 438 6.1 C#

  Bring power of Linq To DB to Entity Framework Core projects

  

• yuniql

  11 411 0.0 C#

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

• DacFx

  1 285 6.4 C#

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

  

• Musoq

  2 285 7.8 C#

  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

• bulk-writer

  2 237 0.0 C#

  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

  3 168 0.0 C#

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

• snowflake-connector-net

  1 168 8.9 C#

  Snowflake Connector for .NET

  

• CSVLint

  44 134 7.6 C#

  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

  www.saashub.com featured

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

  

C# SQL related posts

• Get SQL-Server Stored Procedures with C#

  2 projects | dev.to | 4 May 2024

• Show HN: Musoq, SQL like language with LLM experimental integrations

  1 project | news.ycombinator.com | 12 Feb 2024

• Working with Dapper/SQL-Server Framework 4.8 C#

  2 projects | dev.to | 27 Jan 2024

• Working with ListView in Windows Forms

  3 projects | dev.to | 13 Jan 2024

• Import data from a database with Dapper and SpreadsheetLight to Excel in C#

  2 projects | dev.to | 6 Nov 2023

• Working with Dapper in C#

  2 projects | dev.to | 30 Oct 2023

• Multiple Result Sets for SQL-Server (C#) including Dapper

  2 projects | dev.to | 2 Oct 2023
• A note from our sponsor - InfluxDB
  www.influxdata.com | 10 May 2024

  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. Learn more →

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

Do not miss the trending C# projects with our weekly report!