Implementation of the Global Query Filters, Multitenant and Soft Delete, in EF Core.

public partial class MasterContext : DbContext
{
	public Guid TenantId { get; set; }
	public List<Guid> _tenantIds;
	public bool isAllActive; // this is for the scenario in which the tenant wants all the data , softdeleted rows and active rows
	public int hashCode;

	partial void OnModelCreatingFilters(ModelBuilder modelBuilder)
	{
		// this is a global filter filter to check if has IsDeleted and TenantIds columns
		foreach (var entityType in modelBuilder.Model.GetEntityTypes())
		{
			var isDeletedProperty = entityType.FindProperty("IsDeleted");
			var tenantIdProperty = entityType.FindProperty("TenantId");

			// if we have both IsDeleted and TenantId columns ( with IsDeleted not being supressed )
			if (((isDeletedProperty != null) && (tenantIdProperty != null))
					&& isDeletedProperty.ClrType == typeof(bool) && !isAllActive)
			{
				var parameter = Expression.Parameter(entityType.ClrType, "p");

				//is deleted
				var filterIsDeleted = Expression.Equal(Expression.Property(parameter, isDeletedProperty.PropertyInfo)
													  , Expression.Constant(false, typeof(bool)));

				// check if there are any tenants 
				if (_tenantIds != null)
				{
					// we are parsing the first element from the list just pe sure we have some
					var tenantid = _tenantIds.First();
					var filterTenantId = Expression.Equal(Expression.Property(parameter, tenantIdProperty.PropertyInfo)
												, Expression.Constant(tenantid, typeof(Guid)));

					//move to a different List so we dont affect the main list
					//beware of the shallow copy
					List<Guid> localtenantIds = new List<Guid>(_tenantIds);
					localtenantIds.Remove(tenantid);

					//loop interation for all the remaining tenantids
					foreach (var tenantidloop in localtenantIds)
					{
						filterTenantId = Expression.Or(filterTenantId, Expression.Equal(Expression.Property(parameter, tenantIdProperty.PropertyInfo)
											   , Expression.Constant(tenantidloop, typeof(Guid))));

					}

					//combine both filters
					MutableEntityTypeExtensions.SetQueryFilter(entityType, Expression.Lambda(Expression.And(filterIsDeleted, filterTenantId), parameter));
				}
				//dummy filtering so we exclude all other tenants
				else
				{
					var tenantid = new Guid("00000000-0000-0000-0000-000000000000");
					var filterTenantId = Expression.Equal(Expression.Property(parameter, tenantIdProperty.PropertyInfo)
												, Expression.Constant(tenantid, typeof(Guid)));

					//combine both filters
					MutableEntityTypeExtensions.SetQueryFilter(entityType, Expression.Lambda(Expression.And(filterIsDeleted, filterTenantId), parameter));
				}
			}
			else
			{
				// this is a global filter to check if the object has IsDeleted column
				if (((isDeletedProperty != null) && (tenantIdProperty == null)) // delete without tenant
				 && isDeletedProperty.ClrType == typeof(bool))
				{
					var parameter = Expression.Parameter(entityType.ClrType, "p");

					//is deleted only
					var filterIsDeleted = Expression.Equal(Expression.Property(parameter, isDeletedProperty.PropertyInfo)
														  , Expression.Constant(false, typeof(bool)));

					MutableEntityTypeExtensions.SetQueryFilter(entityType, Expression.Lambda(filterIsDeleted, parameter));
				}
				else
				{
					// this is a global filter to check if the object has TenantId column 
					if ((((isDeletedProperty == null) && (tenantIdProperty != null)) // tenant without delete
					 && isDeletedProperty.ClrType == typeof(bool)) ||
					 (((tenantIdProperty != null)) && isAllActive))  // tenant with supressed delete 

					{
						var parameter = Expression.Parameter(entityType.ClrType, "p");
						// check if there are any tenants
						if (_tenantIds.Any())
						{
							// we are parsing the first element from the list just pe sure we have some
							var tenantid = _tenantIds.First();
							var filterTenantId = Expression.Equal(Expression.Property(parameter, tenantIdProperty.PropertyInfo)
														, Expression.Constant(tenantid, typeof(Guid)));
							_tenantIds.Remove(tenantid);

							//loop interation for all the remaining tenantids
							foreach (var tenantidloop in _tenantIds)
							{
								filterTenantId = Expression.Or(filterTenantId, Expression.Equal(Expression.Property(parameter, tenantIdProperty.PropertyInfo)
													   , Expression.Constant(tenantidloop, typeof(Guid))));

							}

							//combine both filters
							MutableEntityTypeExtensions.SetQueryFilter(entityType, Expression.Lambda(filterTenantId, parameter));
						}
					}
				}
			}
		}
	}
}