Raq query ef core

public static class Helper
{
    public static List<T> RawSqlQuery<T>(string query, Func<DbDataReader, T> map)
    {
        using (var context = new DbContext())
        {
            using (var command = context.Database.GetDbConnection().CreateCommand())
            {
                command.CommandText = query;
                command.CommandType = CommandType.Text;

                context.Database.OpenConnection();

                using (var result = command.ExecuteReader())
                {
                    var entities = new List<T>();

                    while (result.Read())
                    {
                        entities.Add(map(result));
                    }

                    return entities;
                }
            }
        }
    }

Source: stackoverflow.com

Similar codes

11 votes267 views3 answers
C# get all enum values
C#
1 vote261 views1 answer
C# read lines number 3 from string
C#
0 vote305 views1 answer
Lwjgl fullscreen
C#
0 vote266 views1 answer
Adb get android version
C#
0 vote315 views1 answer
Garbage collect every 30 frames unity
C#Unity
0 vote260 views1 answer
C# substring find word
C#
0 vote274 views1 answer
C++ printwindow chrome
C#
3 votes243 views1 answer
Unity how to get y value
C#
0 vote260 views1 answer
Asp net route attribute vs httpget
C#
13 votes280 views2 answers
Unity create gameobject from prefab in script
C#