.NET developer blog

Quote of the Day

more Quotes

All posts in "Database"

Building multitenant application – Part 1: Multitenant database using Row Level Security

Published July 29, 2022 in ASP.NET core , Azure , Azure SQL database , Database

In this and upcoming posts, I’ll be sharing what I have learned while implementing a multi-tenant solution. Specifically, in this post, I share my understanding about Row Level Security in SQL server, and how I have utilized it to host data for multiple organizations in a way that is transparent to the users.

Tags: multi-tenant , row-level-security , security-policy , sql-server , table-value-function

Connect to Oracle database from .NET core application.

Published September 26, 2020 in .NET core , ASP.NET core , Database , Oracle

In this post, I go over using Oracle .NET core libraries to connect to Oracle database. In particular, we’ll look at the Oracle.ManagedDataAccess.Core and the Oracle.EntityFrameworkCore.

Tags: dbcontext , entity-framework-core , oracle entity framework core , oracle managed data access core