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 vote339 views1 answer
How to uncheck a radio button in c#
C#
8 votes387 views3 answers
C# combobox selectedvalue
C#
0 vote321 views1 answer
How to play a random sound at the position that you want in unity
C#
0 vote366 views1 answer
Chrome devtools capture all styling an element uses
C#
31 votes385 views3 answers
Get key unity
C#Unity
0 vote352 views1 answer
Asp.net disabled checkbox style
C#
2 votes321 views2 answers
Unity how get random color to material
C#
0 vote348 views1 answer
Cefsharp not passing keydown to form
C#
0 vote342 views4 answers
Custom attribute for auth permission check .net
C#
0 vote348 views1 answer
Excute same code mvc
C#