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 vote118 views1 answer
Unhandled exception. System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Bcl.AsyncInterfaces, Version=1.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. The system cannot find the file specified.
C#
0 vote79 views1 answer
Unity error creating asset at path
C#
0 vote122 views2 answers
IdentityModelEventSource.ShowPII
C#
6 votes76 views1 answer
C# ide online
C#
3 votes147 views2 answers
Unity instantiate empty gameobject
C#Unity
2 votes131 views1 answer
Join array element in c#
C#
0 vote123 views1 answer
C# parallel for loop specify cores
C#
1 vote160 views1 answer
Convert dto to dictionary c#
C#
5 votes130 views1 answer
C# make request to rest api
C#
1 vote122 views1 answer
How to append a new line in a txt file c#
C#