.NET developer blog

Tag Archives for " entity framework "

Building multitenant application – Part 2: Storing value into database session context from ASP.NET core web API

Published August 13, 2022 in .NET , .NET core , ASP.NET core , Azure SQL database

In the previous post about row level security in SQL server, I gave an example of reading a value from the database session context to feed into the security function for filtering data. In this post, I show examples of calling the sp_set_session_context store procedure from an ASP.NET core web API to store a value into the session context.

Tags: entity framework , entity framework core , multitenant , row level security , session context , sql server

Three essential libraries for unit testing a .NET project

Published July 31, 2021 in .NET , .NET core , ASP.NET core , C# , Testing

In this post, I share the three libraries I find useful for unit testing a .NET project: EF Core SQLite Database Provider, Bogus and Moq.

Tags: bogus , entity framework , entity framework core , moq , sqlite , tdd , unit testing