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 vote270 views1 answer
Select a whole row out of a 2d array C#
C#
14 votes244 views2 answers
Play animation through script unity
C#
0 vote263 views1 answer
C# merge two lists as queryable
C#
41 votes267 views6 answers
Prime Numbers
C#
3 votes238 views1 answer
Winforms yes no dialog
C#
0 vote272 views1 answer
C# PrincipalContext The network path was not found
C#
2 votes236 views1 answer
Parse excel file to class object c#
C#
2 votes290 views1 answer
How to edit Camera.size property unity
C#Unity
1 vote305 views1 answer
Change size of a unity object
C#Unity
1 vote282 views1 answer
Ultimate space cruiser
C#