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

13 votes173 views2 answers
What is public static void
C#
0 vote200 views2 answers
Linear search c#
C#
0 vote188 views1 answer
C# fill values of child from parent
C#
32 votes188 views4 answers
How to print using C#
C#
0 vote173 views1 answer
Kendo razor textbox
C#
0 vote191 views1 answer
Convert list string to list enum c#
C#
0 vote172 views1 answer
C# windows application get current path
C#
7 votes246 views2 answers
How to reference text mesh pro unity
C#
1 vote262 views2 answers
Valid url in .net
C#
3 votes176 views2 answers
Get directory of file c#
C#