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 vote261 views1 answer
C# bool list count true
C#
0 vote280 views1 answer
C# How to change the text colour?
C#
0 vote279 views1 answer
SendFileAsync discord
C#
0 vote297 views1 answer
How to detach the camera from the player after death unity
C#Unity
1 vote281 views4 answers
C# timestamp now
C#
0 vote281 views1 answer
C# create delegate type at runtime
C#
0 vote294 views1 answer
Log4net.config configuration
C#
4 votes325 views1 answer
How to destroy a gameobject in c#
C#
-2 votes296 views2 answers
Exception
C#
0 vote316 views1 answer
How to turn camera space to world space unity
C#Unity