Executing Raw sql with Entity Framework Core

ADO.NET works in EFCore =)

using Microsoft.EntityFrameworkCore;
using System.Data.Common;
using System.Data.SqlClient;
using System;

    public void ExampleMethod(DbContext context)
    {
        SomeObjectResult result = null;
        DbCommand cmd = context.Database.GetDbConnection().CreateCommand();
        cmd.CommandText = "Select C.ID, C.CarModelID as ModelID, C.VIN, C.RegNumber,cast(C.CountValue as int) as Course,A.BrandID from   A inner join C on A.ID = C.KeyID  Where A.ID = @appID";
        cmd.Parameters.Add(new SqlParameter("@appID", appointmentID));
        if (cmd.Connection.State != ConnectionState.Open)
        {
            cmd.Connection.Open();
        }
        using (var reader = await cmd.ExecuteReaderAsync())
        {
            if (reader.Read())
            {
                result = new SomeObjectResult()
                {
                    BrandID = (int)reader["BrandID"],
                    Course = (int)reader["Course"],
                    ID = (int)reader["ID"],
                    ModelID = (int?)reader["ModelID"],
                    RegNumber = (string)reader["RegNumber"],
                    VIN = (string)reader["VIN"]
                };
            }
        }
    }