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

2 votes117 views1 answer
Ngrok for asp.net core
C#
0 vote121 views2 answers
Append multi lines to file linux
C#
1 vote116 views1 answer
C# set a guid
C#
8 votes109 views4 answers
C# get last two characters of string
C#
0 vote124 views1 answer
Automapper.automappermappingexception: 'error mapping types.' .net.core site:forums.asp.net
C#
2 votes119 views1 answer
Enable hibernate in windows 10
C#
0 vote92 views1 answer
Freeze time unity 2d script
C#Unity
0 vote120 views1 answer
C# Case insensitive Contains(string)
C#
1 vote116 views1 answer
Unity detect if version is a build or in editor
C#
0 vote137 views1 answer
Hur delar man upp en e post på string c#
C#