RawSqlExecute in ASP.NET Core with EntityFramework Core 1.0

RawSqlExecute.cs

public class RawSqlExecute
{
	/// <summary>
	/// Plain text sql query to a list that can easaly be transformed to a json object
	/// </summary>
	/// <param name="dataContext"></param>
	/// <param name="sql"></param>
	/// <returns>Dynamic list</returns>
	public static List<dynamic> GetDynamicResults(
		DataContext dataContext,
		string sql)
	{
		using (var command = dataContext.Database.GetDbConnection().CreateCommand())
		{
			command.CommandText = sql;

			if (command.Connection.State != ConnectionState.Open)
			{
				command.Connection.Open();
			}

			return GetRecords(command);
		}
	}

	/// <summary>
	/// Stored Procedure with SqlParameters to a list that can easaly be transformed to a json object
	/// </summary>
	/// <param name="dataContext"></param>
	/// <param name="storedProcedureName"></param>
	/// <param name="sqlParameters"></param>
	/// <returns>Dynamic list</returns>
	public static List<dynamic> GetDynamicResults(
		DataContext dataContext,
		string storedProcedureName,
		List<SqlParameter> sqlParameters)
	{
		using (var command = dataContext.Database.GetDbConnection().CreateCommand())
		{
			command.CommandText = storedProcedureName;
			command.CommandType = CommandType.StoredProcedure;
			command.Parameters.AddRange(sqlParameters.ToArray());

			if (command.Connection.State != ConnectionState.Open)
			{
				command.Connection.Open();
			}

			return GetRecords(command);
		}
	}

	private static List<dynamic> GetRecords(DbCommand command)
	{
		var records = new List<dynamic>();

		using (var dataReader = command.ExecuteReader())
		{
			while (dataReader.Read())
			{
				var dataRow = new ExpandoObject() as IDictionary<string, object>;
				for (var i = 0; i < dataReader.FieldCount; i++)
				{
					var name = dataReader.GetName(i);
					var value = dataReader[i]?.ToString();
					dataRow.Add(name, value);
				}

				records.Add((ExpandoObject) dataRow);
			}
		}

		return records;
	}
}