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

31 votes330 views4 answers
C# string to datetime
C#
7 votes333 views1 answer
C# count number of occurrences in string
C#
0 vote301 views1 answer
Character stay in ground unity 3d
C#
0 vote296 views1 answer
Asp.net core authorization default policy
C#
0 vote406 views1 answer
C# process start
C#
1 vote359 views1 answer
C# how to output in between 0 - 100 in an int array
C#
0 vote310 views1 answer
Anidate bucle in c#
C#
0 vote318 views1 answer
Data annotations in asp.net core
C#
0 vote299 views1 answer
Resharper render pages folder asp.net core
C#
1 vote306 views1 answer
Space custom inspector
C#