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. Learn more →
Top 23 C# SQL Projects
Dapper - a simple object mapper for .NetProject 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.
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/
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.
Stack Exchange's Monitoring System (by opserver)
Entity Framework Core Bulk Batch Extensions in .Net for Insert Update Delete Read (CRUD), Truncate and SaveChanges operations on SQL Server, PostgreSQL, MySQL, SQLiteProject 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)
Fluent migrations framework for .NETProject mention: How do you deal with merging Entity Framework feature migrations into your main branch? | reddit.com/r/dotnet | 2022-12-08
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 FirebirdProject mention: EF Core or Dapper | reddit.com/r/dotnet | 2023-03-10
SqlKata is your friend.
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 . 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 . 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.
 - https://github.com/mbdavid/LiteDB
Entity Framework Core provider for PostgreSQLProject 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 = MyBatis in C# + .NET Core+ Cache(Memory | Redis) + R/W Splitting + PropertyChangedTrack +Dynamic Repository + InvokeSync + Diagnostics
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.
Get SQL Server notification on record table change
fast & light .NET ORM for strongly typed people
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
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
Bring power of Linq To DB to Entity Framework Core projectsProject 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
Use SQL on various data sourcesProject mention: Can SQL be used without an RDBMS? | reddit.com/r/PHP | 2023-02-27
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.
A brand new, fast and lightweight ORM, build for PostgreSQL.
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 for .NETProject mention: Did anyone experience issues with their apps after migrating to OIE? | reddit.com/r/okta | 2023-01-20
MFA for ADFS 2022/2019/2016/2012r2
Dashing is a simple to use mini ORM built on top of Dapper (by AbstractLeap)
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
C# SQL related posts
SQL Connection Question
1 project | reddit.com/r/learncsharp | 20 Mar 2023
Is MSSQL Server the easiest sql database to integrate with a C# .NET application?
1 project | reddit.com/r/csharp | 3 Mar 2023
Stack Overflow is a cacheless, 9-server on-prem monolith
3 projects | news.ycombinator.com | 26 Feb 2023
ASP.Net Core database modelling without using existing ORMs?
4 projects | reddit.com/r/dotnet | 26 Jan 2023
How to Handle MSSQL Database in CI/CD?
3 projects | reddit.com/r/devops | 26 Jan 2023
Poll results, repository pattern over Entity Framework?
1 project | reddit.com/r/dotnet | 25 Jan 2023
Can I export database from PostgreSQL and connect it to my C# app?
1 project | reddit.com/r/learnprogramming | 5 Jan 2023
A note from our sponsor - SonarQube
www.sonarqube.org | 21 Mar 2023
What are some of the best open-source SQL projects in C#? This list will help you:
|7||SqlKata Query Builder||2,649|
|8||LINQ to DB||2,553|