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 vote311 views1 answer
C# getting response content from post
C#
9 votes396 views2 answers
How to change textMesh Pro unity
C#Unity
0 vote298 views1 answer
Unity download image from web
C#Unity
0 vote388 views1 answer
C# get all letters
C#
-1 vote349 views1 answer
C# resize image from byte array
C#
0 vote331 views1 answer
Unity roam, chase, attack states
C#
7 votes323 views2 answers
Set focus ui unity
C#
5 votes332 views3 answers
Vb.net add row to datagridview programmatically
C#
0 vote324 views1 answer
Decrease image size C#
C#
0 vote333 views1 answer
Google sheets problems cell not considered even
C#