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

7 votes121 views6 answers
Laravel get current url
C#
0 vote119 views1 answer
Npm install --save vue-route@n
C#
0 vote130 views1 answer
Hashing a file in C#
C#
0 vote191 views1 answer
Unity random.insideunitcircle
C#Unity
0 vote153 views1 answer
Unity inspector draw line
C#Unity
1 vote120 views1 answer
Comapre Binary Trees
C#
0 vote126 views1 answer
Link form to a button in dashbord visual c#
C#
0 vote117 views1 answer
Xamarin Forms iOS Picker done
C#
0 vote121 views5 answers
123
C#
0 vote164 views1 answer
How to disable all other components in gameobject in unity
C#Unity