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 vote209 views1 answer
C# timer 30 seconds
C#
0 vote197 views1 answer
C# obsolete class
C#
3 votes224 views1 answer
Specified key was too long; max key length is 1000 bytes (SQL: alter table `permissions` add unique `permissions name guard_name_unique`(`name`, `guard_name`))
C#
3 votes201 views2 answers
C# Select MSSQL
C#
0 vote214 views1 answer
Type or namespace text could not be found unity
C#Unity
0 vote249 views1 answer
.net disable show exception
C#
0 vote185 views1 answer
Index was out of the bound array in c#
C#
0 vote195 views1 answer
C# do while or
C#
4 votes179 views1 answer
How to sort string array alphabetically in c#
C#
1 vote208 views1 answer
C# virtual keyword
C#