ro31337

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Box
{
    public interface IAsset
    {

ro31337

...
      presence = case new_presence.type
                   when nil
			new_presence.show || :online
                   when :unavailable
			:unavailable
                   else
                     nil
                   end
...

ro31337

public class CompanyService
{
	// ...
	
	public Company GetById(long companyId)
	{
		return dbContext
			.Companies
			.FirstOrDefault(x => x.Id == companyId && !x.IsDeleted);
	}

ro31337

public class CompanyService
{
	// ...
	
	public Company GetById(long companyId)
	{
		return dbContext
			.Companies
			.FirstOrDefault(x => x.Id == companyId);
	}

ro31337

public class MyContext : DbContext
{
	public virtual IDbSet<Company> Companies { get; set; }

	protected override void OnModelCreating(DbModelBuilder modelBuilder)
	{
		modelBuilder.Entity<Company>()
			.Map(m => m.Requires("IsDeleted").HasValue(false))
			.Ignore(m => m.IsDeleted);
	}

ro31337

public class CompanyService
{
	// ...
	public Delete(long companyId)
	{
		var company = GetById(companyId);
		company.IsDeleted = true;
		database.SaveChanges();
	}
}

ro31337

public class CompanyService
{
	// ...
	public Delete(long companyId)
	{
		var company = GetById(companyId);
		company.DeletedAtUtc = DateTimeOffset.Now;
		database.Companies.Remove(company); // it's like we usually delete
		database.SaveChanges();
	}

ro31337

public class MyContext : DbContext
{
	//...
	
	public override int SaveChanges()
	{
		foreach (var entry in ChangeTracker.Entries()
				  .Where(p => p.State == EntityState.Deleted))
			SoftDelete(entry);

ro31337

private void SoftDelete(DbEntityEntry entry)
{
	Type entryEntityType = entry.Entity.GetType();

	string tableName = GetTableName(entryEntityType);
	string primaryKeyName = GetPrimaryKeyName(entryEntityType);

	string sql =
		string.Format(
			"UPDATE {0} SET IsDeleted = 1 WHERE {1} = @id",

ro31337

public partial class MyContext
{
	private static Dictionary<Type, EntitySetBase> _mappingCache =
		new Dictionary<Type, EntitySetBase>();

	private string GetTableName(Type type)
	{
		EntitySetBase es = GetEntitySet(type);

		return string.Format("[{0}].[{1}]",