Top 23 C# SQL Projects

• Dapper

  44 17,205 8.3 C#

  Dapper - a simple object mapper for .Net

  

Project mention: C# PeriodicTimer | dev.to | 2024-05-26

Learn how to use a PeriodicTimer in a code sample that fires off a PeriodicTimer every 15 seconds, retrieves a random record from a SQLite Northwind database using Dapper (EF Core would be overkill here).

• Bitwarden

  1,058 14,472 9.8 C#

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

  

Project mention: Online Safety: A Guide to Protecting Yourself | dev.to | 2024-05-20

While not every site has adopted passwordless logins, a better way to secure your accounts that still use passwords is by using a password manager like Bitwarden or 1Password. They help you create strong, unique passwords and remember them easily. Most password managers come with autofill features that make it easy to use across devices.

• 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,491 4.5 C#

  Stack Exchange's Monitoring System (by opserver)

  

• EFCore.BulkExtensions

  16 3,513 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

  16 3,180 9.4 C#

  Npgsql is the .NET data provider for PostgreSQL.

  

Project mention: Server-side cache for YugabyteDB sequences to workaround the Nspgl `DISCARD SEQUENCES` | dev.to | 2024-05-16

DISCARD SEQUENCES is useless and not scalable #5705

• FluentMigrator

  9 3,153 8.9 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,021 1.9 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,878 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,472 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,051 5.0 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 646 0.0 C#

  Get SQL Server notification on record table change

• sqlnotebook

  1 589 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 497 1.4 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 441 6.1 C#

  Bring power of Linq To DB to Entity Framework Core projects

  

• yuniql

  11 412 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 288 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 287 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 138 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

• C# PeriodicTimer

  3 projects | dev.to | 26 May 2024

• Building business processes with Azure Durable Functions

  2 projects | dev.to | 14 May 2024

• 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
• A note from our sponsor - SaaSHub
  www.saashub.com | 30 May 2024

  SaaSHub helps you find the best software and product alternatives 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!