public static IEnumerable <TEntity> GetHistory <TEntity>(this RvuPiecemakerContext context, int id) where TEntity : class
{
string tableName = typeof(TEntity).Name.ToString();
var schema = context.Model.FindEntityType(typeof(TEntity)).SqlServer().Schema;
var sql = $"SELECT * FROM [{schema}].[{tableName}History] WHERE Id = {id}";
return(context.Set <TEntity>().FromSql(sql));
}
public LookupRepository(RvuPiecemakerContext context)
{
_context = context;
}
