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

0 vote165 views1 answer
How to store user input into list c#
C#
0 vote156 views1 answer
Js if empty then 0
C#
0 vote154 views1 answer
Declare multiple variables in for loop c#
C#
1 vote170 views1 answer
String formatting of spacing with c#
C#
20 votes163 views3 answers
Player movement unity 3d script
C#
0 vote196 views1 answer
Add values to dictionary c# while initializing
C#
1 vote199 views1 answer
Unity editor dropdown
C#
0 vote144 views1 answer
Convert string to short c#
C#
0 vote174 views2 answers
Prime number algorithm
C#
44 votes183 views5 answers
Create list C#
C#