Top 3 C# data-access-layer Projects
-
Bogus
:card_index: A simple fake data generator for C#, F#, and VB.NET. Based on and ported from the famed faker.js.
Going forward, the secret to knowing were to find data is to read Bogus information in the readme file which goes into depth were to find paths to generate data. This is very important as you can clash with their classes e.g. you create a Person class and guess what, Bogus has a Person class. This is were knowing how to work with using statements and using statements with aliasing.
-
SqlKata Query Builder
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
Project mention: ASP.Net Core database modelling without using existing ORMs? | reddit.com/r/dotnet | 2023-01-26Don't know if can be a good pick for the no-ORM requirement but I would take a look at SqlKata which is a nice query builder + execution engine, built on top of Dapper
-
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.
-
NReco.Data
Fast DB-independent DAL for .NET Core: abstract queries, SQL commands builder, schema-less data access, POCO mapping (micro-ORM). (by nreco)
Project mention: For new projects, do you prefer EF, ADO, Dapper or something else? | reddit.com/r/dotnet | 2022-03-29We use https://github.com/nreco/data in our products, similar to Dapper but with built-in SQL generation for CRUD-queries (it is very easy to compose filters in run-time) + hand-written SQL may be concentrated in one place (app-level 'dataviews').
C# data-access-layer related posts
Index
What are some of the best open-source data-access-layer projects in C#? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Bogus | 6,689 |
| 2 | SqlKata Query Builder | 2,586 |
| 3 | NReco.Data | 171 |