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

• SqlMarshal

  3 46 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

• InfluxDB

  www.influxdata.com featured

  Purpose built for real-time analytics at any scale. InfluxDB Platform is powered by columnar analytics, optimized for cost-efficient storage, and built with open data standards.

  

• NReco.Data

  1 184 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').

Suggest a related project