public static int GetLastInsertedId(this ITransformationProvider migration)
        {
            var query  = "SELECT @@IDENTITY";
            var result = migration.ExecuteScalar(query);

            return(int.Parse(result.ToString()));
        }