ASP.Net Core database modelling without using existing ORMs?

• Npgsql

  15 3,157 9.4 C#

  Npgsql is the .NET data provider for PostgreSQL.

  

• SqlKata Query Builder

  5 2,997 2.6 C#

  SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird

  

Don'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

• 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.

  

• pdd-demo

  1 5 10.0 C#

  PostgreSQL Driven Development Demo Web Application With PgRoutiner, .NET and Svelte

  

• Norm.net

  11 175 8.3 C#

  Norm.net is an innovative and high-performance Database Access for .NET Standard 2.1 and higher

  

If you don't like writing PostgreSQL functions, that's fine, I can recommend this Micro ORM https://github.com/vb-consulting/Norm.net or Dapper which is currently way more popular. Still, pgroutiner can help you juggle all those scripts.

Suggest a related project