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
-
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.
-
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.
-
-
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
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)
-
Project mention: How do you deal with merging Entity Framework feature migrations into your main branch? | reddit.com/r/dotnet | 2022-12-08
-
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
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.
-
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.
-
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
-
If you want to stay in C# land, look at Evolve.
-
-
-
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-24Here's one that with the hotfix. https://github.com/rdagumampan/yuniql/releases/download/v1.3.15/yuniql-cli-win-x64-v1.3.15.zip
-
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
-
-
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.
-
-
DacFx
SQL Server database schema validation, deployment, and upgrade runtime. Enables declarative database development and database portability across SQL Server versions and environments.
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.
-
Project mention: Did anyone experience issues with their apps after migrating to OIE? | reddit.com/r/okta | 2023-01-20
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
C# SQL related posts
- SQL Connection Question
- Is MSSQL Server the easiest sql database to integrate with a C# .NET application?
- Stack Overflow is a cacheless, 9-server on-prem monolith
- ASP.Net Core database modelling without using existing ORMs?
- How to Handle MSSQL Database in CI/CD?
- Poll results, repository pattern over Entity Framework?
- Can I export database from PostgreSQL and connect it to my C# app?
-
A note from our sponsor - SonarQube
www.sonarqube.org | 21 Mar 2023
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 |