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

5 votes141 views2 answers
Unity hide in inspector
C#
0 vote152 views1 answer
Unity master volume changer
C#
0 vote145 views1 answer
Index was out of the bound array in c#
C#
0 vote168 views1 answer
*ngif vs ngif
C#
27 votes143 views5 answers
Length of a string c#
C#
1 vote178 views1 answer
C# read array of objects from formdata
C#
2 votes126 views1 answer
But dotnet-ef does not exist.
C#
3 votes107 views2 answers
C# get directory files
C#
0 vote170 views1 answer
Mongodb custom IIdGenerator
C#
0 vote150 views4 answers
Read csv file into wpf C#
C#