Simple cases (query a single view/table fully, or get one item, mutate and save): ORM (EF core) More complex queries or needing only a scalar value: Raw SQL vi

Simple cases (query a single view/table fully, or get one item, mutate and save): ORM (EF core) More complex queries or needing only a scalar value: Raw SQL via dapper.