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

3 votes351 views1 answer
Math operations in c#
C#
0 vote340 views1 answer
C# get all bytes of a file
C#
0 vote359 views1 answer
C# core linq savechanges invalid column name error while adding but not while updating
C#
0 vote337 views2 answers
C# distinct comparer multiple properties
C#
0 vote361 views1 answer
Setting the parent of a transform which resides in a prefab
C#
4 votes330 views1 answer
How to stop window from terminating c# visual studio
C#
0 vote354 views1 answer
String in char list f#
C#
0 vote335 views1 answer
Serial begin
C#
0 vote332 views1 answer
Connect to a database and loop over a recordset in C#
C#
0 vote329 views1 answer
C# web scraping get images from specific url
C#