For new projects, do you prefer EF, ADO, Dapper or something else?

• SqlMarshal

  3 44 3.2 C#

  Generates data access using stored procedures

After writing SQL, I prefer to interface with dotnet code via auto-generated types. This gives type safety compared to Dapper and manually generated ADO. I just posted an issue giving some libraries which do this here: https://github.com/kant2002/SqlMarshal/issues/4

• NReco.Data

  1 181 4.3 C#

  Fast DB-independent DAL for .NET Core: abstract queries, SQL commands builder, schema-less data access, POCO mapping (micro-ORM). (by nreco)

  

We 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').

• InfluxDB

  www.influxdata.com sponsored

  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.

  

Suggest a related project