Breaking News: Grepper is joining You.com. Read the official announcement!

raq query ef core

Successful Salamander answered on November 17, 2021 Popularity 9/10 Helpfulness 2/10

answer raq query ef core

raq query ef core

Comment

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;
                }
            }
        }
    }

Popularity 9/10 Helpfulness 2/10 Language csharp

Source: stackoverflow.com

Tags: c# core

Link to this answer
Share Copy Link