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

4 votes156 views1 answer
Changing euler angles unity
C#Unity
18 votes119 views3 answers
Kotlin random number
C#
13 votes125 views2 answers
What is public static void
C#
0 vote138 views1 answer
Add npm token to repo
C#
24 votes118 views1 answer
Csharp datetime string format
C#
5 votes147 views6 answers
Shuffle array c#
C#
0 vote121 views2 answers
C# tryparse int
C#
28 votes137 views2 answers
Unity check if gameobject is active
C#
0 vote127 views1 answer
Create app() import vue cli
C#
0 vote137 views1 answer
C# passing function as input delegate
C#